3 ms·
Really curious how well the salesforce integration works. Heroku has a product that does this (Heroku Connect), but it doesn't work well with large tables and y
by enahs-sf 7y ago
Really curious how well the salesforce integration works. Heroku has a product that does this (Heroku Connect), but it doesn't work well with large tables and you have to pay them an obscene amount of money to even properly test it (which might have something to do with them being owned by Salesforce).
So many companies with tons of data trapped in Salesforce's expensive walled garden and no way to get it out. Dumping it to SQL is the first step to freedom.
- borisjabes 7y agoCouldn't agree more. This is obviously a shameless plug but we built a product (getcensus.com) specifically focused on this problem of getting data to/from Salesforce & data warehouses (not just Redshift). Heroku Connect is pretty powerful but not only is it super expensive as you point out but also forces you into creating an extra layer in the stack by creating a Heroku Postgres DB. The secret advantage of Connect is that since it's owned by Salesforce it bypasses Salesforce API quotas but that's a whole other can of worms :-)
- roseway4 7y agoNot affiliated but have used it: Stitch Data.
- agotterer 7y agoWe 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.