Overslaan en naar hoofdcontent gaan

How to Connect to the Reporting Database

Azumuta Support
Bijgewerkt

Beta Feature. The Reporting database is currently in Beta and may still evolve. It is available by opt-in only. To join the Beta or ask questions, contact support@azumuta.com.

What You'll Need

After enabling the Reporting database, Azumuta provides the following Verbinding Details:

  • Host — the address of your Reporting database.
  • Port — the port to connect on.
  • Database Naam — the database to connect to.
  • Gebruikersnaam and Wachtwoord — Alleen-lezen credentials for your Workspace.
  • Schema Naam — the area inside the database that holds your Workspace's Data. It looks like company_<your-workspace-id>.

Treat these credentials like a Wachtwoord. Anyone with them can read your Reporting Data. Delen them only with the personen who need them, and store them in a Geheimen manager rather than in shared documents or source code.

Secure Connections (SSL) Are Required

The Reporting database only accepts encrypted connections. When you connect, make sure SSL/TLS is Ingeschakeld. In most Gereedschap this means setting the SSL Mode to require (or enabling an "Use SSL" checkbox).

Connect With a SQL Client

You can use any PostgreSQL-compatible client, such as psql, DBeaver, TablePlus, or pgAdmin. A Verbinding string looks like this:

postgresql://<username>:<password>@<host>:<port>/<database>?sslmode=require

After connecting, point your session at your Workspace's schema so you can refer to Tabellen by their short names:

set search_path to "company_<your-workspace-id>";

To Bevestig everything works, Lijst the available Tabellen:

select table_name
from information_schema.tables
where table_schema = 'company_<your-workspace-id>'
order by table_name;

Connect With a BI Gereedschap

Gereedschap like Power BI, Tableau, Metabase, Looker, and Grafana all support PostgreSQL. In general:

  1. Voeg toe a new Data Bron and choose the PostgreSQL connector.
  2. Enter the host, port, database Naam, Gebruikersnaam, and Wachtwoord from Azumuta.
  3. Inschakelen SSL (Stel SSL Mode to require).
  4. When asked for a schema, Selecteer your Workspace schema (company_<your-workspace-id>).

Once connected, your Tabellen appear in the Gereedschap and you can Start building Dashboards. See Voorbeeld Analytics Queries for ideas to get Gestart.

A Note on Prestatie

The Reporting database is a copy, so heavy queries won't slow down your live Azumuta Workspace. Even so, it's good practice to Filter and aggregate in SQL rather than pulling entire Tabellen into your BI Gereedschap.

Turn manufacturing into a limitless engine of progress

Verwante artikelen