OIM's New Flat File Connector

-
In this post, I will talk about OIM's new flat file connector which was released some time back.
After doing some testing with the connector , these are my findings on the connector.


  1. 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.
  2. It relies on schemaFile to manage and define the structure of data, primary key, date key, mutivalued data.
  3. You can manually edit the schema file (.properties) to declare fields and their properties.
  4. Data file sits separately on the server with the first line just containing the column header followed by records of data.
  5. You can load/reconcile users, accounts, roles, entitlements, connected/disconnected resource data etc. using this connector.
  6. you can create custom parsers for parsing data which is in other format than CSV.
  7. it also supports reconciling complex multivalued data.
  8. delimiter, comment, mutivalued data indicator characters are configurable.
  9. if data contains " " spaces then it should be double quoted. (text qualifier=" configurable option)
  10. 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.
  11. It supports Preprocess and Postprocess 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.
  12. reconciliation of deleted records is supported.
  13. Connector comes OOTB groovy script which is easy to use to generate trusted/target or disconnected application specific metadata (OIM artifacts)
  14. Most of the configuration can be changed during runtime by modifying lookups, schemaFile and dataFile. Lets 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.
  15. Archiving by default moves the processed file to the folder specified and zips it with a time stamp value.
  16. In case of failure, file gets moved to a failed folder
  17. Transformation and data validation is also handled.
  18. 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.

Comments

Post a Comment

Popular posts from this blog

OIM 11g Custom ADF Application Development

-
Image
In this post , I will cover the steps required to create a custom ADF web application. What this application does is facilitate Account Claim Process. Users has been migrated from some other IAM product to OIM and exist in disabled state and hence cannot login to perform Self Service operations. User needs to identify themselves by providing their personal details like personal identification number, zip code and dob etc. After successfully Identifying themselves they will be able to set a new password and set their challenge questions and answers. During this process the application will activate their account and set the new password and QnA. At the end of the process, they will be able to login OIM with their new password set. The application has been developed using JDeveloper using ADF technology to render user interfaces and MVC design pattern to keep the concerns separate. Application Structure                                                                                  
Read more

Oracle Identity Manager (OIM) Interview Questions

-
This is my 100th post on my blog and in this post, I will list down interview questions on OIM. This post will always be work in progress as I keep appending this list with more and more questions. Please find the list of questions below :-) What are the new features in PS3 ? What are the differences between PS2 and PS3 ? How do you identify rogue account creation in target system ? What is the high level architecture of OIM 11g ? List out difference between OIM 9.1 and 11g and possibly 11gR2 What are the new features in 11gR2 PS2 , PS3 How do you save multi-valued attribute in process form and how the linking happens between process form & child form ,   1 child form per multi valued attribute Can we still use entity adapters in OIM 11g What is pluginservice in oim 11g/  What is the orchestration service in oim 11g. what is the difference between entity match found  and process match found ? what are service accounts in oim ? why remote manager is used ? What is a c
Read more

OIM 11g R2 PS2 : SOA Approval Workflow Sample

-
Image
In this post I am posting the sample code for a sample SOA approval workflow. Some of the features that this workflow addresses are Approval to Manager or Role Owners is dynamic based on the custom OIM system property "approval-condition". Value is set either "AND" or "OR". Manager or Role Owner can be set to be notified only with no approval required. In this case only email is sent to notify them but no approval is required from them. Custom OIM system property are created to address this.   manager-notify-only = TRUE or FALSE  TRUE = only notify the manager no approval request sent. FALSE = notify the manager and send an approval request.   roleowner-notify-only = TRUE or FALSE  TRUE = only notify the role owner no approval request sent. FALSE = notify the role owner and send an approval request. Third Level System Notification was required but it should be dynamic.  Custom OIM system property are created to address this sysadmin-noti
Read more