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 these 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 task > 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.
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:
- SPSS Modeler
Catalogs
- Platform assets catalog
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