Data Warehouses - Revision history

Nic at 06:55, 13 May 2014

2014-05-13T06:55:11Z

← Older revision		Revision as of 01:55, 13 May 2014
Line 19:		Line 19:
	# The new data warehouse will appear in the '''Manage Data Warehouses''' dialog box. Click the '''Close''' button.		# The new data warehouse will appear in the '''Manage Data Warehouses''' dialog box. Click the '''Close''' button.

	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 [[BudgetLink System folder]]. You can now open this data warehouse and add any ~~additioanl~~ queries or business logic you need.		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 [[BudgetLink System folder]]. You can now open this data warehouse and add any additional queries or business logic you need.

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

Jeff at 23:20, 28 August 2013

2013-08-28T23:20:09Z

← Older revision		Revision as of 18:20, 28 August 2013
Line 25:		Line 25:
	== Related Topics ==		== Related Topics ==

	~~None.~~		[[Get Data Queries]]

Jeff: /* Overview */

2013-08-28T23:18:59Z

Overview

← Older revision		Revision as of 18:18, 28 August 2013
Line 1:		Line 1:
	== Overview ==		== 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 ~~Microsot~~ Access databases or Microsoft SQL Server databases. During the BudgetLink [[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 BudgetLink [[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 ==		== Creating a data warehouse ==

Nic at 01:38, 26 August 2013

2013-08-26T01:38:16Z

← Older revision		Revision as of 20:38, 25 August 2013
Line 1:		Line 1:
	== Overview ==		== Overview ==

	A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated ~~MYOB Tables~~. The databases can either be Microsot Access databases or Microsoft SQL Server databases. During the BudgetLink [[Get Data]] process, the data warehouses will be created and populated with the ~~defined~~ 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 Microsot Access databases or Microsoft SQL Server databases. During the BudgetLink [[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 ==		== Creating a data warehouse ==

Nic at 01:37, 26 August 2013

2013-08-26T01:37:27Z

← Older revision		Revision as of 20:37, 25 August 2013
Line 22:		Line 22:

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

			== Related Topics ==

	~~=== Notes ===~~		None.

	* The new data warehouse will appear in the [[BudgetLink System folder]].

	~~Back to Menu~~

Nic: Created page with "== Overview == A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated MYOB Tables. The databases can either be ..."

2013-08-26T01:36:48Z

Created page with "== Overview == A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated MYOB Tables. The databases can either be ..."

New page

== Overview ==

A data warehouse is a database used for reporting. A data warehouse is a definition of a database to house replicated MYOB Tables. The databases can either be Microsot Access databases or Microsoft SQL Server databases. During the BudgetLink [[Get Data]] process, the data warehouses will be created and populated with the defined 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 ==

[[File:ManageDataWarehouses.png|300px|thumb|right|Manage Data Warehouses dialogue]]
[[File:AddDataWarehouse.png|300px|thumb|right|Add Data Warehouses dialogue]]

To add a data warehouse, follow these steps.

# From the '''Menu''', click on '''30. Settings''', then '''Data Warehouses''';
# Click on the '''Manage Data Warehouses''' button;
# Click the '''Add Data Warehouse''' button in the Manage Data Warehouses dialog box that appears;
# 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;
# 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'''.
# The new data warehouse will appear in the '''Manage Data Warehouses''' dialog box. Click the '''Close''' button.

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 [[BudgetLink System folder]]. You can now open this data warehouse and add any additioanl queries or business logic you need.

<br clear=all>

=== Notes ===

* The new data warehouse will appear in the [[BudgetLink System folder]].

Back to Menu