Salesforce Reference
Salesforce database schema
Your Sequin database will contain tables for Salesforce objects like:
- Account
- Contact
- Lead
- Opportunity
- User
- Product2
We will also sync any custom objects you may have.
If you don't see your Salesforce object listed during setup, just send us a note! We can toggle on support for almost any available Salesforce object.
The syncing process
By default, we limit our sync to one request every three seconds. This means about 20 request per minute or 29,000 requests per day. We use these limits to stay well below your daily API quota. You can adjust the rate-limit you allocate to Sequin in your sync's settings.
We first backfill your database with all your Salesforce data. We're able to pull 200 records per request. This means, by default, we can process just over 200,000 records per hour. So, if your Salesforce instance contains millions of records, the backfill can take a while. We'll email you when your backfill is complete and all your data is loaded into your database.
After the initial backfill, we'll continuously poll your Salesforce instance to monitor changes. Respecting the rate limit, we'll round-robin each of the tables you've selected to sync. We're able to handle up to 200 creates and updates across your tables every three seconds. So if you're syncing five tables, we'll be able to process up to 1,000 creates and updates between those five tables every 15 seconds.
Learn more about our syncing process.
Writes
We're introducing a new way to write to Salesforce – SQL writes.
You write and handle errors from Salesforce like any other SQL query. Successful INSERT, UPDATE, and DELETE statements mutate Salesforce and your database simultaneously - returning the object's id:
If you hit a Salesforce validation error, the error is returned to you in-line, before the changes are made to your database.
If you'd like early access, please send us a note.
