OpenIDM is a relatively young product and still in evolution, that is why some subjects are not yet deeply explained in the documentation. Unfortunately, the very useful scripted SQL connector is affected by this lack of information. In this post, I will just talk about the groovy part of this connector and especially about the search script one.
In the official Integrator’s Guide of OpenIDM, we can read these lines about synchronization :
OpenIDM performs synchronization action in two phases. First, OpenIDM performs the so called source reconciliation, where OpenIDM accounts for source objects and associated links based on the mapping configured. Second, OpenIDM runs the target reconciliation, where OpenIDM iterates over the target objects not processed in the first phase.
If we are using the Scripted SQL Connector as a source, during the target reconciliation, the search script is called by OpenIDM with a query map containing the _UID_ key and the value of the current target object id. It is very important to actually use these information in the main search query of your script (in the where clause for example). This will improve a lot the execution speed of the reconciliation. You can take a look at the pretty telling third OpenIDM sample (samples/sample3/tools/SearchScript.groovy).

Les derniers articles par janua (tout voir)