Skip to main content

Glossary

TermMeaning
YresThe Azure data platform (data warehouse-as-a-service). Formerly Iris.
IrisOld product name of Yres. Still appears in resource names, Confluence (spaceKey=IRIS) and internal URLs.
OrganizationIsolated space in which a customer uses Yres; contains dev + prod by default.
EnvironmentIsolated version of an organization. At minimum dev and prod; optionally test, acceptance, quality.
ProjectCategorizes work within an environment; contains changes and has a due date.
ChangeSet of edits to the data warehouse, to be released and installed to other environments.
Scripted objectCustom SQL object (table, SP, function) not generated by Yres, managed under a change.
Data sourceConnected source from which data is loaded (database, app, OData/REST).
ADFAzure Data Factory โ€” orchestration layer that Yres generates pipelines to.
Integration Runtime (IR)ADF compute; reaches sources in local networks. Default AutoResolveIntegrationRuntime; self-hosted IRs possible.
DictionaryStored source metadata (tables, fields, keys, relations). Not for file and REST sources.
Load typeFULL, DELTA, OVERWRITE, RELOAD, IMAGE, ADDITIONAL, Delta Image. See databron-koppelen.
HISHistory schema (name via SchemaHIS).
STAGEStaging schema for delta loads (name via SchemaStage).
ODSOperational Data Store.
Persisted viewStored result of a view query; loaded in level order.
Master pipelineADF pipeline designed from the frontend with conditional flow (on success/failure/completion).
Dynamic Workflow YresThe generic load pipeline (source/schema/table).
Surrogate keyKey generated by Yres for the natural key; stored in [LoadManagement].[SurrogateKeys].
Service tierAzure database tier. < S3 no Columnstore; < P1 no in-memory.
DefaultStoreRow- (read/write) or column-oriented (queries) storage.
SSOSingle Sign-On via Azure; enforceable per user.
RBACRole-based access control; roles defined as CRUD per permission type.
DTAPDevelopment, Test, Acceptance, Production.
PlainwaterThe company behind Yres.