Setup takes 5 minutes.
Introduction
Connecting Greenplum to Foundational allows Foundational to scan and determine lineage and downstream impact for Greenplum/VMware Tanzu Greenplum.
To make the connection, you need to:
Create a user and grant permissions to the metastore database
Configure the Greenplum connector in Foundational
Prerequisites
Ensure you have:
Greenplum admin rights
Access to your preferred Greenplum client (the examples in this guide use
psql)
Configured firewalls and security groups so that Foundational can access the Greenplum database. To add Foundational IP address to the allowlist, see the article Allowing IP Access to Foundational
Access permissions
The permissions you assign to Foundational enable it to read metadata and determine lineage and downstream impact for Greenplum.
Create a user and grant permissions to the Metastore database
You access the Greenplum database through your preferred client. The command-line examples in this guide use psql.
Download the script that creates the
foundationaluser and role: create_foundational_user.sql.
Open the downloaded script in a text editor and change
<fill-the-password-here>to a password of your choice.
Save the script.
Run the script on your Greenplum database as admin with the following command:
psql -h <greenplum-host> -p 5432 -U gpadmin -d postgres -f create_foundational_user.sql
Verify that no errors occur. The script succeeds when you see this message:
... ---------------------------------------------------------------------- Succeeded in creating Foundational role, and granting metadata permissions ---------------------------------------------------------------------- ...
Connect Foundational to Greenplum
In Foundational, open the Connectors & Integrations page.
In Data Stores, select the Greenplum card and click Connect.
Click Add Database.
The initial setup screen opens. Click Start Setup.
The Set Up New Connection screen opens.
Enter the details:
Database URL: The host address of the Greenplum database.
Database Name: The name of the database in your Greenplum instance.
User Name: The username for Foundational to connect to your Greenplum. If you used the script, the name is
foundational.
Password: The password for the
foundationalusername. The password is the password you set when you edited the script.
Click Next.
The final setup screen opens. To complete the connection, click Save.
That's it. Foundational is now connected to Greenplum.