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

Configuring Sessions for LDAP Sources

You can configure the following session properties for LDAP sources:

Source Filter: Configure a filter condition to query for the LDAP entries. Use the standard LDAP syntax for filter expressions. For example, “(&(sn=Geisel)(mail=*))” Default is blank.; You can include parameters and variables in a filter condition.; The PowerCenter Integration Service handles parameters and variables in the following order:

Predefined server variables

Mapping parameters and variables

Workflow variables

Session parameters

Source Filter File Name: Directory location of the file and the file name that contains multiple filter conditions to query the LDAP entries.; For example,
C:\export\LDAPSourceFilter.txt; Use the LDAP syntax for filter expressions. For example,
(&(sn=Geisel)(mail=*))
. Specify each filter condition on a new line.

The source filter takes precedence over the source filter file you specify in the session properties.

Change Data Capture: The PowerCenter Integration Service captures the changed data and writes the changed data into the target. The PowerCenter Integration Service runs a session to migrate the data and the subsequent sessions report the changed data.

Change Data Capture file directory: Directory location where the change data file is created. The file stores the change number and time for the last read changed entry. Default is $PMRootDir/CdcFiles.

Change Data Capture filename: File name for Change data capture where the changeNumber and changeTime attributes are stored for the session.

Reset Changelog Cache: Migrates the LDAP data into a target and indicates that the changes are not to be fetched. Default is No.

Treat Data Conversion Error As: Set the following values to indicate how the PowerCenter Integration Service treats the data conversion errors:

Fatal. The PowerCenter Integration Service fails the session if the data conversion error occurs.

Replace with Null. If a data conversion error occurs, the PowerCenter Integration Service sets the LDAP attribute value to null and increments the error count. The PowerCenter Integration Service fails the session when the error count reaches the error threshold.

Default is Fatal.

Auto Select Page Control: Specifies the page control which is configured for the LDAP directory server to retrieve entries in pages.

Page Controls: Specifies the page control to retrieve directory entries in pages. Use the following page controls:
Virtual List View Control
Paged Results Control

If you change the default value for the session properties, the PowerCenter Integration Service overrides the value of the corresponding property in the Application Source Qualifier.

You can include parameters and variables in a sorted port condition for the session level. The PowerCenter Integration Service processes parameters and variables in the following order:

Predefined server variables

Mapping parameters and variables

Workflow variables

Session parameters

You can view load statistics in the session log. The load summary in the Workflow Monitor does not display load statistics.

Rename Saved Search

Table of Contents

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Configuring Sessions for LDAP Sources

Configuring Sessions for LDAP Sources