Skip to main content

Glossary

  • Action — A reusable HTTP request or SQL stored procedure that jobs run.
  • Activity — A group of items inside a job phase, run in parallel by default.
  • Agent key — A scoped API key issued to an on-prem Gateway.
  • BI Endpoints — Datawareness's Business Central app that publishes a catalogue of entity sets.
  • Business key — The field(s) that identify a record, && between parts.
  • Business Plus — The feature set holding the Data API and Data access.
  • Configuration package — A JSON file of configuration, moved between environments or installs.
  • Custom endpoint — A Business Central table exposed through BI Endpoints with columns of your choice.
  • Data access role — Who may read which datasets and instances through the Data API.
  • Data API — The read-only API for loaded data.
  • Data catalogue — Per source system, what can still become a dataset.
  • Data reference — A variable whose values come from a loaded dataset.
  • Dataset — A target table fed from endpoints, a Gateway table, a webhook or a parent dataset.
  • Endpoint — One request a dataset makes.
  • Environment — A complete, separate copy of configuration and data.
  • Environment key — The API key that names an environment on trigger and webhook calls.
  • Export system — A destination warehouse or lakehouse.
  • Full load / incremental load — A read of everything, with rows not seen marked deleted afterwards, versus a read of changes since the last load.
  • Gateway — The on-premises worker that pushes SQL Server and ODBC data to Cloud Connector.
  • Global variable — A variable shared by every environment, {{g:name}}.
  • Instance — One connection to a source system.
  • Integer loop — A counter variable for page-numbered APIs.
  • Item — An action, stored procedure or dataset refresh inside an activity.
  • Job — A pipeline of three phases: before, refresh, after.
  • Job variable — A run-scoped value shared by a job's actions, {{j:name}}.
  • Load log — The record of one dataset load.
  • Nested dataset — A dataset made from a nested field of another dataset's rows.
  • Phase — Before refresh data, Refresh Source Data, After refresh data.
  • Progressive load — Rows written to SQL while the load fetches them.
  • Run — One execution of a job or schedule.
  • Schedule — Cron expressions that run jobs.
  • Schema — The namespace a source system's data lands in.
  • Single-instance source system — A source system with exactly one instance and bare record ids.
  • Source system — A logical data source with instances, endpoints and datasets.
  • Subscription — An outbound webhook on job or schedule events.
  • Template — A package published in the Templates gallery.
  • Unpack — The path to the records in a response.
  • Variable — A value referenced as {{name}}.
  • Watermark — The column or timestamp an incremental load resumes from.
  • Webhook (inbound) — A URL an external system POSTs rows to.