topic tSalesforceOutputBulkExec in Talend Studio

tSalesforceOutputBulkExec

_AnonymousUser — Sat, 16 Nov 2024 11:16:39 GMT

Hello
I am issues writing data to Salesforce, I have tried tSalesforceBulkExec but encountered an Invalid Batch error, which I cannot seem to figure out the issue.
So I decided to look at tSalesforceOutputBulkExec, but I cannot understand how the flow is suppose to work.
.
So I am reading data from a SQL Database. I write the data out to text delimited file.
Now how am I suppose to process the file with the tSalesforceOutputBulkExec component?
I have tFileInputDelimited with a main flow to tSalesforceOutputBulkExec component. What am I suppose to specify in the Directory setting? (Bulk file path)? If in tFileInputDelimited points to C:\Test.csv, is this also suppose to be specified?
Thank you.

Re: tSalesforceOutputBulkExec

Anonymous — Thu, 26 Mar 2015 08:42:51 GMT

Hi,
Have you already checked component reference:TalendHelpCenter:tSalesforceOutputBulkExec with a related scenario?
Best regards
Sabrina

Re: tSalesforceOutputBulkExec

_AnonymousUser — Thu, 26 Mar 2015 15:30:13 GMT

Yes, I read the documentation before hand but I am still unclear how to implement that is why I posted here. If someone can point in the right direction.

Re: tSalesforceOutputBulkExec

_AnonymousUser — Thu, 26 Mar 2015 15:34:01 GMT

This is the line that is confusing to me.
Directory where are stored the bulk data you need to process
When I use tFileInputDelimited, this will read the data and flow it to the tSalesforceOutputBulkExec component. Is this correct? So I am unclear what needs to be specified in the Bulk File Path, I have tired the same file path as it used on tFileInputDelimited and have also just specified the directory where the file is located.
Thanks.

Re: tSalesforceOutputBulkExec

_AnonymousUser — Thu, 26 Mar 2015 15:43:36 GMT

One more question on this, what I need to understand is the role of tFileInputDelimited and Bulk File Path. When I execute I see 0 rows being processed from tFileInputDelimited to tSalesforecOutputBulkExec, so does tSalesforceOutputBulkExec just use the Bulk File Path to get the file and reads directly from there without the need of tFileInputDelimited?
Thanks

Re: tSalesforceOutputBulkExec

_AnonymousUser — Thu, 26 Mar 2015 17:09:29 GMT

HI Hipercept1,
If you are moving data from SQL, design should be like this. No need to have tfiledelimited as input.
tMSSqlInput --> tmap --> tsalesforceOUtputBulk (in the File Name field specify the path and file name)
tSalesforceBulkExec ----------> tfileoutputDelimited (for successful)
----------> tfileoutputDelimited (for reject)

In tSalesforceBulkExec component, Bulk file path field should contain the path/file name as it is in tsalesforceoutputBulk.
Thanks,
Nachiyappan.L

Re: tSalesforceOutputBulkExec

_AnonymousUser — Thu, 26 Mar 2015 17:23:26 GMT

Thanks
I have implemented that design. But I would like to understand the design required for tSalesforceOutputBulkExec for future reference.
Regards
Derek