MongoDB is a document database with the scalability and flexibility that you want and the querying and indexing that you need. Read more about MongoDB. The Etlworks Integrator can read and write data stored in MongoDB.
What can you do with MongoDB in Etlworks Integrator
Extract data from MongoDB You have three ways to extract data from MongoDB: from collection, from a specific document or a group of documents, and capture changes in MongoDB documents and collections. |
Load data in MongoDB You have two ways to load data from MongoDB: create a separate document for each source record and as a single document. |
Work with documents in MongoDB You can copy, download, or delete documents in MongoDB. |
Related resources
Change Data Capture (CDC) from transaction log The Etlworks Integrator supports native log-based change data capture for PostgreSQL, SQL Server, MySQL, Oracle, DB2, and MongoDB. |
Compare data replication techniques Change Data Capture (CDC) and Real-time CDC with Kafka and Debezium currently support Postgres, MySQL, SQL Server, Oracle, DB2, and MongoDB. |
Real-time change replication with Kafka and Debezium The following databases are supported as a source: Microsoft SQL Server, MongoDB, MySQL, Oracle, and PostgreSQL. |
Related case study
Media company Load metadata into MongoDB and create API for retrieving metadata for movies and shows
|
"Etlworks Integrator developed two Flows for the customer. A Flow that uploads Excel spreadsheets matching a wildcard file name located in FTP into the MongoDB database in the cloud. A Flow deployed as user-defined PULL API to query the metadata stored in MongoDB." |
Connect to MongoDB
In order to work with MongoDB, you will need to create a MongoDB Connection.
Apart from the MongoDB Connection, you will need to create a JSON Format. If you intend to only read data from MongoDB, a JSON Format with the default settings will work just fine. We will explain how to create a Format for writing into a MongoDB.
Work with MongoDB
Working with MongoDB is similar to working with files. The MongoDB document id
is similar to a file name and the document associated with the document id
is comparable to the file's content.
Comments
0 comments
Please sign in to leave a comment.