tSalesforceinput and tSalesforceBulkExec

[Parikhharshal]

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.

[manodwhb]

@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

[Parikhharshal]

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.

[manodwhb]

@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

[Parikhharshal]

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.

[manodwhb]

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

[Parikhharshal]

Can I directly use this and connect to tmap?

[Parikhharshal]

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.

[TRF · Accepted solution]

tSalesforceOutputBulkExec is here to write data into salesforce.

Use tSalesforceInput instead and select Bulk for the Query mode: