Preface
Introduction to Greenplum Connector
- Greenplum Connector assets
Connections for Greenplum
- Prerequisites
  - Configuring JDBC and ODBC drivers
  - Configuring Kerberos authentication
    - Setting environment variables
- Connect to Greenplum
Mappings and mapping tasks with Greenplum Connector
- Greenplum sources in mappings
- Greenplum targets in mappings
  - Match and update columns
  - Error handling for Greenplum targets
Data type reference
- Greenplum and transformation data types

Greenplum Connector

Back Next

Prerequisites

Before you use Greenplum Connector, ensure that you meet the prerequisites.

Perform the following prerequisite tasks:

Install 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.

Configure the DataDirect Greenplum ODBC and JDBC drivers on the Secure Agent machine.

Configure 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.

Connections for Greenplum

Configuring JDBC and ODBC drivers

Configuring Kerberos authentication

Download Guide

Watch

Comments

Cloud Connectivity Homepage

Communities

Knowledge Base

Success Portal