The Greenplum connector allows data to be cataloged, queried, transformed and to create tables in Greenplum. This can be used to quickly and easily join data between different systems like Greenplum and Hive, or between different Greenplum instances.
The Greenplum connector is available for the Promethium Enterprise plan.
Connect Greenplum
Connecting to Greenplum is fast and easy. Simply click Data Sources from the menu, then click + New Data Source. Select Greenplum and enter the information for your Greenplum.
Greenplum Connection
Greenplum connection details can be case-sensitive. Ensure that data is entered with the correct case for your Greenplum.
Field | Description |
Data Source Name | Give the Greenplum connection a unique name for easy identification. |
Description | Optional. A meaningful description for this connection. |
Host Name | Enter the host name for your Greenplum database. For example: db.company.com |
DB Port | Enter the port number for your Greenplum database. |
User Name | Enter the username associated with your Greenplum account. |
Password | Enter the password associated with your Greenplum account. |
Database Name | Enter the database containing the data you want to retrieve. |
Data Source Topic | Optional. Categorize the Greenplum connection. For example, Marketing. |
What Happens Next - Finish Greenplum Connection
Click the Connect button then select schemas. After successful connection and schema selection Promethium will automatically crawl and catalog data in your Greenplum, then make the data easily searchable and usable.
Click Data Explorer from the menu and begin exploring the data in your Greenplum database.
FAQs
Is my data moved or copied out of Greenplum?
No. Your data stays in Greenplum and isn't moved to Promethium.
What options are available for publishing datasets?
Datasets can be published as a view, as a table in Greenplum or as a dbt model.
Is this a Production-level connector?
Yes. The Greenplum connector is designed for all-sized Datasets.