Greenplum
Greenplum is an open-source, massively parallel processing (MPP) data warehouse based on PostgreSQL. It is designed for large-scale analytics, allowing high-performance querying across distributed clusters of servers, and supports advanced features like machine learning and in-database analytics.
Prerequisites
The following prerequisites must be met for a user to create and test a successful connection.
- Greenplum server must be accessible from the iceDQ server.
- Valid credentials to access the database.
- Greenplum JDBC version 20 or above.
Authentication Mechanism
The following authentication mechanism is supported.
- Username & Password
Connection Properties
Use the following properties to create a valid connection. Properties marked with an asterisk (*) are required.
| Name | Description | Example Values |
|---|---|---|
| Connection Name * | Name that uniquely identifies the connection. | Sales_Dev_conn |
| Driver * | Driver used to establish the connection. One driver is available by default. | Greenplum Native JDBC |
| Custom JDBC URL | Standardized string used to define the connection details. Use this format supported by the driver: jdbc:postgresql://[host]:[port]/[database] | jdbc:postgresql://192.168.44.31:5432/my_database |
| Host * | IP address or hostname of the Greenplum database server. | greenplum.acme.com or 192.168.44.31 |
| Port * | Port on which the server listens. Default is 5432 for Greenplum. | 5432 |
| Database * | Name of the target database in Greenplum. | my_database |
| Type * | The connection type – either System Connection or User Connection. Refer to Connections for more details. | System or User |
| Username * | Database login username with necessary privileges. | john_doe |
| Password * | Password associated with the specified username. | gp_password |
Custom Properties
Custom properties are optional connection parameters in the Greenplum driver, allowing customization of settings like timeouts and proxy configurations. A list of supported properties is available here. The availability and behavior of custom connection properties may vary depending on the version of the Greenplum JDBC driver in use.
Unsupported Datatypes
The following datatypes are not supported.
- INTERVAL
- TIME WITH TIMEZONE
- JSON
- XML
- UUID