Oracle Account. Manage your account. DataDirect JDBC Driver Downloads. You must accept the OTN License Agreement to download this software. Panel Progress Index. To DataDirect Connect for ODBC. Information for the 7.1.6 version of the Apache Hive Wire Protocol and Oracle Wire Protocol drivers.

Datadirect Drivers
Add Odbc Data Source Drivers
Merant Odbc Driver

An OracleAS Portal Technical Note
July 2004

Introduction

The OmniPortlet SQL data source is pre-configured to access Oracle databases using the Oracle JDBC drivers, and ODBC data sources using Sun Microsystem's JDBC-ODBC driver. OracleAS allows developers to access other relational databases using DataDirect JDBC drivers. The OracleAS Certification with DataDirect JDBC document contains the list of supported databases. Currently, OmniPortlet supports DataDirect JDBC driver 3.2 (listed under Version 9.0.4).

The DataDirect drivers and documentation are available on the Oracle Technology Network . Make sure you download the version of drivers supported in your J2EE container. See OracleAS Certification with DataDirect JDBC for more details.

This document describes how to configure OmniPortlet to leverage these drivers, and includes the following three sections:

Installing DataDirect drivers: explains how to install the driver into your environment.
Configuring OmniPortlet: explains to Portal administrators how they can add the DataDirect drivers to the OmniPortlet.
Using the DataDirect Driver in OmniPortlet: explains how page designers can use the different drivers.

Installing DataDirect Drivers

Configuring OmniPortlet

More Information

OC4J Services Guide Page 5.29 Installing DataDirect JDBC Drivers

Oracle Corporation
World Headquarters
500 Oracle Parkway
Redwood Shores, CA 94065, USA
http://www.oracle.com/

Worldwide Inquiries:
1-800-ORACLE1
Fax 650.506.7200

Creating Configuration Files for Non-DataDirect Drivers

You create a configuration file (ESSBASEPATH/bin/esssql.cfg) when you want to connect to a database using non-DataDirect drivers, or when you want to change the default settings for the DataDirect ODBC drivers that are distributed with Essbase.

Keywords and Values Used Within Configuration Files

The configuration file must contain the driver file names (DriverName), and an optional description (Description), the value for which must be enclosed in double quotation marks (the default value for Description is ' '); it may contain additional keywords, the values for which are 0 or 1, as shown in Table 1.

Keywords and values must be separated by at least one space, and the set of keywords and values for each driver must be enclosed within brackets ( [ ] ).

Different drivers may require additional values. See the driver documentation for specific information.

In the following example, the first entry for Oracle changes the default settings for the DataDirect drivers distributed with Essbase. The second entry is for Microsoft SQL Server, a non-DataDirect driver.

Defaults apply to values that are not specified. The defaults applied within configuration files differ from the Essbase default values that apply if no esssql.cfg file exists.

Table 1. Configuration File Keywords and Values for Non-DataDirect Drivers

Datadirect Drivers

Keyword	Value = 0	Value = 1
UserId	User ID not required (default)	User ID required
Password	Password not required (default)	Password required
Database	Database name not required (default)	Database name required
Server	Server name not required (default)	Server name required
Application	Application name not required (default)	Application name required
Dictionary	Dictionary name not required (default)	Dictionary name required
Files	File name not required (default)	File name required
SingleConnection	Driver thread-safe—Multiple active connections permitted Note: Not recommended for non-Data Direct drivers, or for DataDirect drivers except for those used to connect to Oracle 11g databases, for which it is the default; may cause instability.	Driver not thread-safe—One active connection permitted The default and the recommendation for all DataDirect drivers except for those used to connect to Oracle 11g databases.
UpperCaseConnection	Driver case-sensitive—Connection information not converted (default)	Driver not case-sensitive—Connection information converted to uppercase
IsQEDriver	Driver a non-DataDirect driver (default)	Driver a DataDirect driver Note: You can specify configuration information for DataDirect drivers. For example, you can specify information for a version of a DataDirect driver that Essbase does not support.

Note:

The DataDirect ODBC drivers that connect to Oracle 11g databases are configured to enable multi-threaded connections and to disable uppercase conversion. To enable multi-threaded connections for the SQL Server Wire Protocol driver, see Performing Multiple SQL Data Loads in Parallel to Aggregate Storage Databases.

To find driver names on Windows:

Add Odbc Data Source Drivers

Using a method from step 1 in Configuring Data Sources on Windows, start ODBC Administrator:
The ODBC Data Source Administrator dialog box opens.
Configured data sources are listed in the User Data Sources box. Drivers that are not properly configured but are listed in the User Data Sources box can be ignored.
Select the Drivers tab.
Obtain the file name of the preferred driver by scrolling to the right.
For example, the file name for the Microsoft Access Driver is ODBCJT32.DLL.

To find driver names on UNIX, view the .odbc.ini file.

Merant Odbc Driver

See Configuring Data Sources on UNIX.

Datadirect Oracle Odbc Driver Download