MongoDB is a document database with the scalability and flexibility that you want and the querying and indexing that you need.
Working with MongoDB is similar to working with files. The MongoDB document id is a file name, and the associated with the document id document is the file content.
Etlworks Integrator can read and write data stored in MongoDB. Read how to work with MongoDB in Etlworks Integrator.
Creating a connection
Create a MongoDB connection in the Connections window by clicking the
+ button, typing in
mongo, and selecting MongoDB as the connection type.
- URL - the required connection string. Read about the MongoDB connection string.
- Database - the required MongoDB database name.
- Collection - the required collection name, which belongs to a specific database.
- User - optional MongoDB username.
- Password - optional MongoDB password.
- Remove Object ID when Reading - if this option is enabled, the system will remove the document ID when reading a document. It can be useful if the document is a JSON array and you just need to read the contents of the JSON array.
- Number of Documents in Explorer - the maximum number of MongoDB documents that can be displayed in Explorer. The default value is
1000; the maximum possible value is
9999. A MongoDB can contain millions of documents, so displaying all of them might kill the server.
this parameter is used only by Explorer and has no effect when reading MongoDB documents while executing data integration flows.
- Filter - a wildcard or a JSON filter to retrieve documents to display in Explorer. The purpose is the same as above.
this parameter is used only by Explorer and has no effect on reading MongoDB documents when executing data integration flows.
1. A fully qualified document name - the document id as it is stored in MongoDB.
2. A wildcard document name, for example,
sales_orders*. The system will read all the documents which match the wildcard.
3. A request to MongoDB in the JSON format. The system will read all the documents which match the request. An example is the request:
- Encoding - additional encoding which can be applied when creating a MongoDB document.