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 |
Type of Support | Write only. |
Validated On | Database Version: 6 |
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.
-