Editing a data warehouse - Revision history

Jeff at 02:54, 21 March 2018

2018-03-21T02:54:04Z

← Older revision		Revision as of 21:54, 20 March 2018
Line 7:		Line 7:
	# From the '''Menu''', click on the '''Manage Data Warehouses''' button;		# From the '''Menu''', click on the '''Manage Data Warehouses''' button;
	# Select the data warehouse to edit and click the '''Edit Data Warehouse''' button;		# Select the data warehouse to edit and click the '''Edit Data Warehouse''' button;
	# In the '''Edit Data Warehouse''' dialog box that appears:		# In the '''Edit Data Warehouse''' dialog box that appears and edit settings as required:
	## Edit the Name		## Edit the [[Data Warehouse Name]]
	## Edit the Description		## Edit the [[Data Warehouse Description]]
	## Edit [[Data Warehouse Login Details]]		## Edit the [[Data Warehouse Login Details]]
			## Edit the [[Data Warehouse Tables]]
			## Edit the [[Data Warehouse Options]]
	# Under the '''Tables''' tab, select additional tables or deselect existing tables to replicate. You can filter the list of tables based on the source data file you want to automate;		# Under the '''Tables''' tab, select additional tables or deselect existing 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'''.		# Once all information is complete, click '''OK'''.

Jeff at 02:50, 21 March 2018

2018-03-21T02:50:40Z

← Older revision		Revision as of 21:50, 20 March 2018
Line 9:		Line 9:
	# In the '''Edit Data Warehouse''' dialog box that appears:		# In the '''Edit Data Warehouse''' dialog box that appears:
	## Edit the Name		## Edit the Name
			## Edit the Description
	## Edit [[Data Warehouse Login Details]]		## Edit [[Data Warehouse Login Details]]
	# Under the '''Tables''' tab, select additional tables or deselect existing tables to replicate. You can filter the list of tables based on the source data file you want to automate;		# Under the '''Tables''' tab, select additional tables or deselect existing tables to replicate. You can filter the list of tables based on the source data file you want to automate;

Jeff at 02:50, 21 March 2018

2018-03-21T02:50:05Z

← Older revision		Revision as of 21:50, 20 March 2018
Line 7:		Line 7:
	# From the '''Menu''', click on the '''Manage Data Warehouses''' button;		# From the '''Menu''', click on the '''Manage Data Warehouses''' button;
	# Select the data warehouse to edit and click the '''Edit Data Warehouse''' button;		# Select the data warehouse to edit and click the '''Edit Data Warehouse''' button;
	# In the '''Edit Data Warehouse''' dialog box that appears~~, update~~ the ~~necessary settings;~~		# In the '''Edit Data Warehouse''' dialog box that appears:
			## Edit the Name
			## Edit [[Data Warehouse Login Details]]
	# Under the '''Tables''' tab, select additional tables or deselect existing tables to replicate. You can filter the list of tables based on the source data file you want to automate;		# Under the '''Tables''' tab, select additional tables or deselect existing 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'''.		# Once all information is complete, click '''OK'''.

Jeff at 02:48, 21 March 2018

2018-03-21T02:48:49Z

← Older revision		Revision as of 21:48, 20 March 2018
Line 1:		Line 1:
			[[File:ManageDataWarehouses.png\|300px\|thumb\|right\|Manage Data Warehouses dialogue]]
	[[File:~~ManageDataWarehouses~~.png\|300px\|thumb\|right\|Manage Data Warehouses dialogue]]		[[File:ODBClink_Data_Warehouse_Logon_Details.png\|300px\|thumb\|right\|Manage Data Warehouses dialogue]]
	[[File:AddDataWarehouse.png\|300px\|thumb\|right\|Edit Data Warehouses dialogue]]		[[File:AddDataWarehouse.png\|300px\|thumb\|right\|Edit Data Warehouses dialogue]]

Nic at 06:34, 27 June 2014

2014-06-27T06:34:03Z

← Older revision		Revision as of 01:34, 27 June 2014
Line 12:		Line 12:

	To fully update 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.		To fully update 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.

			<br clear=all>

	=== Video ===		=== Video ===

Nic at 06:33, 27 June 2014

2014-06-27T06:33:26Z

← Older revision		Revision as of 01:33, 27 June 2014
Line 12:		Line 12:

	To fully update 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.		To fully update 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.

	~~<br clear=all>~~

	=== Video ===		=== Video ===

Nic at 06:33, 27 June 2014

2014-06-27T06:33:03Z

← Older revision		Revision as of 01:33, 27 June 2014
Line 12:		Line 12:

	To fully update 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.		To fully update 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.

			<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>		<br clear=all>

Nic: Created page with " Manage Data Warehouses dialogue Edit Data Warehouses dialogue To edit a..."

2014-05-15T05:46:25Z

New page

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

To edit a data warehouse, follow these steps.

# From the '''Menu''', click on the '''Manage Data Warehouses''' button;
# Select the data warehouse to edit and click the '''Edit Data Warehouse''' button;
# In the '''Edit Data Warehouse''' dialog box that appears, update the necessary settings;
# Under the '''Tables''' tab, select additional tables or deselect existing 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'''.

To fully update 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.

<br clear=all>

== Related Topics ==

* [[Managing Data Warehouses]]
* [[Adding a data warehouse]]
* [[Removing a data warehouse]]