BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: No events within the next 45 days.

Extraction from Sales Force


 
Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
kris2727
Senior Member
Senior Member



Joined: 28 Jul 2010

Posts: 66



PostPosted: Wed Aug 03, 2016 10:20 pm 
Post subject: 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
Back to top
Shazin
Principal Member
Principal Member



Joined: 19 Jul 2011

Posts: 284
Location: India


flag
PostPosted: Thu Oct 26, 2017 1:07 am 
Post subject: Re: Extraction from Sales Force

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
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0261 seconds using 17 queries. (SQL 0.0026 Parse 0.0008 Other 0.0227)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo