ODBC Connection for MongoDB Overview
You can connect to MongoDB from Informatica Cloud. 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 the connection to integrate and migrate data from diverse data sources that are incompatible with the MongoDB architecture.
You can use the connection 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 the ODBC connection 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.