Configure Pivotal Greenplum Bulk Connection for Writing Data
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:
In Designer place an Output Data Tool on the canvas and select the drop-down for the field Write to a File or Database.
In the Single Access Point menu go to Data sources and select Pivotal Greenplum| Bulk.
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:
In Designer, go to Options - Advanced Options - Manage In-DB Connections.
Select Greenplum as the Data Source.
For the Read tab
Select Greenplum ODBC as the Driver;
Select new database connection;
Select your DSN from the drop-down and enter a value for username and password.
For the Write tab
Select Greenplum Bulk Loader;
Select new database connection;
Select your DSN connection from the drop-down, and enter a value for User Name, Password, Database Name, Host, Port, and SSL Mode.