Intro
PostgreSQL users can now connect their data to Domo through Cloud Amplifier integrations. Integrating PostgreSQL with Domo is now as simple as providing connection parameters and selecting tables that you want to see as Domo DataSets.Create a PostgreSQL Integration
-
In Domo, go to the
Data Warehouse and select 
Add New Cloud Account to open the connection modal.
-
Under
Native integration, choose See More
PostgreSQL. - Select Add New Integration. (If there are existing integrations, this option displays at the bottom of the list.)
-
Enter the information listed in the table below and select
Next.
Parameter
Description
Integration name
This is how you can find your integration in the PostgreSQL integrations list for future updates.
(Optional) Description
Enter any additional information about the integration.
PostgreSQL connection URL
Enter the host and port that represents the PostgreSQL instance you want to connect to. Example: <<myhost.com>>
PostgreSQL connection port
Enter the port where your PostgreSQL instance is running. Example: <<5432>>
PostgreSQL database name
Enter the name of the database you want to connect to. Example: <<defaultdb>>
PostgreSQL username
Enter the name of your PostgreSQL username.
PostgreSQL password
Enter the password for the user in the previous field.
-
Configure the caching options and select
Next. Learn about Cloud Amplifier’s caching rules.
A success message displays.
- Use the table picker to choose the PostgreSQL schemas and tables to connect to Domo.
- Select Create DataSets to open the sharing modal. You have the option to share the data with individuals and groups in Domo and choose their access level.
