function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
GAURAV SETHGAURAV SETH 

Options and considerations for integration to the external system for LDV

When a status field for the  LDV (Large Data Volume) object is set to "Complete" data from the object and fields from related lookup objects needs to be sent to an on premise system. What are options and considerations for integration to the external system? 
I know best way to integrate LDV object is using Bulk API but should we do the same in the above scenario?
AnudeepAnudeep (Salesforce Developers) 
Hi Gaurav -  Bulk API is the recommended way in your scenario.

If the number of records you need to extract is in the millions, the first step in resolving this issue is to split or “chunk” the transaction into smaller pieces so that each request does not time out. After doing that, make each of the smaller requests complete faster, then run the requests in parallel to compress the overall time it takes to extract all of the data.

I suggest going through the following resources to learn more

https://trailhead.salesforce.com/en/content/learn/v/modules/large-data-volumes/perform-data-deletes-and-extracts

https://developer.salesforce.com/blogs/engineering/2013/06/extracting-large-data-volume-ldv-in-force-com.html

Let me know if it helps. If it does, please mark this answer as Best. It may help others in the community. Thank You!
GAURAV SETHGAURAV SETH
Hi Anudeep,

Thanks for your response. The above scenario is not for extraction or loading. 
Once the status is updated to "Complete" on LDV Object, integratio is needed to the premise system.
Should we use Bulk API for this too ?