Doubts on filtering condition in synchronization editor

Dear Everyone,

We are currently syncing attributes from a target system to One Identity Manager using the Sync Editor. So far, we have applied System Filter conditions to load the particular data such as:

  • Person ID is not null

  • Employee number starts with 10, 20, or 30

Additionally, we added Object Filter conditions like:

  • Manager’s employee number is not null

  • Employee gender is either “M” or “F”

However, the synchronization is taking a lot longer than expected. This is because the Object Filter processes each employee record one by one, which is not efficient for our environment.

My questions are:

  1. Is there an alternative or better way to apply such filters within the Sync Editor to improve performance?

  2. Can we combine System Filters and Schema Class Filters to achieve this filtering more efficiently?

I’d appreciate any suggestions or best practices. Thanks in advance!

  • Hi shanmugaprabhu c, what you see is the usual processing of object filter: object filter is applied after selection. This behaviour is mentioned in Synchronizationeditor on information panel at schema class definition control. Most effective filtering is done by system filter - this is applied before data is selected from database or target system.

    regards,

       Tino

  • Hi Tlinder,

    Thank you for your response

    I agreed that system filter will be the best optimized solution to fiter the data before data is selected from database or taget system.

    My questions :Can we combine System Filters and Schema Class Filters to achieve this condition more efficiently to get the data ? . Considered as we not able to add some condition in system filter , so Thinking about to add some condition in the schema class filter along with system class filter to acheice the data filter confition.

    Feel free to post your response / suggesstions here.

    Thanks in advance.

    Regards
    Shanmuga prabhu

  • Hi Shanmuga prabhu,

    yes, you are allowed to combine both filter types.

    regards, 

      Tino