Table of Contents

Search

  1. Preface
  2. Understanding PowerExchange for LDAP
  3. PowerExchange for LDAP Configuration
  4. LDAP Sources and Targets
  5. LDAP Mappings
  6. LDAP Sessions
  7. Appendix A: LDAP Datatype Reference
  8. Appendix B: Error Messages
  9. Appendix C: Glossary

PowerExchange for LDAP User Guide for PowerCenter

PowerExchange for LDAP User Guide for PowerCenter

Methods for Tracking Changes in Different Directories

Methods for Tracking Changes in Different Directories

LDAP tracks the changes made to the contents of a directory. LDAP uses the following methods to track changes in different directories:
  • Active directory. Active Directory stores the entry and the details for the changes made to the entry along with the entry. The PowerCenter Integration Service determines the change type based on the values for uSNCreated, uSNChanged, and isDeleted attributes of an entry. If an entry is created, the uSNCreated and uSNChanged contains same value. If you update an entry, the uSNChanged value is modified indicating that the entry is updated in the directory server. If you delete an entry, isDeleted is set to True indicating that the entry is deleted from the directory server. Data is retrieved for the uSNChanged attribute, regardless of whether uSNChanged is included as one of the columns in the LDAP source.
  • Other directory servers. The different directory servers are Netscape, IPlanet, SunOne, and IBM. The changes are logged under the default cn=changelog node. The directory server adds an entry for each add, modify, and delete operation to the directory under the cn=changelog node. Verify that the changelog option is enabled on the LDAP directory server.
    OpenLDAP does not support Change Data Capture because it does not provide change entries or changelogs.
The following figure shows an entry logged in the session log if you select Change Data Capture when you run the session:
The figure shows the entry logged in the session log.
The first time you run the session, the PowerCenter Integration Service migrates the following data to the LDAP directory server:

    dn: ou=people, o=airius.com

    mail: people@mail.com

The following table displays the data that the PowerCenter Integration Service migrates to the LDAP directory server:
Group
Data
parent
1, 0, ou=people, o=airius.com
2, 0, uid=scarter, ou=people, o=airius.com
3, 0, uid=tmoris, ou=people, o=airius.com
uid
1, 0, <NULL>
2, 0, scarter
3, 0, tmoris
mail
1, 0, people@mail.com
2, 0, scarter@mail.com
3, 0, t_moris@mail.com
3, 0, tmoris@mail.com
When you subsequently run the session, the PowerCenter Integration Service migrates the changes made to the existing data.

0 COMMENTS

We’d like to hear from you!