PowerExchange for MongoDB JDBC User Guide for PowerCenter

PowerExchange for MongoDB JDBC User Guide for PowerCenter

PowerExchange for MongoDB JDBC Overview

PowerExchange for MongoDB JDBC Overview

PowerExchange for MongoDB JDBC provides connectivity between Informatica and MongoDB. Use PowerExchange for MongoDB JDBC to extract and load MongoDB documents through the PowerCenter Integration Service.
You can use PowerExchange for MongoDB JDBC to integrate and migrate data from diverse data sources that are incompatible with MongoDB architecture.
You can use PowerExchange for MongoDB JDBC for the following PowerCenter Integration scenarios:
  • Perform insert, update or delete operations on the MongoDB collections. 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 PowerExchange for MongoDB 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.

0 COMMENTS

We’d like to hear from you!