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 dropdown 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 dropdown, 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 dropdown 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.