Difference between revisions of "Data Warehouses"

From ODBClink wiki
Jump to navigation Jump to search
 
(10 intermediate revisions by 2 users not shown)
Line 3: Line 3:
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.


== Creating a data warehouse ==
In order to use ODBClink, you will need to create a data warehouse.


[[File:ManageDataWarehouses.png|300px|thumb|right|Manage Data Warehouses dialogue]]  
If this is your first time using ODBClink, see [[Adding a data warehouse]].
[[File:AddDataWarehouse.png|300px|thumb|right|Add Data Warehouses dialogue]]


To add a data warehouse, follow these steps.
== Microsoft Access 2007-2016 ==


# From the '''Menu''', click on '''30. Settings''', then '''Data Warehouses''';
'''Microsoft Access 2007-2016''' data warehouses are available in '''ODBClink Free Edition''' or higher.
# Click on the '''Manage Data Warehouses''' button;
 
# Click the '''Add Data Warehouse''' button in the Manage Data Warehouses dialog box that appears;
== Microsoft Access 2000-2003 ==
# In the '''Add Data Warehouse''' dialog box that appears, enter the '''Name''' and '''Description''' for the data warehouse;
 
# Select the type of database to use. We recommend you use Microsoft Access 2000-2003 unless technically proficient with other databases;
'''Microsoft Access 2000-2003''' data warehouses are available in '''ODBClink Standard Edition''' or higher.
# 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;
 
# Once all information is complete, click '''OK'''.
== Microsoft SQL Server ==
# The new data warehouse will appear in the '''Manage Data Warehouses''' dialog box. Click the '''Close''' button.
 
'''Microsoft SQL Server''' data warehouses are available in '''ODBClink Standard Edition''' or higher.
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 [[ODBClink System Folder]]. You can now open this data warehouse and add any additional queries or business logic you need.
 
== 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'''.


<br clear=all>
== Related Topics ==
== Related Topics ==


[[Get Data Queries]]
* [[Managing Data Warehouses]]
* [[Adding a data warehouse]]
* [[Editing a data warehouse]]
* [[Removing a data warehouse]]
* [[Get Data Queries]]

Latest revision as of 00:10, 21 March 2018

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.

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

Retrieved from "https://accountingaddons.com.au/wiki/odbclink/index.php?title=Data_Warehouses&oldid=1625"