Write, Bureaucrats, Administrators
1,344
edits
Difference between revisions of "Data Warehouses"
Jump to navigation
Jump to search
no edit summary
| (7 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
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. | 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. | ||
In order to use ODBClink, you will need to create a data warehouse. | |||
If this is your first time using ODBClink, see [[Adding a data warehouse]]. | |||
== Microsoft Access 2007-2016 == | |||
'''Microsoft Access 2007-2016''' data warehouses are available in '''ODBClink Free Edition''' or higher. | |||
== Microsoft Access 2000-2003 == | |||
'''Microsoft Access 2000-2003''' data warehouses are available in '''ODBClink Standard Edition''' or higher. | |||
== Microsoft SQL Server == | |||
'''Microsoft SQL Server''' data warehouses are available in '''ODBClink Standard Edition''' or higher. | |||
== MySQL == | |||
'''MySQL''' data warehouses are available in '''ODBClink Standard Edition''' or higher. | |||
== 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''', and '''ODBClink Pro Edition'''. | |||
== Related Topics == | == Related Topics == | ||