Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

EmpowerID 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 synchronization process happens repetitively at scheduled intervals.

...

Inbound 1: Identity, attribute inputs changes are synced An Inbound flat file connector is used to sync Identity data 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 An external system can dump identity data into common flat files, Inventory Job of EmpowerID will process the flat files on a scheduled basis, initially importing all data, and delta information from that point forward. Imported data are stored in EmpowerId Identity Warehouse as objects like User, Group, Location & Roles information of the account store. To capture all future data and changes, the inventory job continuously imports the flat files from configured storage path where the external system dumps the file.

Outbound 2: Identity object changes 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 with the help of the Outbound Flat Connector. This helps to write back the changes from EmpowerID into the external system. Any Person & Account attribute changes made within EmpowerID are identified and processed by the outbound processes and are written to flat files.

These flat files can be processed by an external system with their custom logic to write back the changes into the system. Inventory Job exports the changes into a configured outbound file path . User can specify values for on a scheduled basis. This connector also provides a “Processing Action Column“, exported files will have this column that will flag each which defines if an identity record was modified, deleted, or added within the EmpowerID system.

Bidirectional : EmpowerID syncs the changes from the external system and also provides data about the changes in EmpowerID as flat files. Bidirectional 1 2: A bidirectional flat file connector the synchronization of data from the External system into EmpowerId and vice versa using flat files. A bidirectional Flat file connector reads current state data from the target systems and reconciles it 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

...

Both Inbound1 and Outbound2 processes described above are executed by the Bidirectional flat file connector.

Info

Key Takeaways:

  1. Flat file connector is called a universal connector because it can be configured to process any flat-file format.

  2. Users can configure the delimiter for files for e.g. comma, tab, semicolon, or any other single character.

  3. Flat file connector supports 3 modes of synchronization Inbound, Outbound & Bidirectional mode.

  4. Inventory Job executes the synchronization on a scheduled basis.