PowerExchange Interfaces for PowerCenter

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

Back Next

Configuring Properties for Nonrelational Batch Mode Sessions (ODBC)

The relational connection for nonrelational sources should point to an ODBC data source that has a DBType of either NRDB or NRDB2. You should use a connection with the same DBType as used when the source was imported. That is, if you imported the source mapping by using NRDB, then use an NRDB ODBC connection in the session connection as opposed to an NRDB2.

The only difference between NRDB and NRDB2 is whether a three or two tier naming conventions is used in the SQL statements to extract or load data. Nonrelational sources and targets mapped in PowerExchange can be referred to as either NRDB or NRDB2. The format is as follows:

NRDB: schema.datamapname.table

NRDB2: schema.datamapname_table

To configure properties for a nonrelational batch mode session:

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

Click the Sources view on the Mapping tab.

In the Reader field of the Readers settings, verify that Relational Reader is selected.

In the Connections Value field, select a nonrelational ODBC connection, that is, NRDB or NRDB2.

In the Properties settings, configure the Owner Name attribute.

At minimum, the schema name of the PowerExchange data map, or the Owner name that is displayed when the source mapping is edited, must be specified to correctly construct the SQL statement during execution. PowerExchange SQL Escape Sequences can also be specified in this attribute field to override specifications in the data map.

For a list of the available SQL escape sequences, see the PowerExchange Reference Manual
.

The following example indicates how the Owner Name attribute can be configured to provide the schema name for the source (seq) as well as an override for the physical file name in the data map (dtldsn=new.dataset.name):

seq{dtldsn=new.dataset.name}

SQL escape sequences and the Owner Name can be specified in any order in the attribute field.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring Properties for Nonrelational Batch Mode Sessions (ODBC)

Configuring Properties for Nonrelational Batch Mode Sessions (ODBC)