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

Importing Nonrelational Target Definitions

You can connect to PowerExchange locally or to a PowerExchange Listener to import a nonrelational target definition.

When you connect to PowerExchange, the Designer displays data map schemas and tables for the specified target type. Before you connect to PowerExchange, you can filter the metadata by schema, data map name, or both. Then select a data map to create the target definition.

To import a nonrelational target definition, click

Targets

Import from PowerExchange

and select the target type.

The dialog box and parameters displayed are the same for each nonrelational target type.

Enter connection information.

The following table describes required and optional connection attributes:

Attribute	Required or Optional	Description
Location	Required	Name of the PowerExchange Listener (Node name from PowerExchange dbmover.cfg) on the system on which the database resides.
User Name	Required	A user name that has the authority to connect to the database. For targets on supported Linux, UNIX, or Windows systems, if you have enabled PowerExchange LDAP user authentication, the user name is the enterprise user name. For more information, see the PowerExchange Reference Manual .
Password	Required	A password for the specified user. Passwords that are less than nine characters in length are not validated. To avoid errors that might arise due to code page differences, Informatica recommends that the password includes only those characters that are allowed for passphrases. For nonrelational targets on z/OS, and for sequential target files on i5/OS for bulk data movement, you can enter a valid PowerExchange passphrase instead of a password. An i5/OS passphrase can be from 9 to 31 characters in length. A z/OS passphrase can be from 9 to 128 characters in length. A passphrase can contain the following characters: Uppercase and lowercase letters The numbers 0 to 9 Spaces The following special characters: ’ - ; # \ , . / ! % & * ( ) _ + { } : @ \| < > ? The first character is an apostrophe. Passphrases cannot include single quotation marks (‘), double quotation marks (“), or currency symbols. On z/OS, the allowable characters in the IBM IRRPHREX exit do not affect the allowable characters in PowerExchange passphrases. On z/Os, valid RACF passphrase can be up to 100 characters in length. PWXPC truncates passphrases longer than 100 characters when passing them to RACF for validation. To use passphrases, ensure that the PowerExchange Listener runs with a security setting of SECURITY=(1,N) or higher in the DBMOVER member. For more information, see "SECURITY Statement" in the PowerExchange Reference Manual .
Multi-Record Datamaps	Optional	Select to list multi-record data maps. IMS unload targets only. For more information, see Multi-Record Writes to Nonrelational Targets.
Use Sequence Fields	Optional	Select to generate sequence fields in the target. IMS unload targets only. You can select this option only if you also select Multi-Record Data Maps . For more information, see Multi-Record Writes to Nonrelational Targets.
Source Type	Required	Select one of the following target types: ADABAS, IMS, SEQ, or VSAM.
Network Timeout	Optional	Number of seconds that elapse during a network send or receive operation before PowerExchange ends the connection and issues a timeout error message.
Schema	Optional	Enter a schema name to filter the resulting data maps.
Map name	Optional	Enter a data map name to filter the resulting data maps.
Respect Case	Optional	If selected, PowerExchange filters data maps by using the exact case of the Schema and Map name fields. Otherwise, PowerExchange ignores the case when searching for data maps.
Selected Datamaps	n/a	Lists the available data maps for the connection, database and filter details that you entered.

Optionally, define a filter to narrow the list of schemas and tables.

To define a filter condition, enter a schema name, a table name, or both. You can enter name patterns by using the following wildcard characters:

*
(asterisk). Represents one or more characters.

?
(question mark). Represents one character.

For example:

A* displays schemas and tables that begin with an A.

*A displays schemas and tables that end with an A.

*cust* displays schemas that contain “cust.”

Click

Connect

The Designer displays the metadata for the data maps to import in the

Selected Datamaps

box. If no data maps are found, the Designer displays “No Data Found.”

Select the data map or data maps that you want to import.

To make multiple selections, use the Shift key or Ctrl key or click

Select all

Click OK
.

The target definitions are displayed. The Designer uses the data map names as the names of the target definition.

If you select more than one target object in the

Import from PowerExchange

dialog box and do not select

Multi-Record Datamaps

, the resulting target objects might have no columns.

To avoid this problem, select

Respect Case

in the

Import from PowerExchange

dialog box.

Working with Nonrelational Source and Target Definitions

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 Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Importing Nonrelational Target Definitions

Importing Nonrelational Target Definitions