Data Warehouses

From BudgetLink Wiki
Revision as of 20:36, 25 August 2013 by Nic (talk | contribs) (Created page with "== Overview == A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated MYOB Tables. The databases can either be ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Overview

A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated MYOB Tables. The databases can either be Microsot Access databases or Microsoft SQL Server databases. During the BudgetLink Get Data process, the data warehouses will be created and populated with the defined tables. Queries, views and stored procedures can be added to the database to transform data in preparation for reporting or external use.

Creating a data warehouse

Manage Data Warehouses dialogue
Add Data Warehouses dialogue

To add a data warehouse, follow these steps.

  1. From the Menu, click on 30. Settings, then Data Warehouses;
  2. Click on the Manage Data Warehouses button;
  3. Click the Add Data Warehouse button in the Manage Data Warehouses dialog box that appears;
  4. In the Add Data Warehouse dialog box that appears, enter the Name and Description for the data warehouse;
  5. Select the type of database to use. We recommend you use Microsoft Access 2000-2003 unless technically proficient with other databases;
  6. Under the Tables tab, select the tables to replicate. You can filter the list of tables based on the source data file you want to automate;
  7. Once all information is complete, click OK.
  8. The new data warehouse will appear in the Manage Data Warehouses dialog box. Click the Close button.

To fully create the data warehouse and populate it with data, you must perform a Get Data. Once the Get Data process has run, you will find your new data warehouse in the BudgetLink System folder. You can now open this data warehouse and add any additioanl queries or business logic you need.


Notes

Back to Menu