Skip to main content

​
Intro

PostgreSQL is a widely used open-source relational database management system. You can use Domo’s PostgreSQL Connector to pull data from your PostgreSQL database and compile custom reports. To learn more about the PostgreSQL API, see (https://www.postgresql.org/about/news/postgresql-restful-api-1616/ ). You can connect to your PostgreSQL account in the Data Center. This topic discusses the fields and menus that are specific to the PostgreSQL connector user interface. To add DataSets, set update schedules, and edit DataSet information, see Adding a DataSet Using a Connector.

​
Prerequisites

To connect to your PostgreSQL account and create a DataSet, you must have the following:
  • Username
  • Password
  • Host
  • Port
  • Select a Certificate Type. The certificate type must match what you enter in the Certificate field. If you are unaware of a special certificate, then you can select No Certificate from the drop-down list.
  • Database

​
Connecting to Your PostgreSQL Account

This section enumerates the options in the Credentials and Details panes on the PostgreSQL Connector page. The components of the other panes on this page, Scheduling, and Name & Describe Your DataSet, are universal across most connector types and are discussed in great detail in Adding a DataSet Using a Connector.

​
Credentials Pane

This pane contains fields for entering credentials to connect to your PostgreSQL account. The following table describes what is needed for each field:

Field

Description

Username

Enter your PostgreSQL username. If you don’t know your username, contact your PostgreSQL Database Administrator for help.

Password

Enter your PostgreSQL password. If you don’t know your password, contact your PostgreSQL Database Administrator for help.

Host

Enter the host name for the SQL database. If you don’t know the host name, contact your PostgreSQL Database Administrator for help.

Port

Enter the port number for the SQL database. If you don’t know the port number, contact your PostgreSQL Database Administrator for help.

Certificate

Paste the text for your CA certificate or enter the URL where your certificate is located. By default no certificate is required.

Certificate Type

Select a certificate type. This must match what you enter in the Certificate field. If you are not sure of a special certificate, select No certificate from the drop-down list.

Database

Enter the name of the SQL database. If you don’t know the database name, contact your SQL Database Administrator.

Once you have entered valid PostgreSQL credentials, you can use the same account any time to create a new PostgreSQL DataSet. You can manage connector accounts in the Accounts tab in the Data Center. For more information about this tab, see Manage Connector Accounts.

​
Details Pane

Menu Description
Query Helper Edit this query if desired.
Database Tables Select the database table that you want to view in your report.
Table Columns Select all the table columns you want to view in your report.
Query Helper Edit this query if desired.
Incremental Pull Select either Last Value or Max Value , or None from the drop-down list.

​
Other Panes

For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see Adding a DataSet Using a Connector.