Download and install the DataDirect Greenplum ODBC driver on Windows
Download and install the DataDirect Greenplum ODBC driver on Windows
Download the DataDirect Greenplum ODBC driver version 7.1.6 from the Pivotal website and install the DataDirect Greenplum ODBC driver on the Secure Agent machine.
Install Python 2.5.4 32-bit.
Install the 5.18 Greenplum Clients software for Windows.
Install the 5.18 Greenplum loaders software for Windows.
Set the following environmental variables for the driver:
Set the GPHOME_LOADERS environment variable to the folder that contains the Greenplum loader libraries:
For example,
Set GPHOME_LOADERS = C:\Program Files (x86)\Greenplum\greenplum-loaders-5.18.0
Set the GPHOME_CLIENTS environment variable to the folder that contains the Greenplum clients libraries:
For example,
set GPHOME_CLIENTS=C:\Program Files (x86)\Greenplum\greenplum-clients-5.18.0\
Set the PYTHONPATH environment variable:
Set PYTHONPATH=%GPHOME_LOADERS%\bin\lib
Set the DDCPATH environment variable to the folder containing the DataDirect libraries.
Set the Path environment variable to the folder that contains the Greenplum clients, Greenplum loaders, Python and Greenplum ODBC Datadirect driver libraries: