Configuring JDBC Drivers

During cube deployment, when Essbase Studio is run in streaming mode, Essbase Studio Server uses JDBC drivers to query the external data source directly.

The JDBC drivers for Oracle, Oracle BI EE, IBM DB2, and Microsoft SQL Server are installed when you install Essbase Studio.

For MySQL, Netezza, and Teradata, you must obtain the JDBC driver from the manufacturer and install it, as described in the following sections.

Note:

Perform the tasks in this section for the applicable JDBC driver after you have installed and configured Essbase Studio.

MySQL

  To set up the MySQL JDBC driver:

  1. From the MySQL Web site, download the appropriate version of the file to this directory:

    EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server

    The name of the driver file you download will vary depending on the version downloaded.

  2. Rename the file mysql-connector-java.jar.

    Essbase Studio will not recognize the driver file until it is renamed.

Netezza

  To set up the Netezza JDBC driver:

  1. From the Netezza Web site, download the appropriate version of the file to this directory:

    EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server

    The name of the driver file you download will vary depending on the version downloaded.

  2. Rename the file nzjdbc3.jar.

    Essbase Studio will not recognize the driver file until it is renamed.

Teradata

  To set up the Teradata drivers:

  1. From the Teradata Web site, download the Teradata JDBC driver library files tdgssconfig.jar and terajdbc4.jar.

  2. Extract the files to the this directory:

    EPM_ORACLE_HOME/products/Essbase/EssbaseStudio/Server

    Note:

    Consult Teradata directly for any compatibility issues or questions.