Quick Start: Progress DataDirect® for ODBC for Amazon RedshiftTM Wire Protocol 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:

Connecting to a Database

Testing the Connection

Tuning the Driver for Optimal Performance

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:

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 use DataDirect connection pooling

Enable Connection Pooling on the Pooling tab.

If your application is configured for high availability that replays queries after a failure

Controlled by Failover Mode on the Failover Tab. Although high availability that replays queries after a failure provides increased leve ls of protection, it can adversely affect performance because of increased ov erhead.

If your application requires encryption of data

Controlled by Encryption Method on the Security Tab. Data encryption may adversely affect performance because of the additional overhead (mainly CPU usage) required to encrypt and decrypt data.

© 2016. Progress Software Corporation. All rights reserved.

2/16, 7.1.6