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
- To open the stage editor, on the job design canvas, double-click the Greenplum Connector stage icon.
- 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.
- Optional: In the Database property, specify the name of the Greenplum database on the server that is defined in the ODBC data source.
- In the User Name and Password properties, specify the credentials of the user to use for the connection.
- Click Save to save the details.