Beta feature. The reporting database is currently in beta and is turned on per workspace by Azumuta.
Before You Start
The reporting database is a beta feature that Azumuta enables for your workspace on request — it isn't self-service yet. Contact your Customer Success Manager to have it switched on for your account.
Once it's enabled, anyone on your team with permission to manage company settings can configure which data is synced.
Choose Which Data to Sync
The reporting database does not copy everything by default — you decide which data is included, table by table (for example: work instructions, recordings, issues, product orders). This keeps the database focused on what you actually report on.
- Enable a table to start syncing that data.
- Some tables depend on others. When you enable a table, Azumuta automatically enables the related tables it needs, so your data stays consistent.
- Disabling a table later removes it from the reporting database to free up space. If you re-enable it, it is rebuilt from scratch on the next sync.
Set the Sync Frequency
Your selected data is refreshed automatically on a schedule. The default interval is every 15 minutes. After each refresh, only the records that changed since the last sync are updated, so syncs stay fast.
The very first sync of a table copies all of its existing data and can take several minutes for large tables. Later syncs are incremental and much quicker.
Get Your Connection Details
Once the reporting database is enabled, Azumuta provisions a private, read-only area for your workspace and provides the connection details (host, port, database name, schema, and credentials).
Continue to How to Connect to the Reporting Database to start querying your data.