Connecting Salesforce and integrating your data with Stitch is a simple five-step process:
Currently, only Production domains can be connected to Stitch. If you're interested in connecting a Sandbox domain, please reach out to support with your use case to file a feature request.
To use Stitch's Salesforce integration, your account must have API access enabled. Some editions of Salesforce have API access enabled by default while others don't.
Look in the table below for your edition and what you should do next.
|I'm using:||What you should do:|
|You're good to go. Just make sure the user you use to connect to Stitch can access the objects you want to push into your data warehouse.|
|Please refer to Salesforce's documentation for guidance in determining if API access can be added to your account and what the next steps are.|
After you've verified your account has API access enabled and that your user has the correct permission settings, you can move onto adding Salesforce as a data source.
stitch_salesforcein the data warehouse.
In this section, you'll grant Stitch access to your Salesforce data. Keep in mind that:
Enter your Salesforce credentials and click the Login to Salesforce button. After your credentials are validated, you'll be asked to grant Stitch access to your Salesforce data (see image to the right).
Click Allow to continue.
After your credentials are validated, you'll be directed back to Stitch (click the All Done button to wrap things up) and the Integration Settings page will display.
To finish setting up the integration, you'll need to select the tables and columns you want to sync to your data warehouse.
Check out the Expected Salesforce data article to learn more about the data our integration pulls in from Salesforce.
Why is an initial sync taking so long?
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.
The Replication Frequency setting determines how often Stitch will attempt to replicate data from Salesforce. By default the Replication Frequency is set to 30 minutes, but you can change the interval to better suit your needs.
You can change this setting at any time by clicking into the integration from the dashboard and then clicking the Integration Settings button.