Chat now with support
Chat with Support

Identity Manager 9.2 - One Identity Manager Connector User Guide

Setting up synchronization with the One Identity Manager connector Setting up system synchronization Setting up synchronization using custom configuration Troubleshooting

Speeding up synchronization with revision filtering

When you start synchronization, all synchronization objects are loaded. Some of these objects have not be modified since the last synchronization and, therefore, must not be processed. Synchronization is accelerated by only loading those object pairs that have changed since the last synchronization. One Identity Manager uses revision filtering to accelerate synchronization.

One Identity Manager supports revision filtering. The date of the last target system object change (XDateUpdated) is used as revision counter. Each synchronization saves the last date is was run as a revision in the One Identity Manager database (DPRRevisionStore table, Value column). This value is used as a comparison for revision filtering when the same workflow is synchronized the next time. When this workflow is synchronized the next time, the target system objects' change date is compared with the revision saved in the One Identity Manager database. Only those objects that have been changed since this date are loaded from the target system.

Synchronization is even faster if the change information on the schema type also takes deleted objects into account. If a schema type's objects were neither added, changed nor deleted, the synchronization step can be skipped. Objects must not be loaded for comparison. To take advantage of this optimization, the revision data for tables must be saved in both of the connected databases.

To use optimized revision filtering

  1. Start the Designer and connect to the central database.

  2. Set the Common | TableRevision configuration parameter.

  3. Save the changes.
  4. Connect the Designer to the work database.

  5. Set the Common | TableRevision configuration parameter.

  6. Save the changes.

Now each time a table changes, the table's revision date updates. This information is stored in the QBMTableRevision table, RevisionDate column. In this way, One Identity Manager identifies whether objects in a table have been added, changed, or deleted.

Synchronization with revision filtering compares a table's revision date against the revision saved in the One Identity Manager database. If the revision date is older, no objects have been changed in this table since the previous synchronization. Therefore, synchronization does not carry out this step for the affected schema type. If the revision date is newer, synchronization carries out this step and the changed objects are determined as described above.

The revision is found at start of synchronization. Objects modified by synchronization are loaded and checked by the next synchronization. This means that the second synchronization after initial synchronization is not significantly faster.

Revision filtering can be applied to workflows and start up configuration.

To permit revision filtering on a workflow

  • In the Synchronization Editor, open the synchronization project.

  • Edit the workflow properties. Select the Use revision filter item from Revision filtering menu.

To permit revision filtering for a start up configuration

  • In the Synchronization Editor, open the synchronization project.

  • Edit the start up configuration properties. Select the Use revision filter item from the Revision filtering menu.

NOTE: If the Common | TableRevision is not set, all revision data in the QBMTableRevision table is deleted.

For more information about revision filtering, see the One Identity Manager Target System Synchronization Reference Guide.

Starting system synchronization

Three schedules are generated for starting system synchronization. By default, synchronization is started once a day. If you want synchronization to start more frequently for certain tables, adjust the synchronization mode for these tables.

To change how frequently a table is synchronized

  1. In Designer, edit the table properties of the table you want to synchronize.

  2. On the System synchronization tab, select the Synchronization mode menu.

  3. Select the synchronization frequency.

    • If you want to start synchronization several times a day, activate Start synchronization frequently.

    • If you want to start synchronization several times per hour, activate Start synchronization very frequently.

    If none of these options is enabled, this table will synchronized once a day.

  4. Save the changes.

NOTE: Synchronization can only be started if the synchronization project is activated.

Related topics

Displaying the synchronization log

Synchronization results are summarized in the synchronization log.

To display a synchronization log

  1. In the Synchronization Editor, open the synchronization project.

  2. Select the Logs category.

  3. Click in the navigation view toolbar.

    Logs for all completed synchronization runs are displayed in the navigation view.

  4. Select a log by double-clicking it.

    An analysis of the synchronization is shown as a report. You can save the report.

Synchronization logs are stored for a fixed length of time.

To modify the retention period for synchronization logs

  • In the Designer, enable the DPR | Journal | LifeTime configuration parameter and enter the maximum retention period.

Modifying the synchronization configuration

A generated synchronization project can only be edited to a limited extend. The following changes are possible:

  • Connection credentials for the central database

  • Connection credentials for the work database

  • Selection of the tables to be synchronized and the mapped columns

    If the selection of the tables to be synchronized or the mapped columns is changed, the synchronization project will be updated automatically after a short delay.

Other manual changes to the synchronization configuration will be overwritten when the synchronization project is updated.

Related topics
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating