LATEST VERSION: 1.0 - RELEASE NOTES
Pivotal Greenplum®-Informatica Connector v1.0

Installing Components for Informatica Data Integration Services and Developer Tool Clients

Follow these steps to install the Pivotal Greenplum-Informatica Connector 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 Greenplum-Informatica Connector Components:

Step 1: Install the Informatica Data Integration Service Connector Component

  1. Download and uncompress the Pivotal Greenplum-Informatica Connector distribution from Pivotal Network.

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

  3. Copy the Greenplum-Informatica 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. Execute 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 Pivotal Greenplum-Informatica 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 Pivotal Greenplum-Informatica Connector distribution from Pivotal Network.

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

  3. Copy the Greenplum-Informatica 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. Execute 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 Service (GPSS) manages communication and data transfer between the Pivotal Greenplum-Informatica Connector and Greenplum Database. In addition to installing the Pivotal Greenplum-Informatica 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.