Change stream capture
Native change streams drive incremental syncs, including deletes.
MongoDB
Polytomic connects MongoDB to your data warehouse, databases, and SaaS tools for document database ETL and reverse ETL. Replicate collections into your data warehouse and other systems using change streams, and write modelled data back into MongoDB, without writing code.
Nested documents preserved
Objects and arrays land as structured values rather than being flattened.
Schema inferred and editable
Fields are inferred from documents, and you can add or retype any of them.
Example workflows
Replicate MongoDB collections into your data warehouse
What you can sync
Move data between MongoDB and your data warehouse, databases, and SaaS tools, in both directions.
From MongoDB
Collections across databases
Nested documents and arrays as structured values
Change data capture through change streams
Tracking field incremental reads
To MongoDB
Existing or newly created collections
Create, update, and upsert
Nested fields written using dot separated paths
Matching on the document ID or any field you choose
How it works
Connect MongoDB and sync in either direction. Read collections into your data warehouse so document data becomes queryable in SQL alongside everything else, or write modelled data back into a collection your application reads.
Because MongoDB has no fixed schema, Polytomic samples recent documents to infer fields and types. That gets most collections right immediately, and anything the sample missed can be added or retyped by hand rather than leaving you stuck.
- Connect MongoDB Atlas or a self hosted deployment
- Fields and types inferred from a sample of recent documents
- Add missing fields or override inferred types by hand
- Nested documents and arrays kept as structured values
- Enable change streams for incremental bulk syncs including deletes
- Monitor sync health, record volume, and failures from one interface
How to set up
Atlas connections typically use an SRV connection string. Self hosted deployments support explicit hosts, TLS, an authentication database, and additional URI parameters. Network access and IP allowlisting are configured on your side, as are the read, change stream, or write permissions the sync needs.
How to get connected
- 1Create a MongoDB user with the permissions your sync needs
- 2Allowlist Polytomic's addresses on Atlas or your firewall
- 3In Polytomic, navigate to Connections, then Add Connection, then MongoDB
- 4Enter an SRV string, or host details with TLS and auth database
- 5Test the connection and review the inferred fields for each collection
- 6Select collections, 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 MongoDB in minutes
No credit card required. Free trial available.