Before you create a catalog source, ensure that you have the information required to connect to the source system.
Perform the following tasks:
•Grant READ permission for the database user account that you use to access Greenplum.
•Create a connection.
•Create endpoint catalog sources for connection assignment.
Verify permissions
To extract metadata and to configure other capabilities that a catalog source might include, you need account access and permissions on the source system. The permissions required might vary depending on the capability.
Permissions for metadata extraction
Ensure that you have the required permissions to enable metadata extraction.
Grant permissions that allow you to perform the following operations:
•select on pg_catalog.PG_ATTRIBUTE
•select on pg_catalog.PG_CLASS
•select on pg_catalog.PG_CONSTRAINT
•select on pg_catalog.PG_DATABASE
•select on pg_catalog.PG_DESCRIPTION
•select on pg_catalog.PG_LANGUAGE
•select on pg_catalog.PG_NAMESPACE
•select on pg_catalog.PG_PROC
•select on pg_catalog.PG_TYPE
•select on pg_catalog.PG_VIEWS
•select on information_schema.COLUMNS
•select on information_schema.TABLES
•select on pg_catalog.PG_TABLES
•select on pg_catalog.PG_MATVIEWS
Create a connection
Create a Greenplum connection object in Administrator with the connection details of the Greenplum source system.
Before you create a connection, copy the Greenplum drivers to the specified directory on the Secure Agent machine. For more information, see Greenplum Connector in the Data Integration Connectors help.
1In Administrator, select Connections.
2Click New Connection.
3In the Connection Details section, enter the following connection details:
Connection property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Description
Description of the connection. Maximum length is 4000 characters.
4Select the Greenplum connection type.
5In the Greenplum Connection Properties section, enter the following connection details:
Property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Host Name
Host name or IP address of the Greenplum server.
Port
Greenplum server port number. Default is 5432.
Database
Name of the database.
Metadata Additional Connection Configuration
Additional metadata connection properties that you want to use.
User name with permissions to access the Greenplum database.
Password
Password to connect to the Greenplum database.
6Click Test Connection.
7Click Save.
Create endpoint catalog sources for connection assignment
An endpoint catalog source represents a source system that the catalog source references. Before you perform connection assignment, create endpoint catalog sources and run the catalog source jobs.
You can then perform connection assignment to reference source systems to view complete lineage with source system objects.