Skip to main content
Regulaxy

Databases

The database inventory as the DBA team holds it, why the column set differs between sites, and which three fields are written back.

This inventory belongs to the DBA team, and Regulaxy reads it live. The column set comes from the source itself, so it looks different in every deployment, and different between Oracle and MSSQL in the same deployment.

Sources

The source selector sits in the toolbar and changes shape with what exists:

Sources configuredWhat is shown
OneA label only, naming the source
TwoAn Oracle / MSSQL switch
Three or moreA dropdown, each entry naming the object it reads — at that point the label alone stops telling them apart

Each source keeps its own column order. In a deployment with no source configured, the screen says so rather than rendering an empty table.

The columns

This is the one table in the product that scrolls sideways. Everywhere else the columns are fitted to the width of the screen; here there are twenty or more, they arrive at runtime, and there is no administrator-set priority order to fit them against — so fitting them would leave all of them below a legible width. The identity column stays frozen while you scroll.

Three fields that are written back

FieldWhat it is for
SystemThe business system the database belongs to
System ownerWho is responsible for it. Filled in automatically when the system is chosen
Coordination noteA free-text note from the team

System is picked from a list — the same list of systems the business-impact register works against, and that is what wires the two together.

The write goes to the source's write object, which is not necessarily the object it is read from. Both objects are named in the information line under the table, because when an update is rejected that is the first question. A rejected update states the reason and returns the cell to its previous value.

The database record

Clicking a row opens a record. The key is the database name together with its host — PROD on two hosts is two databases, and a shared overlay between them is a data-integrity bug wearing a UI bug's clothes.

A row whose source has no database-name column does not open a record, and the screen says so rather than leaving a click that does nothing.

On the record you can add custom fields of your own. They are stored in Regulaxy, alongside the inventory, and are not written to the source.

Actions and states

  • Multi-row selection feeds the scheduling wizard, up to 50 records; anything beyond that is stated before it proceeds.
  • CSV and Excel export what is on screen.
  • When the source is unreachable the screen shows demo data and says so in a banner that cannot be dismissed. Presenting fictional rows as the inventory is worse than an error message.

Who may do what

PermissionWhat it allows
View databasesReading the inventory and the record
Edit coordination fieldsWriting the three fields above back to the source
Export databasesCSV and Excel

Updated

This page is the file content/docs/en/v1/assets/databases.mdx