topic Re: Salesforce data Bulk load into csv file in Talend Studio

Salesforce data Bulk load into csv file

Anonymous — Sat, 16 Nov 2024 09:02:48 GMT

Hi,

Is there any way to load bulk data into .csv file from Salesforce.

I tried using tSalesforceInput->tFilrOutputDelimted, but process taking too much time.

Please help me.

Re: Salesforce data Bulk load into csv file

TRF — Fri, 17 Nov 2017 08:26:03 GMT

Hi,

Did you try to select Bulk for the Query Mode of tSalesforceInput component?

Re: Salesforce data Bulk load into csv file

Anonymous — Fri, 17 Nov 2017 10:52:06 GMT

Hi TRF,

I tried Bulk query mode in tSalesforceInput, but no difference.

Re: Salesforce data Bulk load into csv file

TRF — Fri, 17 Nov 2017 11:28:06 GMT

How many records are you trying to retrieve?

How long it takes?

Re: Salesforce data Bulk load into csv file

Anonymous — Fri, 17 Nov 2017 11:41:30 GMT

Hi TRF,

Job has taken 34 Minutes to fetch 4318149 Records.

Is there any other method to import bulk data from Salesforce??

Re: Salesforce data Bulk load into csv file

TRF — Fri, 17 Nov 2017 11:48:52 GMT

Seems a little bit long, but remember you're not querying a local database (I'm sure you know that).

You can compare result using DataLoader.

Also, be sure there network is not the cause of the problem.

What if you change the schema to get only the Salesforce Id (will reduce the transfer volume)?

Re: Salesforce data Bulk load into csv file

Anonymous — Fri, 17 Nov 2017 11:58:38 GMT

Hi TRF,

I am fetching only 3 columns and all those columns are required.

Re: Salesforce data Bulk load into csv file

TRF — Fri, 17 Nov 2017 12:22:19 GMT

OK, so the record size is not the reason.
So can you just try using DataLoader.
It should take the same time.
Interesting to know.
Then, to be sure the network is not the reason, can you try from an other place (using an other internet connection) ?

Re: Salesforce data Bulk load into csv file

Anonymous — Tue, 21 Nov 2017 05:24:50 GMT

Hi TRF,

Apologies! Since this is in Prod environment, I am unable to use Data Loader and I am a Talend developer, that's why they allowed me to use Talend in Prod env.

Anyway thanks for the help.