CA Identity Manager Connector Guides › Connectors Guide › Bulk Load Client › Configuring the Bulk Load Client › Properties File Example

Properties File Example

The following is an example of the Properties file used to configure the Bulk Loader Task and the Bulk Load Client:

#
# These are the connection details of the CA Identity Manager Server
#

# administrator id and password to be used to carry out the task
user=admin1
password=FPWg3MtYrUnididAMY06LZT/3LPuMtu6O7A+DRzX1JI\=

# server URL
serverUrl=http://imhostname:8080/iam/im/TEWS6/myime?wsdl

#
# these are the configuration items for the CA Identity Manager ObjectsFeeder task
#

# CA Identity Manager parser to be used for the ObjectsFeeder task
feederParserClass= com.ca.identitymanager.feeder.parser.CSVParser

# The unique identifier attribute name (column name in the CSV file)
uniqueIdentifierAttrName=uid

# The action attribute name (column name in the CSV file)
actionAttrName=action

# The primary object for the ObjectsFeeder task. (This will always be USER”)
primaryObject=USER

# The action to admin task mapping
actionToTaskMapping = create.Create User;modify.Modify User;delete.Delete User
actionToTaskMapping = create.Create User;modify.Modify User.Create User;delete.Delete User, used when the Administrator wants to create a user if the requested user does not exist for modification

# Is the web service protected by SiteMinder
isProtectedBySiteMinder=false

How to Use Kettle Pentaho with the Bulk Load Client

You can use the Bulk Load Client to also run a Kettle job before the bulk load process using the Bulk Load Client command line options. <Insert X-ref to “Bulk Load Client Command Line Options” topic>

The sample uses the following options:

imbulkloadclient.bat -f Kettle -t C:/MyKettleJob.kjb -o C:/MyOutput.csv -x 60 

The following sections explain each option:

• Select the Kettle Job Option
• Specify the Kettle Job File
• Specify the Output File to Bulk Load
• Specify a Timeout for the Kettle Job
• Example of Executing a Bulk Load Client with Kettle

Select the Kettle Job option

-f Kettle 

This option specifies that a Kettle job is going to be run. The base option, -f / --format <value>, determines the format of the input file / transform.

Specify the Kettle Job file

-t C:/MyKettleJob.kjb

This option specifies C:/MyKettleJob.kjb as the file (and its location) used as the template for the input file transformation.

Note: This command string does not use the existing -i / --inputFile option for a Kettle Job. Loading the input file should be part of your Kettle Job/Transform

Specify the output File to Bulk Load

There are two ways to specify the output for the Kettle Job that will be bulk loaded.

When outputting the Kettle to a single file, you would use an option similar to the following:

-o C:/MyOutput.csv

The -o / --outputFile <value> option determines the file of transformation process.

When outputting the Kettle to several files, you would use options similar to the following:

-d C:/MyOutputDir -O MyOutput1.csv,MyOutput2.csv

This uses the following command line options:

• -d / --outputDirectory <value> : the directory that contains files output from the transformation process. Note that this is a Kettle-only option.
• -O / --outputFileList <value> : A comma-delimited list of files located in the outputDirectory. Note that this is a Kettle-only option

Specify a Timeout for the Kettle Job

-x 60

This is the Timeout for Kettle transformation, in seconds.

This command is based on the following format:

-x / --transformTimeout <value> 

Note: This command is optional.

Example of Executing a Bulk Load Client with Kettle

For a single output file:

imbulkloadclient.bat -f Kettle -t C:/MyKettleJob.kjb -o C:/MyOutput.csv -x 60 

For multiple output files:

imbulkloadclient.bat -f Kettle -t C:/MyKettleJob.kjb -d C:/MyOutputDir -O MyOutput1.csv,MyOutput2.csv -x 60