Configuring Oracle BI Publisher Enterprise for Interactive Reporting

This chapter discusses:

Click to jump to parent topicImplementing Interactive Reporting

To implement JD Edwards EnterpriseOne interactive reporting with Oracle BI Publisher Enterprise, you need to configure JD Edwards EnterpriseOne Data Access Server (DAS), install Oracle BI Publisher Enterprise, and configure the JDBC Driver in Oracle BI Publisher Enterprise. The following steps provide details for implementing interactive reporting.

  1. Install and configure JD Edwards EnterpriseOne Data Access Server (DAS).

    See JD Edwards EnterpriseOne Tools Release 8.98 Server Manager Guide

  2. Install Oracle Business Intelligence Publisher Enterprise.

    See Oracle Business Intelligence Publisher Installation Guide 10.1.3.4

  3. Configure Oracle BI Publisher Enterprise.

Click to jump to parent topicConfiguring Oracle BI Publisher Enterprise

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicCopying the JDBC Driver to Oracle Business Intelligence Publisher Enterprise

To copy the JDBC Driver to Oracle BI Publisher:

  1. Locate the JD Edwards EnterpriseOne e1jdbc.jar file in the DAS instance installation directory: <Drive>:\JDEdwards\DAS\DAS\Instance1\classes.

  2. Copy the e1jdbc.jar file to the BI Publisher server classpath. A typical example would be: <Drive>:\OraHome_BI\oc4j_bi\j2ee\home\applib\

  3. Start the BI Publisher Server.

Click to jump to top of pageClick to jump to parent topicConfiguring the JDBC Driver in Oracle Business Intelligence Publisher Enterprise

To configure the JDBC Driver in Oracle BI Publisher:

  1. Sign in to Oracle BI Publisher Enterprise Console.

  2. Click the Admin tab.

  3. Under the Data Sources section, select JDBC Connection.

  4. Click Add Data Source.

  5. Enter the following values on the Add Data Source form:

    Field

    Value

    Data Source Name

    E1JDBC

    Driver Type

    Other

    Database Driver Class

    com.jdedwards.jdbc.driver.Driver

    Connection String

    jdbc:oracle:enterpriseone://<DAS machine name>:<port number>/<JD Edwards environment>;

    Example: jdbc:oracle:enterpriseone://ORACLE-JDE:7770/JPD812;

    Note. You can append information to the end of the connection string that defines the JD Edwards EnterpriseOne role that will be used when connecting to the database, for example: enterpriseone.role=*ALL. If the role is not defined in the connection string, the role that is defined as the Bootstrap Role on DAS will be used. On DAS, locate the Bootstrap Role as follows: Configuration, JDBJ Database Configuration, JDBJ Bootstrap Session.

    User Name

    Enter the JD Edwards EnterpriseOne user ID that you will connect with.

    Note. The user name is case-sensitive.

    Password

    Enter the password for the user ID.

    Note. The password is case-sensitive.

    Use Proxy Authentication

    Cleared

  6. Click Apply.

  7. The new JDBC data source should appear in the Data Sources list.

Note. Using proxy authentication assumes that the user IDs in Oracle BI Publisher and JD Edwards EnterpriseOne are the same, either by duplication or by using Lightweight Directory Access Protocol (LDAP).

The JD Edwards EnterpriseOne Interoperability Guide provides additional information about the JDBC Driver.

See Using the Java Database Connectivity Driver.

Click to jump to top of pageClick to jump to parent topicTesting the JDBC Driver Connection

After configuring the JDBC Driver, it is recommended that you test the data source to verify that it is able to communicate and authenticate with the DAS server. Testing the data source requires that both the Enterprise Server/Security Server services and the DAS services are up and running. Additionally, ensure that Oracle BI Publisher is up and running.

To test the JDBC Driver connection:

  1. Sign in to Oracle BI Publisher Enterprise Console using an administrative account.

  2. Click the Admin tab.

  3. Under the Data Sources section, select JDBC Connection.

  4. Select the data source that you want to test.

  5. Click the Test Connection button to initiate the test.

  6. If the data source is able to communicate and authenticate with the DAS server, the following message appears: “Connection established successfully.”