Difference between revisions of "Data Warehouses"

From ODBClink wiki
Jump to navigation Jump to search
Line 11: Line 11:
* Specify the location of your data warehouses.
* Specify the location of your data warehouses.


It is only available in '''ODBClink Pro Edition''' and '''ODBClink Ultimate Edition'''.
It is only available in '''ODBClink Standard Edition''', '''ODBClink Pro Edition''' and '''ODBClink Ultimate Edition'''.
   
   
== Related Topics ==
== Related Topics ==

Revision as of 01:47, 21 June 2016

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.


Advanced data warehouse management

Advanced data warehouse management provides the following additional functionality.

  • enable/disable data warehouses;
  • Specify the location of your data warehouses.

It is only available in ODBClink Standard Edition, ODBClink Pro Edition and ODBClink Ultimate Edition.

Related Topics