Log based change capture
Enable logical replication so inserts, updates, and deletes stream in as they happen, instead of waiting on a scheduled run.
Amazon RDS PostgreSQL
Polytomic connects Amazon RDS PostgreSQL to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Read tables and views out or load data in with automatic schema discovery, without writing code.
IAM role authentication
Connect with an AWS IAM role Polytomic assumes to sign short-lived database tokens, so there is no long-lived database password to store.
Schema changes handled
New tables and columns are picked up automatically on the way in, and new columns are added automatically on the way out.
Example workflows
Bring CRM, billing, and product data into Amazon RDS PostgreSQL
What you can sync
Move data between Amazon RDS PostgreSQL and your data warehouse, databases, and SaaS tools, in both directions.
From Amazon RDS PostgreSQL
Tables and views across schemas
Incremental reads on a tracking field you choose
Row level changes captured through logical replication
SSH tunnel for private clusters
To Amazon RDS PostgreSQL
Tables, created and columns added automatically
Create, update, upsert, and replace write modes
Records matched and merged on a key field you choose
Native Postgres types, including JSON, arrays, and UUID
How it works
Connect to Amazon RDS PostgreSQL with an IAM role that Polytomic assumes to sign short-lived database tokens. There is no long-lived password to store. Polytomic discovers tables, views, and columns automatically, and syncs the ones you select to or from your data warehouse, databases, and other systems.
Enable logical replication to stream inserts, updates, and deletes as they happen, instead of waiting for a scheduled run. A table without a primary key or unique index still syncs, read incrementally as new rows rather than matched updates. Ordinary tracking field syncs read only new and changed rows after the first run.
- Objects and fields discovered automatically, including new tables and columns
- Connect using an IAM role instead of a stored database password
- Logical replication streams inserts, updates, and deletes as they happen
- Existing rows matched and updated, or new rows inserted, on write
- Ordinary syncs read only new and changed rows after the first run
- Connect directly or through an SSH tunnel to a private cluster
How to set up
Amazon RDS PostgreSQL connections authenticate through an IAM role rather than a stored database password. Polytomic assumes the role you create and signs a short-lived token for every connection.
How to get connected
- 1In AWS, create an IAM role that trusts Polytomic using your organization's external ID and grants rds-db:connect for the database user
- 2In Polytomic, go to Connections, click Add connection, and select Amazon RDS PostgreSQL
- 3Enter the RDS endpoint, username, database, region, and IAM role ARN, then click Save
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Amazon RDS PostgreSQL in minutes
No credit card required. Free trial available.