Help Center/ Data Lake Visualization/ User Guide (ME-Abu Dhabi Region)/ Data Connection Management/ Creating Data Connections/ Creating PostgreSQL Data Connections
Updated on 2023-03-09 GMT+08:00
View PDF
Share

Creating PostgreSQL Data Connections

Before establishing a data connection to PostgreSQL, ensure that the following condition is met:

  • You have obtained the address, port number, username, and password of PostgreSQL.

Creating a PostgreSQL Data Connection

  1. Log in to the DLV console.
  2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.

    Figure 1 Creating a data connection

  3. In the New Data Connection dialog box, set Data Source Type to PostgreSQL and set the related parameters.

    Figure 2 Creating a PostgreSQL data connection

    Table 1 describes the PostgreSQL data connection parameters.

    Table 1 PostgreSQL data connection parameters

    Parameter

    Description

    Name

    Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).

    Domain Name

    IP address of the database.

    Port

    Port of the database.

    Username

    Username of the database. The database user must have permission to access data tables and metadata.

    Password

    Password of the database user.

    Agent

    Select an available connection agent.

    Database

    You can select a database from the Database drop-down list.

  4. Click OK.

Using PostgreSQL Data Sources

You can configure and use PostgreSQL data sources by referring to the instructions in Using DWS Data Sources.