CA Role & Compliance Manager (RCM) Automation using .SBT files

***NOTE: As with all Tips and Tricks we provide on the IDMWorks blog, use the following AT YOUR OWN RISK.  We do not guarantee this will work in your environment and make no warranties***

Most tasks using CA RCM can be automated by using a simple batch language.  The advantages of using this automation is:

    • Reproducing imports, filters, merges, and enhancements of data that would executed multiple times manually.
    • Eliminating errors in data manipulation that would normally occur when conducted manually.
    • Reducing the time it takes manipulate RCM data for use.

The RCM documentation is rather lacking as to the commands that are available to use for RCM automation and I hope this document will provide assistance and information of .SBT file commands and use.  The batch files can be run in two methods; directly by executing the batch command from the DM utility or by creating a batch control file that can execute multiple batch files.  The advantage of using a batch control file (IMHO) allows flexibility in:

    • Determining which utility will be used to run the batch file, which is useful when different versions of the DM utility process the commands differently (TSS and RACF imports work on 12.5 SP1).
    • Controlling log and error output from the batch runs,
    • Breaking the RCM automated tasks into steps for ease of maintenance and execution.
    • Manipulation of the data files pre or post batch execution.

Here is an example of batch control .CMD file that I use (remove the .RENAME)

Here are the .SBT files that are controlled, the following automated RCM tasks are demonstrated within the examples:

    • Import from TSS
    • Enrich User Database
    • Filter configuration
    • Import from Active Directory
    • Merge configuration
    • Trim configuration

Questions, comments or concerns?  Feel free to reach out to us at IDMWorks.