Skip to end of banner
Go to start of banner

Code-Free Flat File

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

EmpowerID provides an easy-to-use flat file connector to synchronize accounts and supporting data with 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 connectors are designed for Bi-Directional sync, EmpowerID periodically exports flat files with changes that can be used to write back these changes in your external system.

Flat file connector supports 3 modes of synchronization between your external systems and EmpowerID, synchronization process happens repetitively at scheduled intervals.

Inbound 1: An Inbound flat file connector is used to sync Identity data from the external systems into EmpowerID. 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 into 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 with the help of the Outbound Flat Connector. This helps to write back the changes from EmpowerID into the external system. Any person, group, role, and location changes made within EmpowerID are identified and processed by the outbound processes 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 on a scheduled basis. This connector also provides a “Processing Action Column“, which defines if an identity record was modified, deleted, or added within the EmpowerID system.

Bidirectional 1 2: A bidirectional flat file connector the synchronization of data from the External system into EmpowerId and vice versa using 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. Both Inbound1 and Outbound2 processes described above are executed by the Bidirectional flat file connector.

FlatfileConnector.mp4

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.

  • No labels