PowerExchange for MongoDB JDBC User Guide for PowerCenter

10.5
- 10.5.7
- 10.5.6
- 10.5.4
- 10.4.1

Back Next

Import MongoDB JDBC Source and Target Definitions

Use the

Create PowerExchange For MongoDB Source

Create PowerExchange For MongoDB Target

wizard to import MongoDB source and target definitions into the PowerCenter repository.

You must import MongoDB source and target objects before you create a mapping.

Start PowerCenter Designer and connect to a PowerCenter repository configured with a MongoDB instance.

Open a source or target folder.

Select

Source Analyzer

Target Designer

In the Source Analyzer, click

Sources

Create PowerExchange For MongoDB Source

The following image shows the option to create a MongoDB source:

The

MongoDB Connection Details

dialog box appears.

In the Target Analyzer, click

Targets

Create PowerExchange For MongoDB Target

The following image shows the option to create a MongoDB target:

The

MongoDB Connection Details

dialog box appears.

Configure the MongoDB connection parameters.

Click

Test

to test the connection.

Click

Finish

to add the connection.

Click

The

Select Objects from

tab appears.

Select the database and schema in

Package Explorer

The following image shows the list of tables that appear:

Select the table that you want to import, and then click

Import

To view the table metadata, select the table, and double-click the table name.

You can import table collections having upto 10,000 columns and if you are unable to import 1000 columns in the table, you can increase the virtual memory size on the Windows machine that hosts the PowerCenter

Rename Saved Search

Table of Contents

PowerExchange for MongoDB JDBC User Guide for PowerCenter

PowerExchange for MongoDB JDBC User Guide for PowerCenter

Import MongoDB JDBC Source and Target Definitions

Import MongoDB JDBC Source and Target Definitions