Create Data Model Mapping File

When working with delimited files in EmpowerID, you can easily map their columns to the corresponding object attributes by using a data model mapping file. This file specifies which attributes of an EmpowerID Data Model should be exported to which column in the flat file in outbound mode, and in inbound mode, it indicates which columns need to be imported into which attributes of the EmpowerID Data Model. For instance, you can export the attribute BirthDay from EmpowerID into the Date_of_Birth column in flat files or import data from the Date_of_Birth column into the BirthDay attribute in the EmpowerID database. It's important to note that the mapping file must be in CSV format.

Download Sample Files

For your convenience, we have included a sample model mapping file and a CSV file containing data that you can use to test the Flat File Connector. These resources can serve as a starting point to help you get a better understanding of how the file works, and you can modify them as per your specific needs. Please feel free to download and customize the files as per your requirements.

How to Create A Data Model Mapping File

To create the mapping file, you will mainly need ObjectAttributeName, PersonSecurityBoundaryAttributeName, SystemSecurityBoundaryAttributeName, RbacObjectName, SystemSecurityBoundaryAttributeName & SyncDirection. Please find the details below about how you can find this information/attributes to complete the mapping file.

ObjectAttributeName

The first information to populate in the mapping file is ObjectAttributeName. Please follow the details below to find the ObjectAttributeName,

1. Navigate to Admin → Application and Directories → Manage Schema

2. Click on the Security Boundary Attributes tab.

3. Click on the down arrow 🔽 on the search textbox to bring advanced search options.

4. Now, we will find the required Object Attribute. Select the Security Boundary Type and click on Search.
   One easy way to find the object attributes is to search by Security Boundary Type. E.g., You want to write the LOCAT attribute to the flat file. If you know that this attribute comes from the SAP-HR, you can filter the results using the same Security Boundary Type.

   

5. Find the object attributes for the field you are looking to import/export. Please add the required attribute to the ObjectAttributeName column on the mapping file.
   E.g., you can see that the Object Attribute for LOCAT is StreetAddress3, so that's the Name of the attribute "StreetAddress3 "to map in the ObjectAttributeName column of the mapping file.

PersonSecurityBoundaryAttributeName:

We have already explored how to find the ObjectAttributeName in the previous section. The mapping file also contains a column for PersonSecurityBoundaryAttributeName, which must be specified for all the attributes you have in the ObjectAttributeName column. Please follow the details below to find the PersonSecurityBoundaryAttributeName,

1. Navigate to Admin → Application and Directories → Manage Schema

2. Click on the Security Boundary Attributes tab.

3. Click on the down arrow 🔽 on the search textbox to bring advanced search options.

4. Change the Security Boundary Type to EMPOWERID, provide the ObjectAttribute Name you are looking for, and click on search. In the screenshot below, we are searching for StreetAddress3.
   

   

5. Find the PersonSecurityBoundaryAttributeName and add it to the mapping file. e.g., StreetAddress3 is the PersonSecurityBoundaryAttributeName for the attribute.

SystemSecurityBoundaryAttributeName

SystemSecurityBoundaryAttributeName is the column name in the Flat Files. Please specify the column headers for attributes to target while exporting or importing the data from the connector.

RbacObjectName

Specify “Account "as the RbacObjectName.

RbacObjectAttributeName

RbacObjectAttributeName is the Name of the mapped attribute in the Account table. Please follow the steps below to find the list of RbacObjectAttributeName information.

1. Navigate to Admin → Application and Directories → Manage Schema

2. Click on the RbacObjectAttribute tab.

3. Click on the down arrow 🔽 on the search textbox to bring advanced search options.

4. Type Account in the ComponentName and click on Search to filter all Account object attributes. You can also specify a name to find attributes with a similar name. If no similar attribute exists in Account RbacObject, an ExtensionAttribute or a CustomAttribute can be used.

   

5. Find the Name of the attribute you want and add the names for the attributes in the mapping file. E.g., There is an attribute of StreetAddress3 for the account in the screenshot above.

SyncDirection

Please specify the mode of synchronization of a particular attribute between an external system and EmpowerID.

Once you have mapped all the attributes described above, you can use the Data Model Mapping File to create the Flat File Connector account store.