Is it possible to create a hierarchy structure when synchronising data from a CSV? We need to create AccProductGroups in a hierarchy, and it can go many levels deep.
I tried using sync editor but it only creates the first root node (hierarchy sync flag is set on the mapping)
Our CSV schema is something like this
We need to create
In reply to Tim Staddon:
I have to correct the answer from Tim here.
It is, of course, possible to import hierarchies using the CSV connector without having to execute the import several times.
The synchronization engine of One Identity Manager supports a feature called automatic dependency resolution that auto-generates import step in your synchronization workflow to re-execute hierarchy mappings if they couldn't be satisfied during the first synchronization run (obviously the case when you import a hierarchy from a CSV file and the CSV file is not sorted).
There is also a video on YouTube that demonstrates the use of this feature. https://www.youtube.com/watch?v=k2JJbfOLZSU&index=10&list=PL242czeZwlAlLnykigzKSjywrA8ZkaxLA
To use this your synchronization workflow needs to have the dependency resolution set to Automatic and the maintenance mode on the startup configuration for the synchronization workflow must not be set to No maintenance. In case of your multi-level hierarchy, it might be necessary to set the maintenance mode to Full maintenance and adjust the number of retries accordingly.
In reply to Markus Weiss-Ehlers:
It should also be possbile to import simple hierarchy structures by having the entries in your import csv in the right order, i.e. sorted by level top-down (Parent, Child1,Child2, Grandchild, Grandchildchild), and then use foreign key resolution for the parent column I've been successfully importing configuration parameter structures like that, without using the dependency resolution features or mutiple passes.
EDIT: I was actually referring to DataImport here, not sync editor. Maybe it applies for the csv connector as well?
In reply to Christian Ageu:
You can define one column as hierarchical sort criteria in the schema definition of the CSV connector as well. Please keep in mind that only one column can be marked as such.