How to implement tSQLDWHBulkExec component?

[rp2018]

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.  

[joearun4u · Accepted solution]

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.

[vatsal_ras]

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.