Creating the JDBC Connection String for BI Publisher

The BI Publisher Fusion Middleware security model requires you to connect your P6 EPPM database to BI Publisher using a JDBC connection string.

To create the JDBC connection string:

  1. Log in to BI Publisher as an administrative user.
  2. In BI Publisher, click the Administration link.
  3. Under Data Sources, click the JDBC Connection link.
  4. Click Add Data Source or choose the data source name you want to use.
  5. In the General section:
    1. In the Data Source Name field, enter one of the following data source names:
      • For Oracle, P6RPT.
      • For Microsoft SQL Server, P6SSRPT.
    2. In the Driver Type field, select your version.
    3. In the Database Driver Class field, enter the JDBC driver class for your database.
    4. In BI Publisher, select the Use System User option if you are connected to the Oracle BI Server and want to use this option.

      Note: See the BI Publisher documentation for information on the Use System User option.

    5. In the Connection String field, enter your JDBC connection string for the P6 EPPM Database.
    6. In the Username field, enter your Reporting database name (for example, pxrptuser).
    7. In the Password field, enter your Reporting database user password.
    8. (For an Oracle database only) In the Pre Process Function field, enter the following:

      Secpac.SET_BIP_USER(:xdo_user_name)

    9. Clear the Use Proxy Authentication option for this data source definition.
    10. Click Test Connection.
  6. Click Apply.

Related Topics

Using the Oracle Fusion Middleware Security Model

Adding P6 Sample Reports

Adding the JDBC Data Source to the BIConsumers Role

Assigning Permissions to the P6Reports Catalog Folder

Creating a Reporting Admin User in BI Publisher for P6 EPPM for Fusion Middleware Security

Creating Reporting Users in BI Publisher for P6 EPPM for Fusion Middleware Security

Setting the Data Source for Each Sample Report for BI Publisher


Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Tuesday, December 8, 2020