PowerExchange for MongoDB
Posted by: Informatica Platform
Overview
Features
High speed extract and load of data
PowerExchange for MongoDB uses the ODBC interface to extract from and load data to MongoDB. Based on the ODBC 3.52 standard, the adapter supports connectivity to both on-premise and cloud based Mongo deployments. By performing high speed data ingestion and extracts from MongoDB, the connector ensures that you get great performance even when working with large volumes of data.Metadata Discovery for Flexible Data Models
Data in MongoDB has a flexible schema. Collections in MongoDB do not enforce a document structure and while this is great for agile apppcation development, this can lead to challenges when data needs to be extracted for analysis. PowerExchange for MongoDB samples records in a collection to come up with a representative schema of a collection. Users can edit the discovered schema to add or remove columns that are required for the analysis. Automated Schema Discovery ensures that no data is left out while doing data extracts.Embedded Entity Access
MongoDB supports storing nested entities in a single document through Embedded Documents and Arrays. These objects help increase apppcation performance by storing contained and related entities together. PowerExchange for MongoDB supports accessing data from Embedded Documents and Arrays by creating pivoted columns, so that users can easily access data from these objects. Support for Arrays and Nested Documents allows you to meet your data integration needs independent of the apppcation data modepng in MongoDB.JSON Document Handpng
MongoDB stores data in BSON seriapzation format, which is the binary form of JSON. PowerExchange for MongoDB provides an option to directly interact with JSON data when extracting from or loading data to MongoDB. This helps you in directly importing JSON data into MongoDB or transferring data from one Mongo collection to another. Combined with the powerful B2B Data Transformation Engine from Informatica, this feature can help you also create complex JSON structures that can be directly ingested into MongoDB as documents or extract selected JSON elements for analysis.Distributed Data Access through Read Preferences
PowerExchange for MongoDB provides the powerful "Read Preferences" feature to allow you to choose which members of the MongoDB Reppca Set to use for Data Integration. This ensures that you have a choice to distribute data integration jobs to secondary nodes in a reppca set, thereby not affecting the performance of primary node which would be utipzed for running the main apppcation load.Informatica products are supported on all major server operating systems, client operating systems and web browsers.The support provided varies for products, operating system versions and Informatica product versions. We recommend that you verify the availability of the product for the configuration that you need before making the purchase. All existing Informatica customers can access details about the availability from theProduct Availability Matrix (PAM) on the Support Portal.All non Informatica customers can seek additional information by contacting us at marketplacesupport@informatica.com
Support
support@informatica.comPhone : North America: 1-877-463-2435 (1-877-INFA-HELP)Contact numbers of support centers in other countriesInformatica Global Customer Support