I am currently using a service that pulls data from PostgreSQL into Google Sheets and an add-on that uploads from Sheets to Salesforce. My goal is to automate this and cutting out steps would be helpful. That being said, bonus points for a service that offers scheduled moves. :D
6 Antworten
We've used Skyvia (https://skyvia.com/data-integration/integrate-salesforce-postgresql) for a similar setup because it supports both PostgreSQL and Salesforce, can run scheduled synchronizations, and handles bi-directional syncs without needing Sheets as a middle layer. Once it was set up, the scheduled jobs were pretty much hands-off.
If you have more complex transformation requirements, tools like Talend or Informatica are also worth a look, but for straightforward scheduled syncs between PostgreSQL and Salesforce, they may be more than you need.
