Follow these steps to install the VMware Greenplum Connector for Informatica components on both the Informatica Data Integration Service node and on the Informatica Developer Tool client machine.

After installing the Informatica components, you must also install and start the Greenplum Streaming Server (GPSS) service in the Greenplum Database cluster.

Prerequisites

See the Release Notes to understand the requirements and limitations for this release of the Connector.

Process

Follow these steps to install all Connector Components:

Step 1: Install the Informatica Data Integration Service Connector Component

  1. Download and uncompress the Connector distribution from Tanzu Network.

  2. Shut down the Informatica domain on which you will install the Connector files.

  3. Copy the Connector server component installation files to the server that runs the Informatica Data Integration Service. The required files and directories are:

    • The installServer.sh script file.
    • The server directory.

    Note: Copy files from the Informatica_Data_Services folder for Informatica Developer Tool and Data Integration Tool installations.

  4. Open a terminal on the Informatica Developer Tool machine, and navigate to the location of the Connector installation files. For example:

    cd ~/downloads
ls

  5. Run the installServer.sh script and provide the Informatica installation directory. For example:

    ./installServer.sh /usr/local/Informatica/10.0.0

    Note: If you need to reinstall the adapter or install a newer version of the adapter, include the true option to overwrite the existing files. For example:

    ./installServer.sh /usr/local/Informatica/10.0.0 true

    The installer registers the Connector to the Informatica Data Integration Service.

  6. Restart the Informatica domain.

Step 2: Install the Developer Tool Client Connector Component

  1. Download and uncompress the Connector distribution from Tanzu Network.

  2. Stop the Informatica Developer Tool application if it is currently running.

  3. Copy the Connector client component installation files to the machine that runs the Informatica Developer Tool. The required files and directories are:

    • The installClient.bat script file.
    • The client directory.

    Note: Copy files from the Informatica_Data_Services folder for Informatica Developer Tool or Data Integration Tool installations.

  4. Open a command window on the Informatica Developer Tool machine, and navigate to the location of the Connector installation files. For example:

    cd c:\Downloads
dir

  5. Run the installClient.bat file and provide the Informatica installation directory. For example:

    installClient.bat C:\Informatica\10.0.0\clients

    The installer copies the Connector client files to the Developer Tool installation.

After you install both the server and client Connector components, the loader connection type named GreenplumEnhancedLoader becomes available in the Informatica Developer Tool. You can view this connection type when you click the Create Connection or Show Connections icons. You will use this connection type to create a named connection to the Greenplum Streaming Server for selecting Greenplum Database tables as load targets. See Using the Connector.

Step 3: Install and Configure GPSS

The Greenplum Streaming Server (GPSS) manages communication and data transfer between the Connector and Greenplum Database. In addition to installing the Connector components in your Informatica cluster, you must install, configure and start GPSS in the Greenplum Database cluster. See Installing and Configuring GPSS in Greenplum Database for information.

check-circle-line exclamation-circle-line close-line
Scroll to top icon