aaEmpowerID provides an easy-to-use flat file connector to synchronize accounts and supporting data from an external system. Universal Flat File Connector can inventory data from CSV or any flat file delimited by a pipe, a tab, or any single value character. You can dump account, role, and location data into any flat file supported by existing systems and inventory them into our system easily. This ensures you wouldn’t have to worry about the availability/development of API or other integration mechanisms in existing systems.
Flat file connector supports 3 modes of synchronization between your external systems and EmpowerID, this process happens repetitively at scheduled intervals.
...
Inbound 1: Identity, attribute inputs changes are synced from the external systems into EmpowerID. EmpowerID Worker Role Service processes all flat files dumped in a specific location by the external system, this path is configured as a setting while you create the Account Store. Data from files are compared with last synced data to find account attribute changes, role/location changes, and other inbound processing tasks to update person identity based on configured attribute flow rules.
Outbound 2: Changes of identity and attribute flow in EmpowerID are provided as Flat Files to external systems. Provisioning policies within the EmpowerID system determine the target systems and scope of the identities be provisioned or de-provisioned in target systems. These changes identified by outbound processing in EmpowerID are dumped into flat files. These flat files can then be processed by an external system. Jobs are used to dump flat files on a scheduled basis into a configured outbound file path. User can specify values for “Processing Action Column“, exported files will have this column that will flag each record was modified, deleted or added within EmpowerID system.
Bidirectional: EmpowerID syncs the changes from the external system and also provides data about the changes in EmpowerID as flat files. Bidirectional Flat file connector reads current state data from the target systems and reconciles with the data in the identity warehouse to maintain synchronization with the external system using flat files.
The flat file connector is highly flexible that lets you configure granular settings for the inventory process, hence it is capable of handling any files. Some important configurations that make it universal are
File Path (Inbound) path to flat file dump of external systems, EmpowerID background jobs will find files in the location on scheduled intervals and inventory them.
File Path (Output) path to flat file dump of EmpowerID. EmpowerID will periodically dump flat files in the given location as configured on settings.
Delimiter of the flat files.
Mandatory Fields are the columns that should be mandatory present for a record to be completed. Any rows missing mandatory fields will be ignored. Notification and a file of such incomplete records can be received in the mailbox.
Primary Key is the identifier of a record in external systems. EmpowerID uses this property to determine the changes in the attributes, similarly, EmpowerID provides this data in dumped files so that external systems can link the records correctly in their system. EmpowerID finds duplicates by using
Data Model Mapping File Path is a file that has a configuration of mapping between attributes in an external systemand EmpowerID. All mapping in the file is stored as Attribute Flow Rules in the system, you will be able to configure each attribute direction
...