With an outbound mode connector, EmpowerID can export data as file dumps that can be used by external systems to process with custom logic. Any person, group, role, and location changes made within EmpowerID are identified and are written to flat files. You can additionally configure flags to determine if a record was modified, deleted, or added. External systems can then import these file dumps with their processing logic. Follow the steps below to configure an outbound flat file connector,
Navigate to Admin → Application and Directories → Account Stores and Systems
Click on Create Universal Flat File Connector Account Store. You will see the Create page for the Flat File Account store.
Enter basic details for the resource system and Click on Submit.
Sync Direction- Choose the Outbound Synchronization mode of data
Name- Provide an Identifier for the account store.
Display Name- Please provide a descriptive & friendly name for the account store. The value provided for the display name appears in the UI.
After submitting the basic details, you can enter the configuration setting for the resource system.
Number of Export Files: Specify the number of files to create by the inventory job while exporting data from EmpowerID. If you have huge amounts of data to export, you might consider creating multiple files.
Data Model Mapping File Path: Provide the full path pointing to the Data Model Mapping File. For SaaS implementation, the path is a local path in the Cloud Gateway Server or a network path accessible from the could gateway server. Data Model mapping file maps the EmpowerID object attributes to the columns of the delimited file. In simple words, it specifies what data to export from EmpowerID to which column of the flat file.
Is Remote (Requires Cloud Gateway): If your EID instance is a SaSS tenant, please select the checkbox.
Choosing Select if Full File Export is Required checkbox will export all identity data into flat files. You will be asked additional fields for settings,
Delimiter For Full Export File: Specify the single character delimiter for export files. For e.g ", "comma for a CSV file.
Processing Action Column Name For Full File: Provide the column's name to include in export files that flag the nature of change in the row. Will consist value specified subsequently in action for full export.
Action For Full Export: Value to set for the action for the full export file.
Full Export File Time Stamp: This field contains the timestamp naming convention for the full export file. Providing a value will add a timestamp to the end of the filename of exported flat files.
Choosing Select if Delta File Export is Required is for differential export that only dumps records that have attribute changes since the last export was successful. Please configure the following settings for the delta files export.
Delimiter For Delta Export File: Specify the delimiter for export files. Use single character value for e.g ‘,' , '|'.
Processing Action Column Name For Delta File: Provide the column's name to include in export files that will record the flag indicating the nature of change in the row. The given column will have values specified on subsequent input fields for add, update and delete.
Action For Differential Export Add: Provide a single character value to flag a record as added. If a record was added after the last export, this value is set in the processing action column.
Action For Differential Export Update: Specify the single character that will identify a row as updated. This value would be set in the processing action column of the exported file if the record was modified after the last export.
Action For Differential Export Delete: Specify the single character that will be set in the processing action column when a record is deleted in EID after the last export.
Delta Export File Time Stamp: This field contains the timestamp naming convention for the delta export file. All files exported will append a timestamp with the provided naming convention.
Click on Submit to save the resource system settings.
If you have selected Is Remote in the previous screen of Resource System settings, a list will appear to choose the Cloud Gateway Servers configured for your SaaS tenant. Select the gateway servers and click on submit.
You will see a message Request complete! after the successful creation of the resource system.
You will have to restart IIS & the service pools of EmpowerID so that the account store can obtain the configuration information.
To restart the EmpowerID in cloud instance you can do the following.
Navigate to IT Shop-> Workflows
Click on Recycle Service Environment
If you have EmpowerID deployed On-premise, we will have to follow the standard windows procedure to restart the service and IIS.
Execute the command iisreset from the command prompt to restart your IIS.
Open Services. Click Start, click Run, and then type services.msc.
Right Click on the following services and click on Restart service
EmpowerID Web Role Service
EmpowerID Worker Role Service