Connect DataDatabases
Azure Database for PostgreSQL
You connect Azure Database for PostgreSQL from the DataSquares connection wizard. Managed Postgres on Azure — connect like Postgres (TLS on). Live-validated.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick Azure Database for PostgreSQL on that page (search or browse by category).
-
Fill in the connection details below, then test the connection and save.
Connection details
Section titled “Connection details”| Field | What to enter |
|---|---|
| Host | The hostname or IP address of your Azure Database for PostgreSQL server. |
| Port | Prefilled with 5432 (the Azure Database for PostgreSQL default) — change it if your server listens elsewhere. |
| Database | The database to connect to. |
| Username / Password | Credentials for a user with read access to the tables you want to analyze. |
| TLS | On by default: Use SSL/TLS encryption connects encrypted and verifies the server certificate. Tick Trust self-signed certificate for a private CA; turn TLS off only for a server that has none. |
Grant the connection user read-only access — DataSquares only ever reads from your source.
Related
Section titled “Related”- Connector catalog — everything DataSquares connects to.
- Quickstart — from connection to shared dashboard.