Staging database

The Staging database is used for custom staging, for example for preparing data before loading to integration tables, or for loading data and structures to OLAP cubes and dimensions.

You can perform these actions:

  • Create custom tables and freely add their schemas
  • Create load queries to load data into Staging tables
  • Create scripts to manipulate data in Staging tables
  • Create non-SQL scripts to execute data loading and mapping tasks
  • Use the dimension view to edit a table's elements
To load data from Staging tables to OLAP cubes and dimensions, create cube and hierarchy mappings in the Edit Database dashboard. Then use cube and hierarchy mappings to load data into OLAP.
Note: The Staging database also contains system tables, for example the log tables, which cannot be edited.