Prerequisites

You can use the Pivotal Greenplum database with Qlik Replicate on either a Windows or Linux computer. The following topic describe the prerequisites for working with Qlik Replicate and a Pivotal Greenplum database.

Replicate on Windows: Required software

You must install the following software on the computer where the Qlik Replicate Server is installed:

• greenplum-db-clients-6.7.1
• PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX

Replicate on Linux: Required software

On the Linux computer, perform the following steps:

1. Open port 8080.

2. Install the following Greenplum software:

   • greenplum-db-clients-6.7.1

   • PROGRESS_DATADIRECT_CONNECT64_ODBC_7.1.6.HOTFIX

3. Update the odbcinst.ini file located in the etc directory, as in the following 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

4. Update the /opt/attunity/replicate/bin/site_arep_login.sh file so that the Pivotal Greenplum environment scripts are executed when logging into the account where Qlik Replicate is run.

   Example:  

   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/Progress/DataDirect/Connect64_for_ODBC_71/lib export GPHOME_CLIENTS=/usr/local/greenplum-db-clients

5. Make sure you create a symbolic link from greenplum-db-clients to the Greenplum ODBC client.

   Example:  

   greenplum-db-clients -> /usr/local/greenplum-db-clients-6.7.1 (make sure that the path starts with /usr/local).

    

6. Restart Replicate Server.

Configuration and environment

Qlik Replicate relies on the proper functioning of the Pivotal Greenplum's gpfdist program on the computer with Qlik Replicate (the local computer). gpfdist is a simple Web server program with special performance customization for concurrent access from Pivotal Greenplum database segment nodes to data files on the local computer.

Because gpfdist is a Web server program and because it needs to be accessible from the Pivotal Greenplum database segment nodes, there are some networking configuration settings that must be in place to allow for this access. This is documented in the EMC Pivotal Greenplum database Administration Guide.

For further information, see Testing your Pivotal Greenplum Configuration and Environment.