Configuring the JDBC Connection

Previous TopicNext TopicContents

To configure the JDBC connection:

Note: If you connected P6 and BI Publisher, you may have already completed these steps.

  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.
  5. In the General section:
    1. In the Data Source Name field, enter P6RPT.
    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 OBI Server and want to use this option.
    5. In the Connection String field, enter your JDBC connection string for the P6 EPPM Database.
    6. In the Username field, enter your odsuser name.
    7. In the Password field, enter your odsuser password.
    8. Do one of the following:
      • Choose the option for Use Proxy Authentication if you are using the database security model.
      • Choose to specify the Pre Process Function (Secpac.SET_BIP_USER(:xdo_user_name)) if you are using the SECPAC security model.

      See User-Level Security and User Name Restrictions for more information.

  6. Click Apply.

Related Topics

BI Publisher Administration Tasks

Overview of BI Publisher

User-Level Security and User Name Restrictions

Installing Oracle BI Publisher

About Configuring P6 Database Connection Settings for BI Publisher

Copying the P6REPORTS Folder for BI Publisher 11g

Configuring BI Publisher Security

BI Publisher Database Authentication Setup

Setting Up LDAP with BI Publisher



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

Last Published Friday, January 31, 2014