Greenplum connection | IBM Cloud Pak for Data as a Service

Greenplum connection

Last updated: Nov 27, 2024

Greenplum connection

To access your data in Greenplum, create a connection asset for it.

Greenplum is a massively parallel processing (MPP) database server that supports next generation data warehousing and large-scale analytics processing.

Supported versions

Greenplum 3.2+

Create a connection to Greenplum

To create the connection asset, you need the following connection details:

Username and password
SSL certificate (if required by the database server)

For Private connectivity, to connect to a database that is not externalized to the internet (for example, behind a firewall), you must set up a secure connection.

Choose the method for creating a connection based on where you are in the platform

In a project: Click Assets > New asset > Connect to a data source. See Adding a connection to a project.
In a catalog: Click Add to catalog > Connection. See Adding a connection asset to a catalog.
In a deployment space: Click Import assets > Data access > Connection. See Adding data assets to a deployment space.
In the Platform assets catalog: Click New connection. See Adding platform connections.

Next step: Add data assets from the connection

Where you can use this connection

You can use Greenplum connections in the following workspaces and tools:

Projects

Data quality rules (IBM Knowledge Catalog)
DataStage (DataStage service). For more information, see Connecting to a data source in DataStage.
Metadata enrichment (IBM Knowledge Catalog)
Metadata import (IBM Knowledge Catalog)
SPSS Modeler (watsonx.ai Studio)

Catalogs