Hello.
I configured the native DB connector on another SQL server.
I have a point of view called the Department. I have 3 columns (Name, DEP_KEY, PARENT_DEP_KEY), I need to sync this in OneIM preserving the hierarchy.
I created a virtual attribute on the OneIM side and specified:
Key resolution by reference
base prop:UID_ParentDep
search prop: DepartmentName
Mapped this attribute to my attribute ( PARENT_DEP_KEY)
After synchronization, I expect to see in OneIM the proper hierarchy of departments, but it has not been complied with.