Native change data capture
Uses SQL Server's own CDC feature, enabled per table you care about.
Microsoft SQL Server
Polytomic connects Microsoft SQL Server to your data warehouse, databases, and SaaS tools for database ETL and reverse ETL. Replicate tables into your data warehouse and other systems using SQL Server change data capture, and write modelled data back, without writing code.
Reaches private instances
SSH tunnel support for databases that are not publicly addressable.
Schema changes handled
New columns are picked up and destination tables migrate automatically.
Example workflows
Replicate SQL Server into your data warehouse and other systems
What you can sync
Move data between Microsoft SQL Server and your data warehouse, databases, and SaaS tools, in both directions.
From Microsoft SQL Server
Tables and views across schemas
Change data capture using SQL Server CDC
Custom SQL as a model source
Tracking field incremental reads
To Microsoft SQL Server
Tables, created and migrated automatically
Create, update, create or update, and replace
Merges keyed on the source primary key
Soft deletes by default, hard deletes optional
How it works
Connect SQL Server and sync in either direction. Read tables into your data warehouse using SQL Server's own change data capture feature so only committed changes move after the first load, or write modelled data back from anywhere else in your stack.
Because many SQL Server instances sit on private networks or on premises, an SSH tunnel through a bastion host is a first class option rather than an afterthought, which is often what makes a move to a cloud data warehouse possible at all.
- Connect SQL Server directly or over an SSH tunnel
- Read tables and views, or write custom SQL as a model source
- Enable SQL Server change data capture on the tables you want
- Sync incrementally on a tracking field where CDC is not enabled
- Write back with create, update, create or update, and replace modes
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic connects directly or through an SSH tunnel using a bastion host and private key. For change data capture, SQL Server's CDC feature needs enabling on each table you want to capture, which also creates the associated capture instance and change tables.
How to get connected
- 1Create a SQL Server login for Polytomic with the permissions it needs
- 2Enable change data capture on the database and on each table you want
- 3In Polytomic, navigate to Connections, then Add Connection, then Microsoft SQL Server
- 4Enter host, port, database, and credentials, and configure SSL or SSH if needed
- 5Test the connection
- 6Select tables, choose a destination, set a schedule, and click Save
See the documentation for full setup details.
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 Microsoft SQL Server in minutes
No credit card required. Free trial available.