Creating the JDBC Connection String for BI Publisher 11g

Previous TopicNext TopicContents

  1. Login to BI Publisher as an administrative user.
  2. In BI Publisher 11g, 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 11g, 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

Determining the Catalog Type in BI Publisher 11g

Adding the JDBC Data Source to the BIConsumers Role

Assigning Permissions to the P6Reports Catalog Folder

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

Testing P6 Sample Reports



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Thursday, February 04, 2016

PDF Library