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:
- Right click the Data Warehouses node and select Add Data Warehouse
- Type DSA in the Name box
- Tick the "Use global database" box and select the DSA database from the drop-down list.
- Click OK
- Right click the Data Warehouses node and select Add Data Warehouse
- Type MDW in the Name box
- Tick the "Use global database" box and select the MDW database from the drop-down list.
- Click OK
Note: Video is free of audio