How to check the report connection settings for Identity Manager

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

In Identity Manager there are two types of reporting, "Audit" and "Reporting".  These source their data from their own databases and while "Audit" is internal to Identity Manager, "Reporting" is made available via JasperServer.  To facilitate JasperServer reporting a snapshot database is used. 

Is there a way to check and configure the database settings for Identity Manager Reporting and Auditing functions?
 

Environment

CA Identity Manager\ Identity Suite 14.x with JasperServer

Resolution

By default the "Audit" connection is created during installation and can be identified by reviewing the "ca-standaline-full-ha.xml" file.  Simply search for "auditDbDataSource" and you should see an entry like the one below:

<datasource enabled="true" use-java-context="true" pool-name"="iam_im-imauditdb-ds" jndi-name="java:/iam/im/jdbc/auditDbDataSource" jta="false">
       <connection-url>jdbc:sqlserver://mssql1.<domain>.com:1433;selectMethod=cursor;DatabaseName=IM</connection-url>
        <driver>sqljdbc</driver>


Reporting Server Connection

The "Reporting" database connection is defined via the Identity Management User Console.

1. Login as an administrative user 
2. Navigate the "Tasks" menu to "System"
3. Under the "Reporting" option select "Report Server Connection"

This is where you enter the connection details for the JasperServer reporting server.  

For example:

Report Server URL: http://###.###.#.##:8080/jasperserver-pro
User ID: <user, default is imuser per our documentation>
Password: <password>


Snapshot Database Connection

The "Snapshot Database Connection" database connection is defined in the Identity Management User Console.

1. Login as an administrative user 
2. Navigate the "Tasks" menu to "Reports"
3. Under the "Snapshot Tasks" menu you can choose to create, delete, view or modify the Snapshot Database Connection.

The connection definition will have the following attributes:

Connection Name
Connection Type
Description
Host Name
Port #

For example:

Connection Name: rptParamConn
Connection Type: Snapshot
Description: Derrived from rptParamConn
Host Name: mssql1.<domain>.com
Port #: 1433

Audit Database Connection

The "Audit" database connection is made via JDBC connection.  You can maintain this connection via the Identity Management User Console.

1. Login as an administrative user 
2. Navigate the "Tasks" menu to "System"
3. Under the "JDBC Connection Management" you can choose to create, delete, view or modify the JDBC Connection.

If you select "Create" you are prompted to select a creation option.  In this instance you should select "Create a new object of the type Connection based on the JNDI Audit data source"

The connection definition will have the following attributes:

Connection Name
Connection Type
Description
JDBC Driver Class
Database Name
Host Name
Port #
User ID
Password
JDBC Select Method (Cursor)
Default Connection

For example:

Connection Name: Audit data source
Connection Type: audit
Description: Derrived from Audit data source
JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
Database Name: im
Host Name: mssql1.<domain>.com
Port # 1433
User ID: sa
Password: <password
JDBC Select Method (Cursor): Cursor
Default Connection: ticked

Connection objects for Audit Reports
You should then check that the Connection object is configured for the audit reports.  

For example;

1. Login as an administrative user 
2. Navigate the "Tasks" menu to "Roles and Tasks"
3. Click on "Admin Tasks" 
4. Click on either "Modify Admin Task".
5. Search for *audit*
6. Select "Audit Details Report"
7. Click on the "Search" tab
8. Adjacent to "Search Screen" click browse.  The "Audit Details Report Search Screen" is selected by default.
9. Click "edit"
10. The "Connection Object for the Report" should be set to the "Audit Data Source."
11. Click OK
12. Click Select
13. Click Submit.