Generic File Driver for IDM, v 0.6



By: scauwe

January 31, 2013 5:33 am

Reads: 1227

License:
MPL (Mozilla Public License)

Download GenFileDriver_0_6

TOC

Introduction
New features and fixes
Installation

 

Introduction

The Generic File Driver is similar to the Text Driver shipped with IDM, but has more options, and has the capability to read virtually any file type. Out of the box, the following file types are supported: XML, CSV and XLS (the latter using POI from Apache).

Main differentiators to NetIQ’s driver:

  • Produces and consumes regular NDS documents (no need for XSLT conversion).
  • Accepts add, modify or instance documents on the subscriber channel.
  • Auto-query back for missing attributes on modify commands.
  • GCV (Ecmascript) for generating associations and source DN’s.
  • Publisher channels processes files in a streaming mode. A maximum of 20 records are prefetched/buffered in memory (whenever support by the file type: CSV and XML).
  • Publisher channel supports interruption (driver stop command) during file processing.
  • Publisher channel can add metadata about the file or record processed (eg: record number, filename, last record indicator, etc).

The original version I wrote in 2007 is located at http://www.novell.com/coolsolutions/tools/18671.html. This update comes with an IDM 4 package making the installation simpler and has some new features and fixes (see below).

See the referenced version for a list of the initial features.

 

New features and fixes

version 0.6, 28-FEB-2014 (package 0.5)

  • Shim/package feature: Added configuration parameter to use Quartz scheduler to close subscriber generated files using a cron-like expression string.
  • Shim feature: Added slf4j binding (separate jar) for Idm tracing, allowing Quartz logs to be shown in idm trace files.
  • Shim bug: possible NPE when the publisher folder becomes unreachable (eg due to network outage).
  • Shim feature: Added option for every strategy to receive driver shutdown notification by implementing IShutdown.
  • Shim bug/feature: Return an empty instance document when we receive an associated query on the subscriber channel. Reason: support of the merge attribute filter rules in case of a ‘sync’ event.

version 0.5, 21-JAN-2013 (package 0.4)

  • Shim bug: Fixed an issue wrt the driver not adding the metadata on the publisher channel.

version 0.4, 24-APR-2012 (package 0.4)

  • Shim bug: Fixed an issue with the driver schema (appeared to be hard coded).
  • Shim feature: Added beta support for query back. Query back only supported on publisher channel (when reading in a file). Feedback welcome.
  • Package bug: Fixed an issue that caused the driver configuration not to be imported when the package was imported.
  • Package bug: Changed creation policy from validating the Given Name to validating the Surname.
  • Package feature: Added package ‘Delimited Text Driver Password Synchronization Package’ as an optional package for this driver.
  • Package feature: Added remote loader prompts to the package.

version 0.3, 12-OCT-2011

  • Shim feature: automatic association and src-dn calculation (using ecmascript in the driver configuration). No longer need for style sheets for just creating association and src-dn values. The driver shim now does this for you.
  • Shim bug: fixed missing remove-all-values on the publisher documents.
  • Shim feature: added the ability (csv output files) to flush the file buffer after every record written (useful for when you are developing/testing your driver).
  • Shim feature: when receiving a modify event on the subscriber channel, the shim will query back for all missing attribute values in order to be able to write a complete record (no need for a stylesheet to query for missing attributes and keeping this stylesheet in sync with the schema).
  • Shim bug/feature: the subscriber channel now fully support add, modify and instance events. Instance and add events are assumed to contain all data and do not perform a query back. Only the modify event performs a query back

 

Installation

The attached zip file (GenFileDriver_0_6.zip) contains 2 main jar files and a lib folder. One jar is the package, one jar is the shim. The lib folder contains optional jars.

 

Shim: GenFileDriverShim_0.6.jar
Copy the shim to you eDirectory server (DirXML’s classes folder). If you want to use XLS support, also download poi from Apache. Restart eDirectory after this.

Note: if you have an older version of the shim, be sure to delete that jar.
Package: SVCGENFILEB_0.0.5.20140228171917.jar
Import this package into your designer project. Drag and drop the “Delimited Text” driver that is located under “Tools” and select the “Generic File Base” package, answering all the questions as needed.
From this point on, you can use and modify it as any other driver.

lib folder:
This folder contains some optional jars. These are only required if you plan to use quartz scheduler to close the generated files using a cron-like string. Jars required when doing this are: quartz-2.2.1.jar, slf4j-api-1.7.5.jar and slf4j-idmTrace.jar.

Policies

This driver only has 3 policies; all of them on the publisher channel. If required, you could add the password policies as available from the standard text driver (by creating your own copy from Novell’s package and adding this to the driver).
SVCGENFILEB-pub-mp
Match on Internet Email Address if any available.
SVCGENFILEB-pub-cp
Checks for mandatory attributes:
Surname: required due to eDir constraints
Internet Email Address: required due to use in matching policy
SVCGENFILEB-pub-pp
Placement based on a driverset GCV (idv.dit.data.users).

VN:F [1.9.22_1171]
Rating: 5.0/5 (2 votes cast)
Generic File Driver for IDM, v 0.6, 5.0 out of 5 based on 2 ratings

Tags:
Categories: Cool Tools, Identity Manager

Disclaimer: As with everything else at NetIQ Cool Solutions, this content is definitely not supported by NetIQ, so Customer Support will not be able to help you if it has any adverse effect on your environment.  It just worked for at least one person, and perhaps it will be useful for you too.  Be sure to test in a non-production environment.

12 Comments

  1. By:joakim_ganse

    Hi,

    The wizard did not create the driver config properly for me.
    Had to copy and paste one from your previous version.

  2. By:al_b

    Hi,
    Could you advice please, how I can receive access to file metadata?

    I added in Publisher option elements of metadata:

    <definition display-name=”List of meta data elements that should be added:” name=”pub_metaData” type=”string”>
    <description>Publisher: List of meta data elements that should be added(recordNumber,isLastRecord,filePath,fileName,fileSize). The schema as given in the driver parameter ‘schema’ will be extended with all meta data elements listed. Separate each item with a comma.</description>
    <value xml:space=”preserve”>recordNumber,isLastRecord,fileName,fileSize</value>
    </definition>

    but I can’t see in a trace, that any of this elements available for me. :(
    I found ugly way to get access to recordNumber information via init-params, but I believe, that you foreseen more elegant and simple way.

    00:06:03 914 Drvrs: </add>
    <init-params>
    <publisher-state filePath=”c:\work\2013.01.20_00.06.03\dts.csv” fileReader=”info.vancauwenberge.filedriver.filereader.csv.CSVFileReader” recordNumber=”1″/>
    </init-params>
    </input>
    </nds>

    I tried to use version 0.4 (GenFileDriverShim_0.4.jar, SVCGENFILEB_0.0.4.jar), and may be some bug (or misunderstanding) prevent me from see this info.

    Thank you for your help,
    Alex

  3. By:joakim_ganse

    Hi,

    This is a truly brilliant driver :) Starting to replace all text drivers with this one.
    One thing I have noticed is that when using it with a Remote Loader on Winows I can not brows for the class.
    What I did was to choose a diffrent class and then edit the txt file.
    This is not enough though, I got a java Lang error.
    So I discovered I had to edit the registry as well, and pase in the classname there to.
    After that I could edit the config the normal way, had to put in the passwords again.

    The classname is info.vancauwenberge.filedriver.shim.driver.GenericFileDriverShim

    Cheers

  4. By:mJg2XW

    Hi.

    Greate driver:)

    Do the driver have some sort of PostProcessor funktion on the Publisher?
    /Michael

  5. By:joer999

    Exactly what I needed: a text driver which can produce CSV’s with a header. Also neat is the feature of the Work & Destination directory.
    Great work.

  6. By:mJg2XW

    Hi

    Sorry for my delay.

    I would like to send a XDS document to a diffrent driver or bumping up a “counter” on a specific object or just to do /generate some sort of events that signal that the .CSV driver i finish, so other driveres begin doing some work.
    /Michael

    • By:scauwe

      Hi Michael,
      You can have metadata in the driver to notify you when it is the last record of the file. You can always, in the command transformation on the publisher, react on this and do whatever you want after the last record (eg: increase a counter somewhere, create another object (workorder?),… so that another driver is triggered).

  7. By:mJg2XW

    Hi

    Thanks for your replay, I will give it a try.

    /Michael

Comment