Prerequisites

1. 1Install the Greenplum loaders package on the Secure Agent machine. The loaders package contains the gpload utility. You can download the Greenplum loaders package from the Pivotal Greenplum website.
2. 2Configure the DataDirect Greenplum ODBC and JDBC drivers on the Secure Agent machine.
3. 3Configure the authentication prerequisites to connect to a Greenplum database. You can configure Database or Kerberos authentication. Keep the following authentication details handy based on the authentication type that you want to use:
• - To configure Database authentication, you need the user name, password, host name, port, database name from your Greenplum account.
• - To configure Kerberos authentication, you need the service principal name, host name, port, and database name from your Greenplum account.

Configure JDBC and ODBC drivers

Configure the DataDirect Greenplum JDBC Driver on Linux

1. 1Download the DataDirect Greenplum JDBC driver version 6.x from the Pivotal Greenplum website.
2. 2Copy the Greenplum JDBC driver to the following directory on the Secure Agent machine: <Secure Agent installation directory>/apps/Data_Integration_Server/ext/deploy_to_main/bin/rdtm-extra/Greenplum
Note: You must create the deploy_to_main/bin/rdtm-extra directory manually.
3. 3Restart the Secure Agent.

Configure the DataDirect Greenplum JDBC driver on Windows

1. 1Download the DataDirect Greenplum JDBC driver version 6.x from the Pivotal Greenplum website.
2. 2Copy the Greenplum JDBC driver to the following directory on the Secure Agent machine:
<Secure Agent installation directory>\apps\Data_Integration_Server\ext\deploy_to_main\bin\rdtm-extra\Greenplum
You must create the deploy_to_main\bin\rdtm-extra\Greenplum directory manually.
3. 3Restart the Secure Agent.

Configure the DataDirect Greenplum ODBC driver on Linux

1. 1Download 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.
2. 2Add the following driver entries to the odbcinst.ini file in the following directory: <Secure Agent installation directory>/odbcinst.ini
Use the following syntax:
[DataDirect 7.1 Greenplum Wire Protocol]
Driver=<ODBC driver path>/lib/ddgplm27.so
Setup=<ODBC driver path>/lib/ddgplm27.so
DriverODBCVer=<ODBC Driver version>
HelpRootDirectory=<ODBC Driver path>/help
GSSClient=libgssapi_krb5.so.2

For example:
[DataDirect 7.1 Greenplum Wire Protocol]
Driver=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddgplm27.so
Setup=/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib/ddgplm27.so
APILevel=0
ConnectFunctions=YYY
DriverODBCVer=3.52
FileUsage=0
HelpRootDirectory=/opt/Progress/DataDirect/Connect64_for_ODBC_71/help
SQLLevel=0
GSSClient=libgssapi_krb5.so.2
3. 3Set the GPHOME_LOADERS, PATH, and LD_LIBRARY_PATH environmental variables for the driver.
Perform the following tasks:
1. aSet the GPHOME_LOADERS environmental variable to the directory that contains the Greenplum loader libraries. Using a C shell and run the following command:
setenv GPHOME_LOADERS /export/qa_adp/thirdparty/greenplum/rhel.64/loaders

2. bSet the PATH environmental variable to the directory that contains the Greenplum loader libraries. Using a C shell and run the following command:

setenv PATH ${GPHOME_LOADERS}/bin:${PATH}

3. cSet the LD_LIBRARY_PATH environmental variable to include the following directories that contain the Greenplum drivers and the DataDirect Greenplum ODBC libraries. Using a C shell and run the following command:

setenv LD_LIBRARY_PATH .:${GPHOME_LOADERS}/lib:/export/qa_adp/thirdparty/greenplum/rhel.64/loaders/ext/python/lib
setenv LD_LIBRARY_PATH /opt/Progress/DataDirect/Connect64_for_ODBC_71/lib:$LD_LIBRARY_PATH
4. 4Restart the Secure Agent after you update the environment variables.

Configure the DataDirect Greenplum ODBC driver on Windows

1. 1Download 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.
2. 2Install Python 2.5.4 32-bit.
3. 3Install the 5.18 Greenplum Clients software for Windows.
4. 4Install the 5.18 Greenplum loaders software for Windows.
5. 5Set 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.
For example, DDCPATH=C:\Program Files\Progress\DataDirect\Connect64_for_ODBC_71\drivers;C:\Program Files\Progress\DataDirect\Connect64_for_ODBC_71\jre\bin;C:\Program Files\Progress\DataDirect\Connect64_for_ODBC_71\jre\bin\server
• - Set the Path environment variable to the folder that contains the Greenplum clients, Greenplum loaders, Python and Greenplum ODBC Datadirect driver libraries:
For example, Path=C:\Python25;C:\Program Files (x86)\Greenplum\greenplum-loaders-5.18.0\lib;C:\Program Files (x86)\Greenplum\greenplum-loaders-5.18.0\bin;C:\Program Files (x86)\Greenplum\greenplum-clients-5.18.0\lib;C:\Program Files (x86)\Greenplum\greenplum-clients-5.18.0\bin;%DDCPATH%

Configuring the Kerberos authentication

1. 1To configure the Java Authentication and Authorization Service configuration file (JAAS), perform the following tasks:
1. aCreate a JAAS configuration file on the Secure Agent machine.
2. bAdd the following entries to the JAAS configuration file:
JDBC_DRIVER_01 {
com.sun.security.auth.module.Krb5LoginModule required useTicketCache=true;
};

2. 2To configure the krb5.conf file, perform the following tasks:
1. aCreate a krb5.conf file on the Secure Agent machine.
2. bAdd the details of the Key Distribution Center (KDC) and admin server to the krb5.conf file in the following format:
[libdefaults]
default_realm = <Realm name>
forwardable = true
ticket_lifetime = 24h

[realms]
<REALM NAME> = {
kdc = <Location where KDC is installed>
admin_server = <Location where KDC is installed>
}
[domain_realm]
<domain name or host name> = <Domain name or host name of Kerberos>
<domain name or host name> = <Domain name or host name of Kerberos>

3. 3Set the environment variables on the Secure Agent machine.
4. 4Restart the Secure Agent.
5. 5To generate the credential cache file on the Secure Agent machine and use Kerberos authentication to connect to Greenplum, perform the following tasks:
1. aFrom the command line on the Secure Agent machine, run the following command and specify the Greenplum user name and realm name:
Kinit <user name>@<realm_name>
2. bWhen prompted, enter the password for the Kerberos principal user.

Setting environment variables

• •setenv KRB5CCNAME <Absolute path and file name of the credentials cache file>
• •setenv KRB5_CONFIG <Absolute path of the Kerberos configuration file>\krb5.conf
• •setenv JAASCONFIG <Absolute path of the JAAS config file>\<File name>.conf