topic tSalesforceinput and tSalesforceBulkExec in Talend Studio

tSalesforceinput and tSalesforceBulkExec

Parikhharshal — Sat, 16 Nov 2024 07:38:45 GMT

Hi Talend Experts

I am using tSalesforceinput component where I am grabbing simple ID from one of the table from salesforce. The reason I am doing this is to read Source (In my case it is Salesforce) and Target table (Database table) to identify Deleted records.

When I use tSalesforceinput component batch size is set to 250 which is making too slow to read and process records. Is there any faster way to do or use BulkExec component? I really dont know how to use bulkexec component and does it really do any better.

Thanks

Harshal.

Re: tSalesforceinput and tSalesforceBulkExec

manodwhb — Mon, 17 Sep 2018 06:06:25 GMT

@Parikhharshal,tSalesforceinput component is used to read data from Saleforce and if you have not tired Bulk with Parallel mode ,you can use and see how it was working.

tSalesforceOutputBulk and tSalesforceBulkExec components are used together to output the needed file and then execute intended actions on the file for your Salesforce.com

To know more about tSalesforceinput and tSalesforceBulkExec ,check below links.

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/RQYpl5Lqf4_Xen_h3qCM1g

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Tdf_WzwhVSkZ_OwYctAekg

Re: tSalesforceinput and tSalesforceBulkExec

Parikhharshal — Mon, 17 Sep 2018 06:09:29 GMT

Hi Manodwhb

Thanks a lot for your reply.

Not sure how I would use in my scenario as I have to read rows from Salesforce.

If you have some sample design to show that would be fantastic.

Thanks
Harshal.

Re: tSalesforceinput and tSalesforceBulkExec

manodwhb — Mon, 17 Sep 2018 06:38:46 GMT

@Parikhharshal,the you can fine in below link. check for Scenario: Using queries to extract data from a Salesforce database.

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/Tdf_WzwhVSkZ_OwYctAekg

Re: tSalesforceinput and tSalesforceBulkExec

Parikhharshal — Mon, 17 Sep 2018 06:43:29 GMT

Hi Manohar

I looked at the link but that doesnt help me as there is nothing mentioned like how I can use Bulk and salesforceinput together and work.

Thanks
Harshal.

Re: tSalesforceinput and tSalesforceBulkExec

manodwhb — Mon, 17 Sep 2018 06:55:51 GMT

@Parikhharshal,i am attaching the settings for Bulk query,please use the below way.

Re: tSalesforceinput and tSalesforceBulkExec

Parikhharshal — Mon, 17 Sep 2018 07:09:05 GMT

Can I directly use this and connect to tmap?

Re: tSalesforceinput and tSalesforceBulkExec

Parikhharshal — Mon, 17 Sep 2018 07:14:41 GMT

Hi Manohar

Can you please post job design for reference if possible?

I did get SealsforceBulkExec and it shows me like this:

I am using 6.4. Are you using different one?

Thanks

Harshal.

Re: tSalesforceinput and tSalesforceBulkExec

TRF — Tue, 18 Sep 2018 15:44:27 GMT

tSalesforceOutputBulkExec is here to write data into salesforce.

Use tSalesforceInput instead and select Bulk for the Query mode: