1. Using Oracle Essbase
  2. Work with Connections and Datasources
  3. More Connection Examples for Generic JDBC Drivers

More Connection Examples for Generic JDBC Drivers

These examples illustrate using Essbase to connect to non-Oracle JDBC sources of data, using drivers you uploaded to the Essbase Server.

The following examples are for non-Oracle sources. To create an Oracle Database connection using a generic JDBC driver, see Create Connections and Datasources for Generic JDBC Drivers.

JDBC Connection Example for DB2

In the Create Connection screen,


Create Connection dialog for JDBC driver connection. Name: DB2conn, URL: jdbc:db2://myhostname02.example.com:50000/TBC, User: myDB2User, Password: (obscured), Driver: com.ibm.db2.jcc.DB2Driver, Description: DB2 connection using JDBC drivers

  1. Provide a name for the JDBC connection. For example, DB2conn.

  2. In the URL field, provide the JDBC connection string. For example, jdbc:db2://myhostname02.example.com:50000/TBC. Obtain the JDBC connection string from the JDBC provider.

  3. For User and Password fields, enter the credentials for a user who is authorized to access the database.

  4. In the Driver field, provide the fully qualified class name of the JDBC driver. For example, com.ibm.db2.jcc.DB2Driver.

JDBC Connection Example for MySQL

In the Create Connection screen,


Create Connection dialog for JDBC driver connection. Name: MySQLconn, URL: jdbc:mysql://myhostname03.example.com:3306/tbc, User: MySQLUsr, Password: (obscured), Driver: com.mysql.jdbc.Driver, Description: MySQL connection using JDBC driver

  1. Provide a name for the JDBC connection. For example, MySQLconn.

  2. In the URL field, provide the JDBC connection string. For example, jdbc:mysql://myhostname03.example.com:3306/tbc. Obtain the JDBC connection string from the JDBC provider.

  3. For User and Password fields, enter the credentials for a user who is authorized to access the database.

  4. In the Driver field, provide the fully qualified class name of the JDBC driver. For example, com.mysql.jdbc.Driver.

JDBC Connection Example for SQL Server

In the Create Connection screen,


Create Connection dialog for JDBC driver connection. Name: MSSQLConn, URL: jdbc:sqlserver://myhostname04.example.com:1433, User: MSSQLUsr, Password: (obscured), Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver, Description: SQL Server connection using JDBC driver

  1. Provide a name for the JDBC connection. For example, MSSQLConn.

  2. In the URL field, provide the JDBC connection string. For example, jdbc:sqlserver://myhostname04.example.com:1433. Obtain the JDBC connection string from the JDBC provider.

  3. For User and Password fields, enter the credentials for a user who is authorized to access the database.

  4. In the Driver field, provide the fully qualified class name of the JDBC driver. For example, com.microsoft.sqlserver.jdbc.SQLServerDriver.

JDBC Connection Example for Teradata

In the Create Connection screen,


Create Connection dialog for JDBC driver connection. Name: TeraDconn, URL: jdbc:teradata://host.example.com/DBS_PORT=1025, User: TeraUsr, Password: (obscured), Driver: com.teradata.jdbc.TeraDriver, Description: Teradata connection using JDBC driver

  1. Provide a name for the JDBC connection. For example, TeraDconn.

  2. In the URL field, provide the JDBC connection string. For example, jdbc:teradata://host.example.com/DBS_PORT=1025. Obtain the JDBC connection string from the JDBC provider.

  3. For User and Password fields, enter the credentials for a user who is authorized to access the database.

  4. In the Driver field, provide the fully qualified class name of the JDBC driver. For example, com.teradata.jdbc.TeraDriver.