Stitch Documentation
has moved!

Please update your bookmarks to https://www.stitchdata.com/docs

If you're not automatically redirected after 5 seconds, click here.

Expected Salesforce Data

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:

Replicating Salesforce Data

Historical Sync

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.

  • If a single replication attempt uses 20% of your daily quota, the integration will stop running.
  • If more than 80% of your daily quota has been used - this includes usage from Stitch as well as any other apps you may be using - replication will stop and resume once more is available. This applies to all replication jobs, not just an initial historical sync.

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.

Replication Frequency

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.

Replication Methods

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.

Salesforce Tables in 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.

Obects Stitch Replicates

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. sf_[object] sf_account
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]. sf_[object]__c sf_issue__c
Standard Field Fields are attributes that describe an object. A Standard field is created by Salesforce. [field] id
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. [field]__c issue_id__c

Objects Stitch DOESN’T Replicate

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:

  1. Objects that the authorizing user doesn’t have permission to access,
  2. External objects (which are objects created by you to map to data stored outside of your organization), and
  3. The objects listed in the table below. These objects are unsupported due to the limits required while querying.
Announcement CollaborationGroupRecord DcSocialProfile IdeaComment PlatformAction
ApexPage ContentDocument FeedItem ListViewChartInstance TopicAssignment
Attachment ContentDocumentLink FieldDefinition Order UserRecordAccess

RELATED

Was this article helpful?
0 out of 0 found this helpful

Comments

Questions or suggestions? If something in our documentation is unclear, let us know in the comments!