Difference between revisions of "How to add tables to the Default Data Warehouse"

From ODBClink wiki
Jump to navigation Jump to search
(Created page with "== Overview == ODBCLink includes a Default data warehouse that includes the Accounts tables selected. If you want to add addition tables then follow the steps below == Proced...")
 
 
(One intermediate revision by the same user not shown)
Line 3: Line 3:


== Procedure ==
== Procedure ==
# From the Menu in the
# From the Menu click Manage Data Warehouses.
# Select the type of database to use. We recommend you use Microsoft Access 2000-2003 unless technically proficient with other databases;
# In the Manage Data Warehouses form, choose a Data Warehouse from the left. The default data warehouse is called My Data
# 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;
# Click the Edit Data Warehouse button
# Once all information is complete, click '''OK'''.
# At Filter choose the Accounting System that you are retrieving data for.
# The new data warehouse will appear in the '''Manage Data Warehouses''' dialog box. Click the '''Close''' button.
# Select the tables that you want to include in the data warehouse and click OK
# In the Manage Data Warehouses form, click Close.
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.
# From the Main Menu click Get Data
# When the Get Data is complete, click the Data Warehouse link to view the tables with data


<br clear=all>
<br clear=all>


=== Video ===
This getting started video will show you how to add or edit data warehouses within ODBClink.
{{#ev:youtube|RKn5h4wlQTw|560|left|Adding and Editing Data Warehouses within ODBClink}}
<br clear=all>
== Related Topics ==
== Related Topics ==


Latest revision as of 17:29, 20 January 2015

Overview

ODBCLink includes a Default data warehouse that includes the Accounts tables selected. If you want to add addition tables then follow the steps below

Procedure

  1. From the Menu click Manage Data Warehouses.
  2. In the Manage Data Warehouses form, choose a Data Warehouse from the left. The default data warehouse is called My Data
  3. Click the Edit Data Warehouse button
  4. At Filter choose the Accounting System that you are retrieving data for.
  5. Select the tables that you want to include in the data warehouse and click OK
  6. In the Manage Data Warehouses form, click Close.
  7. From the Main Menu click Get Data
  8. When the Get Data is complete, click the Data Warehouse link to view the tables with data


Related Topics

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