Show HN: Polytomic Connect – API for two-way ETL and data syncs with customers

We automatically do the right thing depending on the situation. The type engine is highly-precise when we generate our own schema. For example, JSON objects and arrays get converted to native struct and array types in data warehouses (e.g. Databricks, BigQuery) rather than strings.

But we're forgiving in other situations where we don't control schemas. For example, we'll automatically convert a source string type to a date when mapping to a Salesforce or Zendesk (or other cloud app) date field.

For example, maybe your product needs to process data from your customers' sales and customer support systems. In that case you can have automatic updates show up in Postgres from your customers' Salesforce and Zendesk instances. Does that sense?

Alternatively, many products want to the ability to push data to their customers' systems. For example, suppose you're a billing software vendor showing data in your own portal that customers log in to. Your customers may also want you to automatically push this data to their accounting systems or data warehouses so that they can do their own analysis.

Does that make sense?

Thank you, whoever you are! :D Hopefully we can continue serving you.

Each sync in Polytomic is one-way so we're not forced to deal with collisions all the time.

But you can, on a per-field basis within a sync config, declare that field not to be synced if the destination system already has a value in the corresponding field.

This setting is a proxy for deciding where your source of truth is for each field if you are indeed setting up two-way syncs.

Most customers are pulling data into their data warehouse, then syncing from queries that generate other values back into other systems. This issue doesn't come up there. But customers of ours doing two-way syncs between, say, HubSpot and Airtable or such do need to decide where the source of truth is for each field.

Thanks for the kind words! Pleasure serving you.

1. All integrations are built on request (see instruction at top of this page to submit one: https://www.polytomic.com/integrations). We're able to turn them around very quickly (our record is two hours from request submission time).

2. Yes, though you can bring your own compute too. We have a self-hosted distribution that you can deploy to your own VPC using Docker and our Terraform module (see details here https://docs.polytomic.com/docs/on-premise-setup). Customers that are public/large enterprises often go for this.

If you want to chat over email shoot me a message at ghalib@polytomic.com.

Haha! I’ve been in this market for over ten years now. The term ‘CDP’ is notoriously ill-defined.

More generally, we move data in all directions, rETL is just one part amongst many others.

Thank you for the kind words Ani!