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 Credentials and Certificates, you can use secrets if a vault is configured for the platform and the service supports vaults. For information, see Using secrets from vaults in connections.
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 deployment space
- Click Add to space > Connection. See Adding connections 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 Refinery (Watson Studio)
- SPSS Modeler (SPSS Modeler service)
- Synthetic Data Generator (Synthetic Data Generator service)
Catalogs
- Platform assets catalog
Federal Information Processing Standards (FIPS) compliance
- 4.8.0 and 4.8.1: This connection is compliant with FIPS if you installed Cloud Pak for Data on or prior to January, 22, 2024. However, the connection is not compliant if it requires SSL.
- 4.8.2 and later: This connection is not compliant with FIPS, but it is FIPS-tolerant.
Greenplum setup
Restriction
For SPSS Modeler, you can use this connection only to import data. You cannot export data to this connection or to a Greenplum connected data asset.
Learn more
Parent topic: Supported connections