Release Notes
October 2020
We have improved incremental sync performance for databases which have many changes in collections that are not included in the sync.
August 2020
For MongoDB versions 4.0 and later, Fivetran can now monitor and consume deletions, updates, and insertions through change stream events. This change reduces the number of connections that we need to make to separate servers during data syncs, which allows for faster incremental updates.
To incorporate these changes, you must:
- Allow
changeStreampermissions to your database'sfivetranuser. - Enable the
MongoChangeStreamsflag.
April 2020
We now support SRV host records.
You can now configure your MongoDB Sharded Cluster connector through the Fivetran REST API. This feature is in BETA and available only for Standard and Enterprise accounts.
February 2020
Fivetran has updated our MongoDB connector to improve sync reliability. As a part of this update, we have begun rolling out support for BINARY and BSONBINARY data types.
We have updated our MongoDB connector to support syncing data from MongoDB versions 2.6 to 4.2.
September 2019
If you have a logging service connected to your Fivetran account, the import progress of your tables in the event logs will be visible in your logs as an import_progress event. Table names will be in either the COMPLETE or IN_PROGRESS state, depending on their sync status. Tables that are not reported in the event have not started their import.
August 2019
We fixed a bug that prevented our connector from syncing some of our MongoDB and MongoDB Sharded customers who use multiple hosts with Fivetran. The bug prevented us from syncing using standard Mongo drivers. To work around it, we now connect to the first host you list in the setup form, and if it fails, we try the next one. If needed, we continue in this manner through all of your listed hosts.
You do not need to take any action to take advantage of this improvement. If your connector was unaffected by the original bug, we will continue to use standard Mongo drivers method.
December 2018
You can now assign multiple hosts (master and replicas) for the MongoDB connector.
October 2018
We have optimized the way we do incremental updates from the oplog of nested updates. Previously, when you updated deeply nested fields, we had to fetch the entire document using collection.find({_id:?}). This process can be extremely slow and delay syncs for hours, especially when deeply nested fields are frequently updated. We can now fetch these documents in batches, making our MongoDB syncs ten times faster.
September 2018
We have fixed a bug that caused BSON INT32 types to not sync during our initial syncs.
June 2018
Sync a Sharded MongoDB cluster with automatic node discovery and roll-over.
Link to Sharded MongoDB documentation
April 2018
During setup, we now verify that we have the correct permissions to list all your tables.