Connect DataDatabases
Vertica
You connect Vertica from the DataSquares connection wizard. Host, port 5433 and database credentials — PG-family analytics warehouse.
-
In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.
-
Pick Vertica 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 Vertica server. |
| Port | Prefilled with 5433 (the Vertica 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.