Creating the JDBC Connection String for BI Publisher 10g and 11g

Contents

To create the JDBC connection string:

1. Login to BI Publisher as an administrative user.

   Note: Some steps vary depending on whether you are using BI Publisher 10g or 11g. The steps distinguish between 10g and 11g if they differ.

2. In BI Publisher 10g, click the Admin tab.

   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. If you are using BI Publisher 10g, skip this step.

      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.