Difference between revisions of "Data Warehouses"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
== Related Topics == | == Related Topics == | ||
* [[Managing | * [[Managing Data Warehouses]] | ||
* [[Adding a data warehouse]] | * [[Adding a data warehouse]] | ||
* [[Editing a data warehouse]] | * [[Editing a data warehouse]] | ||
* [[Removing a data warehouse]] | * [[Removing a data warehouse]] | ||
* [[Get Data Queries]] | * [[Get Data Queries]] | ||
Revision as of 00:41, 15 May 2014
Overview
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 Microsoft Access databases or Microsoft SQL Server databases. During the 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.