Creating the JDBC Connection String for BI Publisher
- Log in to BI Publisher as an administrative user.
- In BI Publisher, click the Administration link.
- Under Data Sources, click the JDBC Connection link.
- Click Add Data Source or choose the data source name you want to use.
- In the General section:
- In the Data Source Name field, enter one of the following data source names:
- For Oracle, P6RPT.
- For Microsoft SQL Server, P6SSRPT.
- In the Driver Type field, select your version.
- In the Database Driver Class field, enter the JDBC driver class for your database.
- 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.
- In the Connection String field, enter your JDBC connection string for the P6 EPPM Database.
- In the Username field, enter your Reporting database name (for example, pxrptuser).
- In the Password field, enter your Reporting database user password.
- (For an Oracle database only) In the Pre Process Function field, enter the following:
Secpac.SET_BIP_USER(:xdo_user_name)
- Clear the Use Proxy Authentication option for this data source definition.
- Click Test Connection.
- Click Apply.
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