Skip to main content

[en] Configure Pivotal Greenplum Bulk Connection for Writing Data

[en] Connection Type

[en] ODBC 64-bit + Bulk.

[en] Driver Details

[en] The ODBC driver can be downloaded from PostgreSQL: File Browser

[en] or DataDirect ODBC Drivers for Pivotal Greenplum|Pivotal Greenplum Docs.

[en] Type of Support

[en] Write only.

[en] Validated On

[en] Database Version: 6

[en] ODBC client version: 7.1

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

  1. [en] 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. [en] In the Single Access Point menu go to Data sources and select Pivotal Greenplum| Bulk.

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

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

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

  2. [en] Select Greenplum as the Data Source.

  3. [en] For the Read tab

    1. [en] Select Greenplum ODBC as the Driver;

    2. [en] Select new database connection;

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

  4. [en] For the Write tab

    1. [en] Select Greenplum Bulk Loader;

    2. [en] Select new database connection;

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

: