MongoDB Connector > Introduction to MongoDB Connector

Introduction to MongoDB Connector

You can use MongoDB Connector to connect to a MongoDB database from Data Integration. You can use MongoDB Connector to read data from or write data to collections in a MongoDB Atlas database. You can use a MongoDB document as a source and as a target in mapping tasks and mappings.

When you run a task or mapping, the Secure Agent uses the Simba MongoDB JDBC driver to connect to MongoDB. The Simba MongoDB JDBC driver can create virtual tables to normalize data in MongoDB collections, such as array or object.

You can use MongoDB Connector to integrate and migrate data from diverse data sources to MongoDB.

You can use the connection for the following data integration scenarios:

•Aggregate data from MongoDB and other source systems, transform the data, and write the data to MongoDB.
•Migrate data from a relational database or other data sources to MongoDB. For example, you want to migrate data from a relational database to MongoDB. You can write data from multiple relational database tables with different schemas to the same MongoDB collection. A MongoDB collection contains the data in a MongoDB database.
•Migrate data from MongoDB to a data warehouse for reporting. For example, your organization uses a business intelligence tool that does not support MongoDB. You must migrate the data from MongoDB to a data warehouse so that the business intelligence tool can use the data to generate reports.