Set Up a Greenplum Connection (Beta)

Set up the Greenplum connection to start the flow of data into Data Cloud.

This feature is a Beta Service. A customer may opt to try a Beta Service in its sole discretion. Any use of the Beta Service is subject to the applicable Beta Services Terms provided at Agreements and Terms. If you have questions or feedback about this Beta Service, contact the Data Cloud Connector team at datacloud-connectors-beta@salesforce.com.
User Permissions Needed 
To create a connection:System Administrator

Before you begin:

  • Enable the Beta connector through the feature manager. See Enable Data Cloud Features.
  • Verify your admin has enabled firewalls on the system you want Data Cloud to connect to by including these IP addresses to your allowlists.

  1. In Data Cloud, click Setup, and select Data Cloud Setup.

  2. Under External Integrations, select Other Connectors.

  3. Click New.

  4. On the Source tab, select Greenplum and click Next.

  5. Enter a connection name, connection API name, and provide the authentication and connection details.

  6. For Authentication, provide your username and password credentials.

  7. For Connection, provide the URL, port, and database value.

    1. Provide the URL in one of these formats.

      An IP address format like 62.248.93.34 or a cloud Fully Qualified Domain Name (FQDN) for your Virtual Machine, for example, 62.248.93.34.bc.googleusercontent.com

    2. For Port, enter the port that the server is running on. The default is 5432, but it can be changed.

    3. Enter a Database value. The default schema is public but can be changed based on the database schema you want to query from.

  8. To review your configuration, click Test Connection.

  9. Click Save.

After the connector details are accepted, the connection is created and listed under Connectors. You can now create data streams.