OIM Flat File Connector Outline Steps

        This connector is the way to go while dealing with flat file trusted/target reconciliation and should be used instead of GTC as it done away with GTC wizard.

       It relies on schema File to manage and define the structure of data, primary key, and date key, multivalued data.

      You can manually edit the schema file (.properties) to declare fields and their properties.

       Data file sits separately on the server with the first line just containing the column header followed by records of data.

      You can load/reconcile users, accounts, roles, entitlements, connected/disconnected resource data etc. using this connector.

       You can create custom parsers for parsing data which is in other format than CSV.

       Delimiter, comment, multivalued data indicator characters are configurable.

       Flat File Header (column names in first line) can contain spaces to define column names. It need not be double quoted as it is not data.

       It supports Preprocess and Post process Handlers which can be handy for perform any job on the flat file directory, like zipping and unzipping files, encryption and decryption of the complete file dumps or specific fields in the files, virus scan of the files, or any other tasks limited only by the implementation of these tasks.

       Reconciliation of deleted records is supported.

       Connector comes OOTB groovy script which is easy to use to generate trusted/target or disconnected application specific metadata (OIM artifacts)

       Most of the configuration can be changed during runtime by modifying lookups, schema File and data File. Let’s say you add a new column then update the lookups then Schema File and then add the data in data file to get it working.

       Archiving by default moves the processed file to the folder specified and zips it with a time stamp value.

       In case of failure, file gets moved to a failed folder

       Transformation and data validation is also handled.

       This Connector can run on OIM machine or on a machine where Connector Server is running so this gives the additional flexibility of where to do all the processing.