We use Heroku connect to sync a few hundred thousand rows and it works really well for us and has been way more reliable and quicker than the Salesforce API. He

We use Heroku connect to sync a few hundred thousand rows and it works really well for us and has been way more reliable and quicker than the Salesforce API. Heroku connect let’s you sync data from Salesforce tables which are the source of truth. There’s also another product (which you pay for separately) called Salesforce connect which lets you sync data from a Heroku database as the source of truth.