Hi,
I am currently reviewing my existing LDAP Server connection, which frequently syncs data into the User table using the derived LDAP OU Definitions associated with Data Sources.
My understanding is that the connection pulls data from the derived LDAP connection and, using the LDAP OU Definition and Data Source, first syncs the data into the LDAP_IMPORT table. Then, if there are any updates from the latest sync, the transform maps associated with the Data Source are triggered, updating the values in the User table from the LDAP_IMPORT table.
On the other hand, I have a Scheduled Import for the same Data Source associated with the LDAP server, which runs every Saturday. Since the LDAP_IMPORT table automatically triggers the associated Data Source and transform maps whenever a new update is synced from the server, I wanted to validate whether all the changes from the server sync into the User table without relying on the Scheduled Import.
To test this, I enabled the Scheduled Import in one of my Sub-Prod instances while disabling it in another. I ran the import on Saturday, compared the results, and noticed inconsistencies between Dev and QA (where the Scheduled Import was turned off).
Areas I Need Clarification On:
1. LDAP Server Connection Behavior:
- My expectation is that the LDAP Server connection should automatically trigger the associated transform maps whenever new updates are received, based on the listen interval, which is set to 5 minutes.
- Is my understanding correct? Does the data sync between the LDAP Server and LDAP_IMPORT table occur every 5 minutes?
2. Data Consistency & Automatic Sync:
- If the LDAP_IMPORT table automatically triggers the transform map associated with the LDAP Server, then it should always contain up-to-date information since the listen interval is 5 minutes.
- However, I noticed data inconsistencies when the Scheduled Import was turned off in QA but remained active in Dev.
3. Possible Cause of Inconsistencies:
- The Scheduled Import and LDAP Server connection both use the same Data Source and same transform maps, yet the results differ when the Scheduled Import is disabled.
- What could be causing this inconsistency?
It would be great if you can let me know what does the highlighted fields in image describes.
I'm looking for guidance on better understanding how my LDAP Server connection syncs data into the User table and what might be causing these discrepancies. Your help is greatly appreciated!
