PowerExchange for MongoDB JDBC User Guide for PowerCenter

10.4.1
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

PowerExchange for MongoDB Implementation

To extract and load MongoDB data, create MongoDB source and target definitions in the Designer. You can add a source or target definition to a session and run the session to process the data.

PowerExchange for MongoDB includes the Informatica MongoDB JDBC driver that connects to the MongoDB server. You can create an JDBC connection to extract data from or load data to a MongoDB database. You can also configure the replica sets for the MongoDB server so that the

PowerCenter Integration Service

can access the secondary servers if the primary server is not available.

The Designer uses the schema of a collection, or you can define the schema for the collection before you import a source or target definition. The Designer flattens the schema if there is any hierarchical element in the collection and retains the original schema of the collection when you import it.

The Designer imports a document based on the schema that you set for the collection. If a document contains hierarchical elements like arrays or nested documents, the Designer imports them as columns at the same level as other columns.

For example, you need to import the collection product_details with the following schema:

{
  sku: "sku_name",
  title: "product_name",
  description: "description",

  manufacture_details: {
    model_number: "model_number",
    release_date: new ISODate("date")
  },

  shipping_details: {
    weight: <value>,
    width: <value>,
    height: <value>,
    depth: <value>
  },

  quantity: <value>,

  pricing: [
    {region: "North America",
					cost_price: 1000,
				 sale_price:	1200},
				{region: "Europe",
					cost_price: 1200,
				 sale_price:	1500}
		]
}

The

Designer

imports the collection schema into a tabular format. You can identify arrays and nested documents with the naming convention of the column. The naming convention of a nested document is <top level element name>.<nested document name>.<nested document element name>. The naming convention of an array is <array name>.<element number>.

The following figure shows the source definition when you import the collection into the Designer: