PowerExchange for LDAP User Guide for PowerCenter

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

Back Next

Importing LDAP Source and Target Definitions

Use the Import from LDAP Directory Wizard to import LDAP source and target definitions into the PowerCenter repository. When you import the LDAP source and target definitions, the Designer displays a table with columns and LDAP datatypes.

The following table lists the default precisions for creating a source or a target in the Designer:

Attribute / Datatype	Precision
dn	1024
String	255
Binary	65535
Date/Time	255
Integer	10

If you create a source or a target with the precision greater than the default precision, you can update the precision value as required. For the string datatype, if the extracted data is longer than the set precision, the PowerCenter Integration Service truncates the data. For all other datatypes, the PowerCenter Integration Service fails to read or write the data if the precision is greater than the default or the set precision.

In the Source Analyzer, click Sources > Import from LDAP Directory. Or, in the Target Designer, click Targets > Import from LDAP Directory.

The Import from LDAP Directory Server wizard appears.

Enter the following information:

Connection Parameter	Description
LDAP Host	LDAP directory server host name.
LDAP Port	LDAP directory server port number. Default is 389.
Anonymous Access	You can access a directory server as an anonymous user without authentication.
LDAP User	LDAP user name to connect to the LDAP directory server.
Password	Password to connect to the LDAP directory server. If you do not enter the password, the Client establishes an anonymous connection.
Secure Connection	Establishes a secure connection to the LDAP directory server. Select this option to specify the SSL or TLS type of connection.
Security Type	The security type used to establish secure connection with SSL or TLS. If you use TLS to establish a secure connection, select one or both of the following options: Connection. Secures the connection. Data Transfer. Secures the data transfer.

For more information about the connection parameters, contact your LDAP system administrator.

Click Connect.

If you click Connect after entering any details in the subsequent pages of the wizard, a new connection is established.

Click Next.

Step 2 of the wizard appears.

Enter the following information to view the LDAP directory server DIT:

Parameter	Description
Naming Context	Naming context for the LDAP directory server.
Filter Value	Filters the entries based on the standard LDAP filters.
Maximum Entries	Maximum number of entries to display in the DIT.
Maximum Search Time	Maximum amount of time in milliseconds to wait for the search results.

Click Show Entries to browse the LDAP directory server DIT to select the base DN node. The Attribute pane displays the attribute details for the selected base DN. The selected base DN appears at the bottom of the page. If you select the naming context and click Next without viewing the entire DIT, the selected naming context appears as the base DN at the bottom of the page.

Click Next.

Step 3 of the wizard appears.

Enter the following information to select the object classes and attributes:

Parameter	Description
Object Classes	Displays the list of object classes present in the schema.
Object Class Attributes	Displays the attributes for the selected object class along with the attribute identifiers such as Name, Description, and Must or May attributes. Use the following options to select the object class attributes: Select None. Select this option to clear the selection. You can manually select the object class attributes. Select All. Select all the object class attributes. Select All Must. Select all the MUST object class attributes. Select All May. Select all the MAY object class attributes.
Include parent class attributes	Includes the parent class attributes of the selected object class in the Object Class Attributes list.
Selected Attributes	Displays the selected single-valued or multi-valued attributes as the column of the source or target table.

For a target, in the Select Attributes section, select at least one field as the primary key.

For a source, the dn attribute is used to retrieve the distinguished name for the entries from the LDAP directory server. For a target, the dn attribute is used to insert, update, or delete the entries on the basis of their distinguished name from the LDAP directory server.

Optionally, click the Data Preview tab to preview the data for the selected attributes.

You can preview data for an LDAP source. You cannot preview data for an LDAP target.

Click Next.

The summary page appears.

Enter the source or target definition name.

Click Add to Import List to add the source or target definition to the import list.

If you select all single-valued attributes, the Designer creates a single group definition. If you select a multi-valued attribute, the Designer creates a multi-group definition.

Optionally, click Import Another Source to import another source. Or, click Import Another Target to import another target.

Repeat steps Importing LDAP Source and Target Definitions to Importing LDAP Source and Target Definitions to import another source or target definition.

Rename Saved Search

Table of Contents

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Importing LDAP Source and Target Definitions

Importing LDAP Source and Target Definitions