DataDirect ODBC Drivers for Tanzu Greenplum

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.

• Prerequisites

• Supported Client Platforms

• Installing on Linux Systems

• Installing on Windows Systems

• DataDirect Driver Documentation

Prerequisites

• 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

Supported Client Platforms

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

Installing on Linux Systems

To install ODBC drivers on your client:

1. Log into VMware Tanzu Network and download the correct ODBC driver for your operating system. The following Linux and UNIX files are available:

   • PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX_LINUX_64.tar.Z
   • PROGRESS_DATADIRECT_CONNECT_ODBC_7.1.6.HOTFIX_LINUX_32.tar.Z
   • PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX_AIX_64.tar.Z
   • PROGRESS_DATADIRECT_CONNECT_ODBC_7.1.6.HOTFIX_AIX_32.tar.Z

2. Follow the instructions in Verifying the Greenplum Database Software Download to verify the integrity of the Progress DataDirect ODBC Driver software.

3. 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.

4. 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) ?

5. Press Y to confirm your operating system. The installer displays the license agreement.

6. 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          :

7. 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. :

8. 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]:

9. 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]:

10. 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]
```

1. Enter N to exit the installer.

• Configuring the Driver on Linux

• Testing the Driver Connection on Linux

Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum

Configuring the Driver on Linux

After you install the driver software, perform these steps to configure the driver.

1. Change to the installation directory for your driver. For example:

   $ cd /opt/Progress/DataDirect/Connect64_for_ODBC_71/

2. Set the LD_LIBRARY_PATH, ODBCINI and ODBCINST environment variables with the command:

   $ source odbc.sh

3. 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.

4. 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

Testing the Driver Connection on Linux

To test the DSN connection:

1. 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>

2. 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>
```

1. Press the ENTER key to exit the example application.

Parent topic: Installing on Linux Systems

Installing on Windows Systems

To install ODBC drivers on your client:

1. Log into VMware Tanzu Network and download the correct ODBC driver for your operating system (32-bit or 64-bit). The following Windows files are available:
   • PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX_WIN_64.zip
   • PROGRESS_DATADIRECT_CONNECT_ODBC_7.1.6.HOTFIX_WIN_32.zip
2. Follow the instructions in Verifying the Greenplum Database Software Download to verify the integrity of the Progress DataDirect ODBC Driver software.
3. Uncompress the installer.
4. Double-click setup.exe to launch the install wizard.
5. If necessary, permit the InstallAnywhere installer to run.
6. Click Next at the Introduction screen to begin the installation.
7. Accept the End User License Agreement and click Next.
8. Select OEM or Licensed Installation as the installation type and click Next.
9. Enter your licensing information: Division name, Company Name, and serial number/license key found in Prerequisites.
10. Select Add. You should see this driver in the License dialog box: ODBC Greenplum Wire Protocol Third Party All Platform Server Unlimited Cores
11. Select Next.
12. Choose options appropriate for your installation. For example, select to replace the existing drivers and/or to create the default data sources. Click Next.
13. Accept the default installation directory or choose a custom directory. Click Next.
14. Verify the selected installation options, and click Install to begin installation. The installation process may take several minutes.
15. Select Done to complete installing the driver package.

• Verifying the Version on Windows

• Configuring and Testing the Driver on Windows

Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum

Verifying the Version on Windows

To verify your driver version:

1. Select Start > All Programs > DataDirect > ODBC Administrator to open the Windows ODBC Administrator.
2. Click the Drivers tab, and scroll down to DataDirect <version> Greenplum Wire Protocol. Ensure that you see the expected version number.

Parent topic: Installing on Windows Systems

Configuring and Testing the Driver on Windows

To configure and test a DSN connection to a Greenplum Database:

1. Open the ODBC Administrator.

2. Select the System DSN tab.

3. Select Add.

4. Select DataDirect 7.1 Greenplum Wire Protocol and click Finish.

5. 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.

6. Select Test Connect.

7. Enter your user name and password, then select OK.

8. 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

DataDirect Driver Documentation

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:

• User’s Guide
• Reference
• Troubleshooting Guide
• Installation Help
• Windows Readme
• UNIX/Linux Readme

Parent topic: DataDirect ODBC Drivers for Tanzu Greenplum