After Salesforce is successfully connected to your Stitch account, you'll have the ability to select individual tables to sync to your data warehouse. In this article, we'll cover:
By default, a historical sync of Salesforce data goes back one year from the Stitch connection date.
Salesforce API Quotas
Due to the volume of data and the daily API quotas imposed by Salesforce, an initial sync of your Salesforce data can take awhile.
Continually hitting these limits can cause an initial sync to take several days. Check out this Salesforce doc for more info on calculating and increasing your total API calls.
Stitch will replicate Salesforce data based on the frequency you define. The default setting is every half hour, but you can change it to more or less frequent based on your needs.
When Stitch replicates Salesforce data, it does so using Incremental Replication. This means that every time Salesforce data is queued for replication, only new and updated rows will be replicated to your data warehouse.
Stitch will replicate the majority of Salesforce objects (with the exception of those listed here). To ensure we can provide you with up-to-date docs, this doc won’t dive into the specifics of the hundreds of Salesforce objects Stitch can replicate.
Detailed info about each of Salesforce's objects can be found in their Object Reference Guide.
Below you’ll find the objects and fields Stitch can replicate, a brief description, and how different table and column types will be named in your data warehouse.
|Object/Field Type||Description||Naming Convention||Example|
|Standard Object||Standard objects are those that are created by Salesforce and included in your account by default.||
|Custom Object||Custom objects are tables created by you that enable you to store info unique to your organization. For detailed info, check out the Custom Objects section in the [Object Reference guide][objref].||
|Standard Field||Fields are attributes that describe an object. A Standard field is created by Salesforce.||
|Custom Field||A Custom field is a field created by you. For detailed info, check out the Custom Fields section in the Object Reference guide.||
Below is a list of the only Salesforce objects Stitch does not support replicating. If it isn't listed here, you can safely assume that Stitch will replicate it.
Stitch will not replicate: