Configure Pivotal Greenplum Bulk Connection for Writing Data

Version:
2022.1
Last modified: May 04, 2022
Connection Type

ODBC 64-bit + Bulk.

Driver Details

The ODBC driver can be downloaded from PostgreSQL: File Browser 
or DataDirect ODBC Drivers for Pivotal Greenplum|Pivotal Greenplum Docs.

Type of Support

Write only.

Validated On

Database Version: 6
ODBC client version: 7.1

To configure the Pivotal Greenplum Bulk connection for writing data in the Output Data Tool, follow these steps:

  1. In Designer place an Output Data Tool on the canvas and select the drop-down for the field Write to a File or Database.

  2. In the Single Access Point menu go to Data sources and select Pivotal Greenplum | Bulk.

  3. Select your DSN connection from the drop-down, and enter a value for User Name, Password, Database Name, Host, Port, and SSL Mode.

To configure the Pivotal Greenplum Bulk connection for writing data for InDB, follow these steps:

  1. In Designer, go to Options - Advanced Options - Manage In-DB Connections.

  2. Select Greenplum as the Data Source.

  3. For the Read tab

    1. Select Greenplum ODBC as the Driver;

    2. Select new database connection;

    3. Select your DSN from the drop-down and enter a value for username and password.

  4. For the Write tab

    1. Select Greenplum Bulk Loader;

    2. Select new database connection;

    3. Select your DSN connection from the drop-down, and enter a value for User Name, Password, Database Name, Host, Port, and SSL Mode.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.