Connect is an API you can use in your own products to either pull your customers’ data into your own systems, or push data from your own systems to your customers’, or both. We have first-class support for data warehouses too. And there's a self-hosted deployment option.
You can set up automatic data syncs in any direction between data warehouses, databases (including CDC streaming), cloud applications (e.g. Salesforce, Zendesk, etc), spreadsheets, cloud storage (S3 etc), and arbitrary APIs and webhooks. We take care of authentication, automatically pushing updates, type conversions, rate limits, scaling to handle large volumes, monitoring, and alerting.
You can also sync updates from custom queries powered by data models you define as well join data across disparate systems (e.g. HubSpot + Stripe + Airtable) to sync fields from them in one payload to any destination.
You can see demo videos and code examples for a small subset of use cases here: https://apidocs.polytomic.com/guides/code-examples/overview.
We’d love to take your comments and feedback! Happy to answer questions too.
If I'm pushing and pulling customer's data into my own system (e.g. postgres), what sort of customer data are we talking about? Can it sync with data on their own filesystem? That would be neat. Or it just for e.g. syncing a customer's google drive with my postgres type of thing? Looks interesting and like something I may want to use but not sure I entirely grok it yet.
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?