Creating the JDBC Connection String for BI Publisher

The BI Publisher 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. Login to BI Publisher as an administrative user.
2. 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. 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 BI Publisher Security Model

Adding P6 Sample Reports

Creating a P6Reports Role

Assigning Permissions to the P6Reports Folder

Creating a Reporting Admin User in BI Publisher for P6 EPPM

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

Legal Notices | Your Privacy Rights
Copyright © 1999, 2021

Last Published Tuesday, December 7, 2021