BusinessObjects Board

Extraction from Sales Force

Hello,

We would like to extract 30 millions from Sales force table to Teradata through Data services. For 1 million it takes 1 hr to load, so in total it takes 30 hrs to load. Its a straight forward load with a where condition and no joins or look ups

Could you please let us know what are various options to improve the performance so that it can load under 5- 6 hrs.

Thanks in Advance.

Thanks
Krishna


kris2727 (BOB member since 2010-07-28)

Very old but just so that it could be used by someone in future.

From my perspective do you really want to use DS to extract data from Salesforce because if you see the webservice version provided out of the box in the adapter and the webservice version currently recommended by Salesforce is significant.

Salesforce in itself provided connectors / API’s performing far better and I believe those could / should be used.

Cheers.
Shaz


Shazin :india: (BOB member since 2011-07-19)