This topic describes how to create a Microsoft cloud data source of the PostgreSQL type.
Prerequisites
A Microsoft Cloud PostgreSQL database is created.
You have obtained the username and password of the Microsoft Cloud PostgreSQL database.
Limits
PostgreSQL 8.2 or later is supported.
Procedure
Add the elastic IP address (EIP) of the exclusive resource group for Data Integration or the CIDR block of the vSwitch with which the resource group is associated to the IP address whitelist of the data source that the resource group needs to access.
Before connecting to Microsoft Cloud PostgreSQL, you need to add the Quick BI IP address to the whitelist of Microsoft Cloud PostgreSQL.
Add a Hologres data source and verify that the data source can be connected.
After you log on to the Quick BI console.
Follow the instructions in the following figure to add a data source
Go to the Create Data Source page.
Select PostgreSQL Data Source.
Select Microsoft Cloud for Data Source Type.
In the Configure Connection dialog box, configure the following settings based on your business requirements.
Feature
Description
Name
The name of the data source. The name is displayed in the data source list.
The name cannot contain special characters or start or end with spaces.
Database Address and Port Number
The public endpoint and port used to deploy the PostgreSQL database. Log on to the Azure portal and obtain the public endpoint.
Instance
The name of the database to which you want to connect.
Schema
The schema name of the PostgreSQL database.
Username and Password
The username and password that are used to log on to the PostgreSQL database.
SSL
If SSL is configured for the destination data source, you can select SSL to protect data security.
Click Test Connection to verify that the data source can be connected.
Click OK.
What to do next
After you add a data source, you can create a dataset and analyze data.
For more information about how to add a table in the PostgreSQL database or a self-managed SQL Quick BI, see Create and manage datasets.
You can add charts for data analysis. For more information, see Create a dashboard and Overview of visualization charts.
Drill down the data for in-depth data analysis. For more information, see the Configure the drilling feature section of the "Drilling" topic.