TRANXACT.AI Help
Platform › Reporting

ODBC Reporting Access

A read-only database login for your reporting tools (Power BI, Tableau, Excel via ODBC), limited to the schemas you choose, five connections and two-minute queries. Offered where this database holds only your company; on a shared database, ask V3iT for a read-only replica of your tenant. The password is shown once.

Where to find it

  1. Module: Platform
  2. Group: Insight
  3. Section: Reporting
  4. Screen: ODBC Reporting Access

Address in the console: /platform/reporting-access

List · 4 columns · 3 fields on its form · 1 of them required · 2 actions

What the list shows

These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.

ColumnKindField name
NameTextname
LoginCoderole_name
StatusStatusstatus
SinceDate and timeprovisioned_at

The form

What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.

FieldTypeChoicesNotes
Name required Text
Schemas Text slcm, hr, acct, crm, scm, ehr, mfg
Host your tools connect to Text

What you can do here

Provision primary

On each row of the list. Offered only on records where it applies.

Revoke

On each row of the list. Offered only on records where it applies.

Asks for confirmation: Revoke this login? Tools using it stop at once.

The rules that apply here

Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:

Beside it in Reporting