How to implement tSQLDWHBulkExec component?

Six Stars

How to implement tSQLDWHBulkExec component?

Our source data is coming from Salesforce and want to load into SQL Azure Database.  

When we try to connect tSalesforceInput to tSQLDWBulkExec, it doesn't allow us to do that.

Can someone let me know what are the steps in the job creation to use tSQLDWBulkExec in my scenario.  Our company prefers that we use tSQLDWBulkExec component to faster load into the Azure database.  


Accepted Solutions
Seven Stars

Re: How to implement tSQLDWHBulkExec component?

Hi @rp2018 ,

 

I am not sure about this component. 

 

try the below links which may be useful.,

https://help.talend.com/reader/dN2zLciENW2Mx7NyQXkLwg/k6Y_hlh6TVcgnkr8TL2ZfQ 

https://community.talend.com/t5/How-Tos-and-Best-Practices/How-to-guide-Bulk-Insert-to-Azure-SQL-Ser...

 

Thanks,

Joe

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post


All Replies
Seven Stars

Re: How to implement tSQLDWHBulkExec component?

Hi @rp2018 ,

 

I am not sure about this component. 

 

try the below links which may be useful.,

https://help.talend.com/reader/dN2zLciENW2Mx7NyQXkLwg/k6Y_hlh6TVcgnkr8TL2ZfQ 

https://community.talend.com/t5/How-Tos-and-Best-Practices/How-to-guide-Bulk-Insert-to-Azure-SQL-Ser...

 

Thanks,

Joe

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

View solution in original post

Five Stars

Re: How to implement tSQLDWHBulkExec component?

I am not able to find tSQLDWHBulkExec in any documentation ? Which Talend version are you using ? Using my experience from Salesforce components , you can't connect tSalesforceInput and tSQLDWHBulkExec directly. Either first write the extract in a file and use tSQLDWHBulkExec or find some component like tSQLDWHOutputBulkExec that you can directly connect to tSalesforceInput. 

Regards , 

Vatsal.

Don't forgive to give Kudos if my reply helps.

 

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog