PowerExchange Interfaces for PowerCenter

10.5.2
- 10.5.8
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring a Session to Load Data to PowerExchange Targets (ODBC)

To load data to a PowerExchange target, you must select a relational database connection. Then configure properties for the session as you would any other relational target.

To configure a session to load data to a PowerExchange target:

In the Task Developer, double-click a session with a relational source to open the session properties.

Click the Targets view on the Mapping tab.

In the Writers settings, ensure that Relational Writer is selected.

In the Connections Value field, select a connection which points to an ODBC data source with appropriate DBType and Location value.

In the Properties settings, configure the Table Name Prefix attribute.

At minimum, the schema name of the target table (if relational) or the PowerExchange data map (if nonrelational) must be specified in order to correct construct the SQL statement during execution.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring a Session to Load Data to PowerExchange Targets (ODBC)

Configuring a Session to Load Data to PowerExchange Targets (ODBC)