Difference between revisions of "Data Warehouses"

23 bytes added ,  20:38, 25 August 2013
no edit summary
Line 1: Line 1:
== Overview ==
== 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.
A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated tables from your accounting product. 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 chosen 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 ==
== Creating a data warehouse ==
2,717

edits