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

← Older edit

How to add tables to the Default Data Warehouse (view source)

Revision as of 17:29, 20 January 2015

472 bytes removed , 17:29, 20 January 2015

→‎Procedure

Jeff

Write, Bureaucrats, Administrators

960

edits

@@ Line 3: / Line 3: @@
 == Procedure ==
-# From the Menu click Manage Data Warehouses
+# 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>
-=== 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>