MongoDB Connector Overview
MongoDB Connector provides connectivity between Informatica Cloud and MongoDB. To connect to MongoDB, you must configure the ODBC connection from Informatica Cloud. Use the ODBC connection to extract and load MongoDB documents through the Secure Agent.
You can use MongoDB Connector to integrate and migrate data from diverse data sources that are incompatible with MongoDB architecture.
You can use MongoDB Connector for the following data integration scenarios:
- •Create a MongoDB data warehouse. You can 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.
- •Move data between operational data stores to synchronize data. For example, an online marketplace uses a relational database as the operational data store. You want to use MongoDB instead of the relational database. However, you want to maintain the relational database along with MongoDB for a period of time. You can use MongoDB Connector to synchronize data between the relational data store and the MongoDB data store.
- •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.