analytics-dictionary / term / data infrastructure

Single sign-on (SSO)

Single sign-on lets users access many tools with one login managed by a company identity provider.

Written by Reflective Data experts · updated Oct 5, 2026

It improves security and convenience: access is granted and revoked centrally, and passwords are not scattered across tools. It is a standard requirement for enterprise software.

Combine it with role-based permissions for fine control.

Data governance Role-based access control (RBAC)

// how we can help

We design, build and optimise data warehouses and the cloud infrastructure around them. Data infrastructure services → · Managed data pipelines

Data orchestration

Data orchestration coordinates and schedules the steps of data workflows, handling dependencies, retries and alerts.

data-catalog.md

Data catalog

A data catalog is an organised inventory of your data assets, with descriptions, owners and lineage.

sql.md

SQL

SQL is the standard language for querying and managing data in relational databases and warehouses.

microsoft-azure.md

Microsoft Azure

Azure is Microsoft cloud platform, with data services such as Synapse, Data Lake Storage and Fabric.

schema.md

Schema

A schema defines the structure of data: the tables, columns and data types it contains.

elt.md

ELT (extract, load, transform)

ELT loads raw data into the warehouse first and transforms it there afterwards, using the warehouse…

← full analytics dictionary