
A configured Connected App in your Salesforce org accessible by the user account.
NOTE that sobjects belonging to managed packages may require a license to access.
An API-enabled Salesforce user account with read-only access to all sobjects to sync. Still very important to secure your accounts appropriately to protect against system invasion. NOTE: This tool only reads from Salesforce and writes to the database/schema you have configured. Use your distribution package search tool (yum, apt, dnf) to find the correct name and install. Ubuntu 18: sudo apt install postgres-clientĬentOS 7: sudo apt install postgres96-client Install the Postgresql CLI client for your system. In order to use the export feature to initially populate very large tables (recommended) you must To update: pip3 install -upgrade gurglefish Tested over 18 months continuous running in a production environment. Schema artifacts saved in a format easily consumed by custom tooling. Fast field mapping using code generation. Export feature to enable faster initial data loading using native Postgres load file format. Logging of sync statistics for each table. Scrubbing of hard deleted records can be disabled on a per-table basis and on the commandline. Synchronization of record additions/changes/deletions since last run. Automatic detection of sobject field additions/removals and alteration of table structure to match.
Automatic creation and maintenance of indexes:. Multiprocessing-enabled for up to 4 concurrent table snapshots. Dynamic creation of equivalent database table for your selected sobjects. One-way data snapshots from Salesforce to Postgres. Backup your Salesforce sobject data to Postgres and keep in sync.