Quick Start: Progress DataDirect® for ODBC for Oracle Service CloudTM Driver on UNIX and Linux (32-bit and 64-bit)

The following basic information enables you to connect with and test your driver immediately after installation. For installation instructions, see the Progress DataDirect for ODBC Drivers Installation Guide. This Quick Start covers the following topics:

Driver Requirements

Environment Setup

Test Loading the Driver

Connecting to a Database

Testing the Connection

Tuning the Drivers for Optimal Performance

ODBCHOME in the following sections refers to your installation directory path determined at installation.

Driver Requirements

The driver requires a Java Virtual Machine (JVM): J2SE 5 or higher. Before you configure a data source for the driver, you must set the library path environment variable for your operating system to the directory containing your JVM's libjvm.so [sl | a] file, and that directory's parent directory. The library path environment variable is:

        LD_LIBRARY_PATH on Linux, Oracle Solaris, and HP-UX Itanium


        LIBPATH on AIX

Environment Setup

1       Check your permissions: Log in as a user with full r/w/x permissions recursively on the entire Progress DataDirect for ODBC Drivers installation directory.

2       Determine which shell you are running: From the login shell, execute the echo $SHELL command.

3       Run the DataDirect setup script to set variables: Two scripts, odbc.csh and odbc.sh, are installed in the installation directory. For Korn, Bourne, and equivalent shells, execute odbc.sh. For a C shell, execute odbc.csh. After running the setup script, execute the env command to verify that the ODBCHOME/lib directory has been added to your shared library path.

4       Set ODBCINI variable: Progress DataDirect for ODBC Drivers install a default odbc.ini file, where your data sources reside, in the installation directory. You must set the ODBCINI environment variable to point to the path of the odbc.ini file. For example:

$ ODBCINI= ODBCHOME/odbc.ini; export ODBCINI

Test Loading the Driver

The ivtestlib (32-bit drivers) and ddtestlib (64-bit drivers) test loading tools are provided to verify that the driver can be loaded into memory; they are located in the ODBCHOME/bin directory. For example, to load the 32-bit driver, you would enter:

$ ivtestlib ODBCHOME/lib/ivrnownn.zz

where nn represents the driver level number and zz represents the extension.

If the load is successful, the test loading tool returns a success message along with the version string of the driver. If the driver cannot be loaded, test loading tool returns an error message explaining why.

Connecting to a Database

The following procedure is applicable to all UNIX/Linux systems.

Defining a Data Source in the odbc.ini

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.

The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, nn represents the driver level number, and zz represents the extension. The values for the options are samples and are not necessarily the ones you would use.

To configure a connection, you might enter:

[Oracle Service Cloud]


JVMClasspath= {.:/home/user1/install_dir/java/lib/rightnow.jar}

Connection Options

HostName: Either the name or the IP address of the server to which you want to connect.

InterfaceName: The name of the Service Cloud interface to which you want to connect.

JVMClasspath: The CLASSPATH for the Java Virtual Machine (JVM) file used by the driver.

Testing the Connection

The Progress DataDirect for ODBC for Oracle Service Cloud driver installation includes a program named example that can be used to connect to a data source and execute SQL. The application is located in the ODBCHOME/example directory. To run the program, type example and follow the prompts to enter your data source name, user name, and password. If successful, a SQL> prompt appears and you can type in SQL Statements such as

SELECT * FROM accounts

If example is unable to connect, the appropriate error message appears.

Tuning the Driver for Optimal Performance

The drivers have connection options that directly affect performance. To tune these drivers for performance, set the following connection options:


If your application does not use threads

Set ApplicationUsingThreads to 0 (Disabled).

If you want to compress data transferred between the driver and the Web service

Set WSCompressData to 1 (Compress).

If you want to use DataDirect connection pooling

Set ConnectionPooling to 1 (Enabled).

If your application does not retrieve result sets that exceed the site configured maximum number of rows

Set EnablePagingWithOrderByID to 0 (Disabled).

If you know the typical fetch size for your application

Set FetchSize to suit your environment. Smaller fetch sizes can improve the initial response time of the query. Larger fetch sizes improve overall fetch times at the cost of additional memory.

If you know how many rows of data the driver attempts to fetch for each ODBC call for a Web service

Set WSFetchSize to suit your environment. Setting to 0 fetches the site configured maximum number of rows for optimum throughput. To reduce response time, you can set to a positive integer that is lower than the site configured maximum.

© 2016. Progress Software Corporation. All rights reserved.

2/16, 7.1.6