You can add an Aurora PostgreSQL data source to connect an Aurora PostgreSQL database to Quick BI. After the connection is established, you can analyze and visualize data in Quick BI. This topic describes how to add an Aurora PostgreSQL data source.
Limits
Version 15.4 is supported.
Procedure
Add the IP address to the whitelist.
Before you connect to Aurora PostgreSQL, you must add the IP address of Quick BI to the whitelist of Aurora PostgreSQL.
Go to the Create Data Source page from the entry for creating a data source.
On the AWS Database tab, select Aurora PostgreSQL as the data source.
In the Configure Connection dialog box, configure the parameters based on your business scenario.
Name
Description
Display 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
The public endpoint of the Aurora PostgreSQL database cluster.
Log on to the Amazon RDS console, click the corresponding database in the database list to go to the details page, and obtain the endpoint name from the "Connectivity & security" tab. This is the database address, for example: xxxxxxxx.rds.amazonaws.com.
For more information, see Creating an Aurora PostgreSQL DB cluster and connecting to it.
Port
The port number of the database. The default port number is 5432.
Database
The name of the database to be connected.
Schema
The schema of the database.
Username and Password
The username and password used to log on to the Aurora PostgreSQL database.
NoteMake sure that the user who logs on to the Aurora PostgreSQL database has the create, insert, update, and delete permissions on tables in the database.
Init SQL
After this feature is enabled, you can configure the SQL statement that is executed for initialization after the data source is connected.
The SQL statement that is executed for initialization each time the data source is connected. Only SET statements are allowed, and statements must be separated by semicolons.
SSL
If the destination data source has SSL configured, you can select the SSL security protocol to protect data security.
Click Test Connection to test the connectivity of the data source.
After the test is successful, click OK to complete the addition of the data source.
What to do next
After you add a data source, you can create a dataset and analyze data.
To add data tables from the SQL Server data source or custom SQL statements to Quick BI, see Create a dataset.
To add visualization charts and analyze data, see Create a dashboard and Overview of visualization charts.
To drill down into data for in-depth analysis, see Drill-down settings and display.