You want to import employee and organization 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	Harris	Clara	Marketing	London
2	Bloggs	Jan	Marketing	Berlin
3	King	Jenny	Marketing	London
4	Basset	Jenny	Sales	Berlin
5	King	Ben	Sales	London
6	Harris	Ben	Sales	Berlin

Employee objects, departments, and location will be added to the One Identity Manager database from this data. The CSV synchronizationThe process 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 mappingList of object matching rules and property mapping rules which map the schema properties of two connected systems to one another..

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 system. The schema describes all the master 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	Harris; Clara Bloggs; Jan King; Jenny Basset; Jenny King; Ben Harris; Ben
   Departments	Marketing; London Marketing; Berlin Sales; London Sales; Berlin
   Locations	London Berlin