I am attempting to create a "clone" more or less of a few different tables from Salesforce in an external Postgres database. The synchronization tool sounds like it's exactly what I need.
I created a new Synchronization Integration package, source of SFDC and target the Postgres db. I went to add a task and quickly found out that I need to set up the tables prior in the Postgres side, so I went ahead and did that (through an Export). Deleted all rows, and ran the Sync job.
I am receiving the error "null value in column "Id" voilates not-null constraint". Not entirely sure why the `Id` field would be null, as the records (if directly expored via Export package) all have unique ids (generated in SFDC). None of the records succeeded in syncing. Any ideas? Is there anything special we need to link to the 'Id' field on records we want to Sync in Salesforce since they all have values?
I've also ran the Synchronization package with records in the Postgres database (from Export), and have no immediate errors until I change a record/row in Salesforce or the Postgres db and try to resync. This will then either show no records were updated/synced if the change was in Postgres, or it'll show an error if the change was on the Salesforce side (error is "null value in column "Id" voilates not-null constraint")