18 BI Publisher Reports

Oracle Identity Management Business Intelligence (BI) Publisher Reports enables you to use Oracle BI Publisher as the reporting solution for Oracle Identity Management products including Oracle Adaptive Access Manager.

This chapter provides information installing Oracle Adaptive Access Manager BI Publisher Reports.

18.1 Prerequisites

To install the Oracle Adaptive Access Manager BI Publisher Reports you must have working versions of the following:

• BI Publisher 10.1.3.4.0 or higher. For information on the installation of BI Publisher, refer to the Oracle Business Intelligence Publisher Installation Guide.

• Adaptive Risk Manager 10.1.4.5.0 or higher.

18.2 Installation

This chapter provides instructions to install the Oracle Adaptive Access Manager BI Publisher Reports and contains the following sections:

• Unzip oaam_bipreports_oradb.zip

• Stop the BI Publisher Server

• Copy the Oracle Adaptive Access Manager Report Files

• Copy properties.xml to the Oracle BI Publisher Server's File System

• Start the BI Publisher Server

• Configure JDBC Data Source

• Configure AdminProperties Data Source

• Test the Reports

18.2.1 Unzip oaam_bipreports_oradb.zip

The oaam_bipreports_oradb.zip file contains the Oracle Adaptive Access Manager reports. Unzip it in the oaam_reports directory.

18.2.2 Stop the BI Publisher Server

Instructions to stop the BI Publisher server is given in the BI_Publisher_Readme.txt file located in the <BI Publisher Oracle Home> directory. If you had installed BI Publisher using the Basic Install, the syntax to stop the Oracle BI Publisher is as follows:

<Java 1.5 Home>/bin/java.exe -jar <BI Publisher Oracle Home>/oc4j_bi/j2ee/home/admin.jar ormi://<host>:<port>  oc4jadmin <oc4jadmin password> -shutdown for

For example,

/BIPOraHome/jdk/bin/java.exe -jar /BIPOraHome/oc4j_bi/j2ee/home/admin.jar ormi://idmbip:23791 oc4jadmin oc4jadmin -shutdown force

18.2.3 Copy the Oracle Adaptive Access Manager Report Files

Copy the entire folder, which contains the reports, to the <BI Publisher Oracle Home>/XMLP directory in the Oracle BI Publisher server's file system.

18.2.4 Copy properties.xml to the Oracle BI Publisher Server's File System

Copy the properties.xml file to any directory in Oracle BI Publisher server's file system.

18.2.5 Start the BI Publisher Server

Instructions to start the BI Publisher server is given in the BI_Publisher_Readme.txt file located in the <BI Publisher Oracle Home> directory. If you had installed BI Publisher using the Basic Install, the syntax to start the Oracle BI Publisher is as follows:

<BI Publisher Oracle Home>/oc4j_bi/bin/oc4j.cmd -start

Example:

/BIPOraHome/oc4j_bi/bin/oc4j.cmd -start

18.2.6 Configure JDBC Data Source

To configure the JDBC data source:

1. Login to the Oracle BI Publisher as an administrator.

   The URL is http://<ip address>:8080/xmlpserver/

2. Click the Admin tab.

3. In the Data Source section, click JDBC Connection.

4. Click Add Data Source to add a new JDBC type data source to access the Oracle Adaptive Access Manager database.

5. Fill in the Add Data Source form.

   Data Source Name: ARM

   Connection String: jdbc:oracle:thin:@<host>:<port>:<sid>

   User Name: <database username>

   Password: <database password>

   Database Driver Class: oracle.jdbc.driver.OracleDriver

   For example:

   Data Source Name: ARM

   Connection String: jdbc:oracle:thin:@oaam:1521:brsadb

   User Name: oaamdbuser

   Password: abcd1234

   Database Driver Class: oracle.jdbc.driver.OracleDriver

   Note:

   For the Oracle Adaptive Access Manager reports to work out-of-the-box, the JDBC data source must be named as "ARM". If you choose a different name, you will need to modify the data source property in all reports.

18.2.7 Configure AdminProperties Data Source

To configure the AdminProperties data source:

1. Click the Admin tab.

2. In the Data Source section, click File.

3. Click Add Data Source.

4. Fill in the Add Data Source form.

   Data source name must be "AdminProperties"

   Path must be the directory where we placed properties.xml

18.2.8 Test the Reports

To test the reports:

1. Login to Oracle BI Publisher as an administrator, and then click Shared Folders.

   You will see a new folder, "OAAM Reports," on the "Shared Folders" page.

2. Click "oracle" under "OAAM Reports."

3. Choose any report.

4. Choose any output type and click the View button.