IAM role authentication
Polytomic assumes an IAM role and signs a fresh token for every connection, so no database password is stored.
Amazon RDS MySQL
Polytomic connects Amazon RDS MySQL to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Sync tables out of RDS for reporting, or write modeled results back in, without writing code.
Log based change capture
Turn on replication to read inserts, updates, and deletes straight from the binlog instead of polling a tracking column.
Schema changes handled
Tables, databases, and columns are created and migrated automatically as your source structure changes, on both sides of the sync.
Example workflows
Load application data from Amazon RDS MySQL into your data warehouse
What you can sync
Move data between Amazon RDS MySQL and your data warehouse, databases, and SaaS tools, in both directions.
From Amazon RDS MySQL
Tables and views across your RDS or Aurora database
Custom SQL as a model source
Incremental reads on a tracking field
Row level changes via binlog replication, when enabled
To Amazon RDS MySQL
Tables, created and migrated automatically
Databases created automatically to hold synced tables
Create, update, upsert, and replace
Unique indexes created automatically to support upserts
How it works
Connect Amazon RDS MySQL or Aurora MySQL and sync tables and views in both directions. Read data out for reporting, or write modeled results back in, with tables, databases, and columns created and migrated automatically as your source changes.
Polytomic authenticates by assuming an IAM role instead of storing a database password, signing a fresh token for every connection and verifying the server against Amazon's RDS certificate authorities. Turn on replication to read row level inserts, updates, and deletes directly from the binlog instead of polling a tracking field.
- Tables and views discovered automatically across your RDS database
- Custom SQL queries usable as a model source
- Incremental reads on a tracking field such as updated_at
- Row level inserts, updates, and deletes captured through binlog replication
- Connects through an assumed IAM role instead of a stored password
- Destination tables and columns created and migrated automatically
How to set up
Amazon RDS MySQL and Aurora MySQL connections authenticate by assuming an IAM role instead of storing a database password. Create a role in AWS that grants rds-db:connect access and trusts Polytomic using the external ID shown in the connection form.
How to get connected
- 1In Polytomic, go to Connections, click Add connection, and select Amazon RDS MySQL
- 2In AWS, create an IAM role that grants rds-db:connect access to your database user and trusts Polytomic using the external ID shown in the connection form
- 3Enter the hostname, username, region, and the 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 MySQL in minutes
No credit card required. Free trial available.