How to check the report connection settings for Identity Manager

Document ID : KB000123979
Last Modified Date : 27/12/2018
Show Technical Document Details
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 Identimity Manager, "Reporting" is made available via JasperServer.  To facilitate JasperServer reporting a snapshot database is used. 
Question:
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
Answer:
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.unipraxis.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://192.168.1.94:8080/jaspersevrer-pro
User ID: imuser
Password: p@ssworD123



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.unipraxis.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 youe 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.unipraxis.com
Port # 1433
User ID: sa
Password: p@ssworD123
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.