Configuring the JDBC Connection
To configure the JDBC connection:
Note: If you connected P6 and BI Publisher, you may have already completed these steps.
- Login to BI Publisher as an administrative user.
- In BI Publisher 11g, click the Administration link.
- Under Data Sources, click the JDBC Connection link.
- Click Add Data Source.
- In the General section:
- In the Data Source Name field, enter P6RPT.
- 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 11g, select the Use System User option if you are connected to the OBI Server and want to use this option.
- In the Connection String field, enter your JDBC connection string for the P6 EPPM Database.
- In the Username field, enter your odsuser name.
- In the Password field, enter your odsuser password.
- 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.
- Click Apply.