ODBC drivers enable third party applications to connect via a common interface to the Tanzu Greenplum Database system. This document describes how to install DataDirect Connect XE for ODBC drivers for Tanzu Greenplum on either a Linux or Windows system. Unless specified otherwise, references to DataDirect Connect XE for ODBC refer to DataDirect Connect XE for ODBC and DataDirect Connect64 XE for ODBC.
The DataDirect ODBC Drivers for Tanzu Greenplum are available for download from VMware Tanzu Network.
Install KornShell (ksh) on your system if it is not available.
Note the appropriate serial number and license key (use the same number for both the serial number and license key during the installation):
| Driver | Serial Number / License Key |
|---|---|
| DataDirect Connect XE for ODBC 7.1 drivers (32-bit drivers) | 1076681728 |
| DataDirect Connect64 XE for ODBC 7.1 drivers (64-bit drivers) | 1076681984 |
Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum
DataDirect Connect64 XE for ODBC drivers for Greenplum support the following 64-bit client platforms:
AIX 64: 7.1, 6.1, 5.3 Fixpack 5 or higher
HP-UX IPF: 11i v3.0 (B.11.3X), 11i v2.0 (B.11.23)
Linux Itanium: Red Hat Enterprise Linux (RHEL) 7.x, 6.x, RHEL 5.x, RHEL 4.x
Linux x64: RHEL 7.x RHEL 6.x, RHEL 5.x, RHEL 4.x, SUSE Linux Enterprise Server (SLES) 15, SLES 12, SLES 11, SLES 10, Ubuntu 16.04
Solaris on SPARC: 11 and 11 Express (Solaris 5.11), 10 (Solaris 5.10), 9 (Solaris 5.9), 8 (Solaris 5.8)
Solaris x64: 11 (Solaris 5.11), 10 (Solaris 5.10)
Windows x64: Windows 8, Windows 10, Windows Server 20016
DataDirect Connect XE for ODBC drivers for Greenplum support the following 32-bit client platforms:
AIX 32: 7.1, 6.1, 5.3 Fixpack 5 or higher
HP-UX IPF: 11i v3.0 (B.11.3X), 11i v2.0 (B.11.23)
HP-UX PA-RISC: 11i v3 (B.11.3X), 11i v2 (B.11.23) 11i v1 (B.11.11), 11
Linux x86: Red Hat Enterprise Linux (RHEL) 6.x, RHEL 5.x, RHEL 4.x, SUSE Linux Enterprise Server (SLES) 11, SLES 10, Ubuntu 16.04, Ubuntu 14.04
Solaris on SPARC: 11 and 11 Express (Solaris 5.11), 10 (Solaris 5.10), 9 (Solaris 5.9), 8 (Solaris 5.8)
Windows: Windows 8, Windows 10, Windows Server 20016
Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum
To install ODBC drivers on your client:
Log into VMware Tanzu Network and download the correct ODBC driver for your operating system. The following Linux and UNIX files are available:
Follow the instructions in Verifying the Greenplum Database Software Download to verify the integrity of the Progress DataDirect ODBC Driver software.
Unpack the files. For example:
$ tar -zxvf PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX_LINUX_64.tar.Z
The files are extracted to the current directory.
Execute the installer:
$ ksh unixmi.ksh
Progress DataDirect Connect for ODBC Setup is preparing....
English has been set as the installation language.
Log file : /tmp/logfile.492.1
----------------------------------------------------------------------
Progress DataDirect Connect (R) and Connect XE for ODBC 7.1 SP5
for UNIX operating systems
----------------------------------------------------------------------
The following operating system has been detected:
LinuxX64
Is this the current operating system on your machine (Y/N) ?
Press Y to confirm your operating system. The installer displays the license agreement.
Enter YES to accept the End User License Agreement. The installer prompts you for registration information:
Enter YES to accept the above agreement : YES
Please enter the following information for proper registration.
In the Key field, enter either EVAL or the Key provided.
Name :
Enter the required registration information at each prompt:
| Prompt | Enter |
|---|---|
| Name: | Name to associate with the registration. |
| Company: | Your company name. |
| Serial Number: | - 1076681984 for 64-bit driver, or - 1076681728 for 32-bit driver. |
| Key: | - 1076681984 for 64-bit driver, or - 1076681728 for 32-bit driver. |
The installation program displays the registered driver information. For example:
You have chosen the Greenplum Wire Protocol driver.
Server Unlimited
Unlimited Connections
To change this information, enter C. Otherwise, press Enter to continue. :
Press Enter to continue with the installation. The installer prompts you for a temporary directory:
DataDirect Connect for ODBC Setup is preparing the installation.
Choose a temporary directory.
Enter the full path to the temporary install directory.[/tmp]:
Press Enter to accept the default /tmp directory or enter a custom directory to store temporary files. The installer extracts temporary files and prompts you for an installation directory:
Checking for available space...
There is enough space.
Extracting files...
Choose a destination directory.
Enter the full path to the install directory.[/opt/Progress/DataDirect/Connect64_for_ODBC_71]:
Press Enter to accept the default directory or enter a custom destination directory. The installer checks for available space and installs the software:
Checking for available space...
There is enough space.
Extracting files...
Creating license file......
DataDirect Connect for ODBC Setup successfully removed all of the temporary files.
Thank you for using Progress DataDirect products under OEM license to Greenplum Inc.
Would you like to install another product (Y/N) ? [Y]
Enter N to exit the installer.
Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum
After you install the driver software, perform these steps to configure the driver.
Change to the installation directory for your driver. For example:
$ cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/
Set the LD_LIBRARY_PATH, ODBCINI and ODBCINST environment variables with the command:
$ source odbc.sh
Open the odbc.ini file and create a new DSN entry. You can use the existing "Greenplum Wire Protocol" entry as a template.
$ vi $ODBCINI
You must edit the following entries to add values that match your system:
| Entry | Description |
|---|---|
| Database | Tanzu Greenplum database name. |
| HostName | Master host name. |
| PortNumber | Master host port number. |
| LogonID | Greenplum Database user. |
| Password | Password. |
Verify the driver version:
$ cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/bin
$ ./ddtestlib ddgplm27.so
Load of ddgplm27.so successful, qehandle is 0x15C9EC0
File version: 07.16.0359 (B0535, U0382)
Parent topic: Installing on Linux Systems
To test the DSN connection:
Execute the example utility to test the DSN connection, entering the Greenplum Wire Protocol data source name and the credentials of a Tanzu Greenplum user. For example:
$ cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/samples/example
$ ./example
./example DataDirect Technologies, Inc. ODBC Example Application.
Enter the data source name : Greenplum Wire Protocol
Enter the user name : gpadmin
Enter the password : gpadmin
Enter SQL statements (Press ENTER to QUIT)
SQL>
Enter the following select statement to confirm database connectivity:
Enter SQL statements (Press ENTER to QUIT)
SQL> select version();
version
PostgreSQL 8.3.23 (Greenplum Database 5.0.0 build commit:8c709516061cff5476c03d6e2da99aae42722ae1) on x86_64-pc-linux-gnu, compiled by GCC gcc (GCC) 6.2.0 compiled on Sep 1 2017 22:39:53
Enter SQL statements (Press ENTER to QUIT)
SQL>
Press the ENTER key to exit the example application.
Parent topic: Installing on Linux Systems
To install ODBC drivers on your client:
setup.exe to launch the install wizard.Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum
To verify your driver version:
Parent topic: Installing on Windows Systems
To configure and test a DSN connection to a Greenplum Database:
Open the ODBC Administrator.
Select the System DSN tab.
Select Add.
Select DataDirect 7.1 Greenplum Wire Protocol and click Finish.
Enter the details for your chosen Greenplum Database instance. For example:
Recommended: Set the Max Long Varchar size.
Select the Advanced tab.
In Max Long Varchar Size, enter 8192 then select Apply.
Select Test Connect.
Enter your user name and password, then select OK.
You should see the confirmation message Connection Established!
If your connection fails, check the following for accuracy:
Host Name
Port Number
Database Name
User Name
Password
Greenplum instance is active
Parent topic: Installing on Windows Systems
For more information on working with Data Direct, see documentation that is installed with the driver. By default, you can access the installed documentation by using a Web browser to open the file /opt/Progress/DataDirect/Connect64_for_ODBC_71/help/index.html.
Documentation is also available online at https://www.progress.com/documentation/datadirect-connectors. Titles include:
Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum
