PowerExchange for PostgreSQL User Guide for PowerCenter

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.2
- 10.5
- 10.4.0

Back Next

Import PostgreSQL Source and Target Definitions

Use the

Create PowerExchange For PostgreSQL Source

Create PowerExchange For PostgreSQL Target

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

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

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

Open a source or target folder.

Select

Source Analyzer

Target Designer

In the Source Analyzer, click

Sources

Create PowerExchange For PostgreSQL Source

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

The

PostgreSQL Connection Details

dialog box appears.

In the Target Analyzer, click

Targets

Create PowerExchange For PostgreSQL Target

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

The

PostgreSQL Connection Details

dialog box appears.

When the source type is PowerExchange for Change Data Capture (CDC), you cannot use PostgreSQL targets with native connection. Plan your mappings accordingly to avoid incompatible configurations.

Configure the PostgreSQL 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.

PostgreSQL Sources and Targets

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for PostgreSQL User Guide for PowerCenter

PowerExchange for PostgreSQL User Guide for PowerCenter

Import PostgreSQL Source and Target Definitions

Import PostgreSQL Source and Target Definitions