Question 1

What can I write to Front?

Accepted Answer

Accounts and contacts, and nothing else. Create and update, create only, and update only are all supported. Deletes are not, so a record dropping out of your PostgreSQL model will not remove anything from Front.

Question 2

How is an existing record matched?

Accepted Answer

Accounts on Front's ID, external ID, or domains. Contacts on Front's ID or email address. Matching is equality or array membership against a cached snapshot of Front. Take care with a non unique identity, because if it matches several records, each of those matches can be updated.

Question 3

Which fields can I set?

Accepted Answer

On accounts: name, which is required, plus description, domains, external ID at creation time, and custom fields. On contacts: name, description, spammer status, links, group names, emails and handles, and custom fields. Existing Front custom fields are discovered dynamically and exposed as typed writable fields.

Question 4

Will a sync overwrite custom fields I did not map?

Accepted Answer

No. Account updates merge the custom fields you mapped with the values already present, so anything unmapped is preserved. If account custom fields are not appearing in the mapping at all, that is usually missing permissions on the Front side rather than anything to do with the sync configuration.

Question 5

How fast will this run?

Accepted Answer

Deliberately not very fast. Polytomic reads Front's rate limit header and throttles to eighty percent of it, writing in batches of two hundred and fifty with at most two concurrent jobs per connection. Retryable failures honour Retry After and can retry up to a hundred times, so a heavily throttled reverse ETL run takes considerably longer than the row count alone suggests. Simultaneous syncs on the same connection share that capacity.

Sync PostgreSQL to Front

Sync PostgreSQL to Front with Polytomic

Accounts and contacts

Custom fields merged

Throttled to eighty percent

Or sync Front to PostgreSQL

Trusted by businesses worldwide

Step-by-step integration guide

Connect PostgreSQL in Polytomic

Connect Front in Polytomic

Create a sync between PostgreSQL and Front

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect PostgreSQL with Front?