Creating the JDBC Connection String for Oracle Analytics Server

To create the JDBC connection string:

  1. Log in to Oracle Analytics Server as an administrative user.
  2. In Oracle Analytics Server, 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 Oracle Analytics Server

Configuring an Oracle Analytics Server User in WebLogic

Security Model in Oracle Analytics Server

Disabling the Cache for Oracle Analytics Server

Creating a Reports Folder in Oracle Analytics Server

Adding Data Sources to Roles with the Fusion Middleware Security Model

Assigning Permissions to the Unifier Reports Folder


Last Published Monday, December 9, 2024