Exercise: Creating Data Warehouses

A data warehouse in TimeXtender is a SQL Server database where your data is stored for queries and analysis, which is stored in either on-premise or in Azure . Often, a TimeXtender project consists of one data warehouse where you consolidate data from one of more staging databases and a number of data sources. For more detailed information, please see Data Warehouses.

Steps:

  1. Right click the Data Warehouses node and select Add Data Warehouse
  2. Type DSA in the Name box
  3. Tick the "Use global database" box and select the DSA database from the drop-down list.
  4. Click OK
  5. Right click the Data Warehouses node and select Add Data Warehouse
  6. Type MDW in the Name box
  7. Tick the "Use global database" box and select the MDW database from the drop-down list.
  8. Click OK