Creating the JDBC Connection String for BI Publisher/Oracle Analytics Publisher

To create the JDBC connection string

  1. Log in to BI Publisher/Oracle Analytics Publisher as an administrative user.
  2. In BI Publisher/Oracle Analytics Publisher, 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 the alphanumeric name of the Unifier data source.
    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 the Connection String field, enter your JDBC connection string for the Unifier Database.
    5. Ensure the Use System User option is not selected.
    6. In the Username field, enter your Unifier Database Schema User (for example, Unifier).
    7. In the Password field, enter your Unifier Database Schema User password.
    8. Ensure the Pre Process Function and Post Process Function fields are left blank.
    9. Clear the Use Proxy Authentication option for this data source definition.
    10. Click Test Connection.
  6. Click Apply.

Related Topics

Configuring Enterprise Reporting with BI Publisher/Oracle Analytics Publisher

Configuring a BI Publisher/Oracle Analytics Publisher User in WebLogic

Security Model in BI Publisher/Oracle Analytics Publisher

Disabling the Cache for BI Publisher/Oracle Analytics Publisher

Creating a Reports Folder in BI Publisher/Oracle Analytics Publisher

Adding Data Sources to Roles with the Fusion Middleware Security Model

Assigning Permissions to the Unifier Reports Folder


Last Published Monday, January 8, 2024