Connecting to a Greenplum data source

To access Greenplum data sources, you must define a connection by using the properties in the Connection section on the Properties page.

Before you begin

  • Create the ODBC driver and data source definition to Greenplum.
  • Define a job that includes a Greenplum Connector stage.

Procedure

  1. To open the stage editor, on the job design canvas, double-click the Greenplum Connector stage icon.
  2. In the Data source property, specify the ODBC data source name (DSN) as defined in the ODBC driver manager or the odbc.ini file for a Greenplum database.
  3. Optional: In the Database property, specify the name of the Greenplum database on the server that is defined in the ODBC data source.
  4. In the User Name and Password properties, specify the credentials of the user to use for the connection.
  5. Click Save to save the details.