You want to import employee and organizationGroups hierarchical rolessee: hierarchical role department, cost center, and location together. data from an external personnel management system into One Identity Manager. All the data is provided in a CSV file and transferred to the database through the CSV connectorSystem connector which allow data to be imported from CSV files. in the One Identity Manager database.

Table 38: Example of a CSV file

	Lastname	FirstName	Department	Location
1	Name1	User1	Marketing	London
2	Name2	User2	Marketing	Berlin
3	Name3	User3	Marketing	London
4	Name4	User4	Sales	Berlin
5	Name5	User5	Sales	London
6	Name6	User6	Sales	Berlin

Employee objects, departments, and location will be added to the One Identity Manager database from this data. The CSV synchronizationThe processSequence of process steps for mappingList of object matching rules and property mapping rules which map the schema properties of two connected systems to one another. an operational workflow. The process steps are connected to one another by predecessor/successor relationships. This functionality allows flexibility when linking up actions and sequences on object events. of comparing data between One Identity Manager and a target system. Objects and their properties are compared by fixed rules. Synchronization results in the identical data situation in the target system and One Identity Manager database. exits with an error when a second object with the same name is added because the names of the departments and location are not unique. This can be prevented.

Which objects should be created?

1. Employees with the LastName and FirstName properties. Object can be uniquely identified through these two properties. The file contain six different objects.

2. Departments with the Department and Location properties. The file contains four different objects.

3. Location with the Location property. The file contains two different objects.

For 2. and 3. distinct objects must be supplied Therefore, schema classes with the class type "Unique objects" are created in the mapping.

To set up the mappings

1. Create a mapping for employees.

   • Create a new schema class in the target system.

     Select the Generic schema class class type and enter the mandatory data.

2. Create a mapping for the department.

   • Create a new schema class in the target system.

     1. Select the Unique objects class type and enter the mandatory data.

     2. Enable Department and Location on the Distinction tab.

        The schema class filters exactly those objects from the CSV file that are unique identifiable by the combination of Department and Location.

3. Create a mapping for the location.

   • Create a new schema class in the target system.

     1. Select the Unique objects class type and enter the mandatory data.

     2. Enable Location on the Distinction tab.

        The schema class filters exactly those objects from the CSV file that are unique identifiable by the Location property.

4. Check the filter results in the target system browser.

   Table 39: SchemaData model of a connected systemSystem the objects and their properties are transferred to during synchronization. The connected system is defined by the synchronization direction. Example of synchronization direction "Target system" (One Identity Manager -> Active Directory): Here Active Directory is the connected system and One Identity Manager is the primary system of synchronization.. The schema describes all the main data from the connected system. see target system schema; see One Identity Manager schema; see connector schema; see extended schema class definition results

   Schema classSubset of a schema type. The result list of a schema type is filtered by defined criteria. Example: Active Directory contacts are Active Directory user accounts with the property objectclass = "CONTACT".	Filtered Objects
   Employees	Name1; User1 Name2; User2 Name3; User3 Name4; User4 Name5; User5 Name6; User6
   Departments	Marketing; London Marketing; Berlin Sales; London Sales; Berlin
   Locations	London Berlin