PowerExchange for MongoDB

PowerExchange for MongoDB

Posted by: Informatica Platform

Informatica PowerExchange for MongoDB enables you to extract from and load data to MongoDB. Based on the ODBC standard, the adapter supports connectivity to both on-premise and cloud based Mongo deployments.

Overview

Many Application Developers today use MongoDB for use cases like Big Data Management, Content Management and Delivery, Operational Intelligence, Product Data Management and many others. However, without robust and reliable tools to access data from MongoDB, it can become a data silo. PowerExchange for MongoDB is an enterprise class connector to MongoDB which extracts from and load data to MongoDB, providing you the same reliability that you expect from Informatica products. MongoDB is the leading NOSQL database today. It is designed for ease of development and scaling. By providing a flexible schema, it makes the application development truly agile. However, this can create challenges for the IT department who are used to working with traditional databases and data-warehouses. PowerExchange for MongoDB is based on the same proven Informatica data integration software used by thousands of customers worldwide. It provides a single, consistent data integration approach for all types of data, whether it is structured or unstructured. This empowers your IT organization to make the adoption of MongoDB across the enterprise quicker and painless. PowerExchange for MongoDB also helps in reducing data integration costs. Up to 80% of the work in a Big Data project involves data quality and data integration tasks. By moving away from custom coding data integration logic to have proven data integration, productivity tools, you no longer need an army of developers for loading and extracting data from MongoDB. By taking care of the data integration part, PowerExchange for MongoDB and the Informatica Platform reduces your data integration costs and enables your developers to do what they do best: innovate and create better applications. PowerExchange for MongoDB lets PowerCenter directly read from and write to MongoDB without depending on intermediate message queues or staging tables. Data is delivered with the kind of reliability that can come only with an integrated platform. There's no code to develop, so integration interfaces can be developed faster and more reliably, whether they require access to message-oriented middleware, mainframe, midrange or relational databases, service-oriented architecture and Web services or packaged applications. One family of products, using one set of skills, accesses them all.The advantages of PowerExchange don't stop there. Each member of the PowerExchange family automatically captures relevant metadata from its sources and targets and shares it with the rest of the Informatica platform. Proposed changes can be assessed rapidly and implemented with confidence and the same metadata can help resolve questions of data lineage that often arise in audit and compliance exercises one more advantage of the Informatica data integration platform.

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

Comments (17) Comment can only be posted by Signed/Logged in user

Sort: Newest | Oldest
  • Can Mongo Connector write to Mongo Shard Cluster ?
  • Hello I just receive what it looks is the License key , where can I find the link to Download the app (ODBC) ?, Also I try to add the license to my actual License in the PC admin Console and it is showing that the license I receive is not an incremental licensePlease advise ThanksGio
     |   1
     Load replies
  • Hi, I've downloaded the trial and installed it via the admin console but am still getting an error when trying to run a mapping with a MongoDB target: WRT_8001 Error connecting to database... WRT_8001 [Session s_mongo_test1 Username pete DB Error -1800 Connectivity license key for database [Informatica MongoDB ODBC Driver] is not valid. Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [pete] and connection string [MONGO].]I've tried re-cycling the integration service but still get the error.What am I missing? Any help is much appreciated.
     |   1
     Load replies
  • What support, if any, is provided for doing near real-time, incremental data load? I guess you could say what I'm looking for is closer to replication than ETL.I have been able to find tools (e.g. SymmetricDS) that do a rather naive form of replication (table=collection, column=attribute) but that defeats the purpose ... I want my table data de-normalized into a document form so I need a mapping capability to control how my relational tables are mapped to documents.I have been able to find tools (e.g. Informatica, ZappySys, Talend) that support ETL style data transfer ... and most support truncate and load or append modes of operation, but I have not yet been able to convince myself that they easily support anything closer to replication ... i.e. as data elements change on SQL tables, the corresponding fields in all relevant documents (there may be many since the data in Mongo is denormalized) are updated near real-time.Can Informatica approximate this behavior? And if so, how? If not, anybody heard of any other tools that can do this?
     |   1
     Load replies
  • Hi, I tried creating a new license on the Admin console page using the trial license file that I recieved over email.But, it is giving me the below error. CCM_10136: License not valid?My Informatica version: 9.5.1 Hotfix 1Can you please guide me.
  • Hi, I got the license file, but where do I download the actual Mongo DB driver for PWX from? Can you please provide us with instructions for doing the same?Thanks!
  • Hi Power Exchange Support Team,I have a query, Can power exchange extract data from DB2 in mainframe (z/os) and import into MongoDB?Quick response will be appreciated.Warm regards,Srinath
     |   1
     Load replies
  • Am not seeing anything related ODBC entry details and how we can connect from MongoDB from ODBC test. is ssgodbc will test mongodb connections? The video is showed just creating of ODBC connection from wf manager. but no details about odbc.ini file and odbc entry in odbc.ini. please update us how we can proceed these connection tests and odbc entry....
  • Hi,Thanks. I have got the trial licence. Need some clarification on using it to develop a POC for company to decide to buy a full licence.Some questions:-Is it just enable the licence from Admin console page in Informatica?In our case Informatica Server is in Unix machine? Is the trial licence enough? Please provide any sample document how to configure the licence to m.a.hasim@inbox.comRegards
     |   1
     Load replies
  • Hi,Can we use this license key informatica 9.0.1.Please replythanks and regards,Shashank
     |   1
     Load replies
  • Hi,When I try to download the trail, I just recevied the licence but not the driver.I want to connect to Mongo DB using powercenter.Can you please help with this issue.Thanks,Vamshi
     |   1
     Load replies
  • Hi,I am not able to recieve the license key. is there any other way i can get license key.Thanks,Shashank
     |   1
     Load replies
  • Dear,I would like to install the Informatica MongoDB ODBC driver in order to extract and load data from MongoDB database to an other MongoDB database. I need to have in the list of the available driver Informatica MongoDB ODBC Driver I have already installed on my PC Informatica Powercenter Express.I clicked on START TRIAL NOW and I received by mail the licence file.Now I have this file on my desktop and I don?t understand how to use it in order to install the Informatica MongoDB ODBC Driver. Could someone please help me?Do I need another tool? If yes, where is it possible to download it? Does someone have an user guide or installation guide?Thank you very much for your response.Best regards,Christophe
     |   2
     Load replies
  • Good moorning. I have some questions about the connector PowerExchange for Mongo . 1.- Where and how install the licence key you gave me.2.- I have a collection with 1 document with 5 fields in mongo database. I created a mapping that insert into that collection in mongo, but the mapping have 12 output ports (12 fields), 2 more that the collection in mongo database, can i insert the 2 fields extra into the collection than only have 5 fileds originally? Thanks
     |   2
     Load replies
  • Good Afternoon. I don't find the link to download
     |   1
     Load replies
  • Where is the download?
     |   1
     Load replies
  • Hi Team,May I know from Which Version is this available. Is it 9.5.1 hotfix3?Please reply.Thanks in Advance.
     |   1
     Load replies