Quick Start: Progress DataDirect® for ODBC for Oracle Service CloudTM Driver on Windows (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

Connecting to a Database

Testing the Connection

Tuning the Driver for Optimal Performance

Driver Requirements

The driver requires a Java Virtual Machine (JVM): J2SE 5 or higher.

Connecting to a Database

1       Start the ODBC Administrator to display a list of user data sources.

2       On the User DSN tab, click Add to display a list of installed drivers. Select the appropriate driver from the list and click Finish to display the driver Setup dialog box.

3       On the General tab, provide the required information; then, click Apply. The General tab has the following required options:

4       On the SQL Engine tab, provide the required information; then, click Apply. The SQL Engine tab has the following required connection option:

5       Click OK or Cancel. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connection to the data source using a connection string with alternate values.

Optionally, you can further configure your data source by providing values for the connection options listed in "Connection Option Descriptions" in the Progress DataDirect for ODBC for Oracle Service Cloud Driver User's Guide and Reference.

Testing the Connection

1       At the bottom of the Driver Setup dialog box, click Test Connect to attempt to connect to the data source using the connection properties that you specified. A logon dialog box appears. Note that the information you enter in the logon dialog box during a test connect is not saved. Click OK.

If the driver can connect, it releases the connection and displays a connection established message. If the driver cannot connect because of an improper environment or incorrect connection value, it displays an appropriate error message. Click OK.

2       Click OK or Cancel at the bottom of the Driver Setup dialog box. If you click OK, the values you have specified become the defaults when you connect to the data source.

Tuning the Driver for Optimal Performance

The driver has connection options that directly affect performance. To tune the driver for optimal performance, set the following options:

If your application does not use threads

Disable Application Using Threads on the Advanced tab.

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

Enable Compress Data on the Web Service tab.

If you want to use DataDirect connection pooling

Enable Connection Pooling on the Pooling tab.

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

Disable Enable Paging With Order By ID on the Advanced tab.

If you know the typical fetch size for your application

 

Set Fetch Size on the Advanced tab 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 on the Web Service tab to 0 to 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