Adding models - Revision history

Nic at 00:22, 1 May 2026

2026-05-01T00:22:58Z

← Older revision		Revision as of 19:22, 30 April 2026
Line 31:		Line 31:
	#: '''Live''' optimises the model for live use.		#: '''Live''' optimises the model for live use.
	#: '''Live (no archive)''' provides access to data without caching any information (worse performance).		#: '''Live (no archive)''' provides access to data without caching any information (worse performance).
	~~#: '''Developer''' optimises the model for development is faster but refreshes are once every 8 hours~~
	#: '''Static''' optimises the model for historica data that never changes.		#: '''Static''' optimises the model for historica data that never changes.
	# If using the '''Live''' [[Archive Types\|archive types]], you can also configure whether to archive old historical data. You can do so by choosing how the '''Cut Off Date''' is calculated.		# If using the '''Live (with archive)''' [[Archive Types\|'''archive types''']], you can also configure whether to archive old historical data. You can do so by choosing how the '''Cut Off Date''' is calculated.
	#: '''Do not archive data by date''' disables the archiving mechanism except for specific endpoints.		#: '''Do not archive data by date''' disables the archiving mechanism except for specific endpoints.
	#: '''Archive data prior to cut off date''' archives any data created prior to the cut off date entered.		#: '''Archive data prior to cut off date''' archives any data created prior to the cut off date entered.
	#: '''Archive data prior X months''' archives any data created prior to the cut off date calculated from the number of months entered.		#: '''Archive data prior X months''' archives any data created prior to the cut off date calculated from the number of months entered.
	#: '''Archive data prior X days''' archives any data created prior to the cut off date calculated from the number of days entered.		#: '''Archive data prior X days''' archives any data created prior to the cut off date calculated from the number of days entered.
	# ~~Choose~~ the [[Archive ~~Paging~~\|Archive ~~Paging~~]].		# If using the '''Live (with archive)''' [[Archive Types\|'''archive types''']], you can also configure whether OdataLink polls for changes.
	#: '''~~Default~~''': OdataLink will ~~page~~ the ~~date as requested~~.		#: '''Turning Polling On''' will allow OdataLink to poll of changes to provide live data in the most optimal manner.
	#: '''By Month''': OdataLink will page the data one ~~calendar~~ month at a time. This may increase the performance for VERY LARGE data files.		#: Set the '''Sensitivity''' in months to control the date range used when polling.
	#: '''~~By Year~~''': OdataLink will page the data one ~~calendar year~~ at a time. This may increase the performance for LARGE data files.		#: You can also configure OdataLink to force a full refresh every so often. While we do not recommend using this option, it is provided for specific fringe cases.
			#: For more on information on polling, see [[Configure OdataLink to poll for changes]].
			# If using the '''Live (with archive)''' [[Archive Types\|'''archive types''']], you can also turn on the '''Developer''' option.
			#: When the '''Developer''' option is turned on, it informs OdataLink that you are in the midst of building you integration. OdataLink will then only make like calls if the archive data is over 8 hours old.
			# Choose the [[Archive Paging\|'''Page By''']] option.
			#: '''Month''': OdataLink will page the data one month at a time. This may increase the performance for VERY LARGE data files.
			#: '''Quarter''': OdataLink will page the data one quarter at a time. This may increase the performance for LARGE data files.
			#: '''Year''': OdataLink will page the data one calendar year at a time. This option is provided for SMALLER data files.
			#: '''Default''': OdataLink will page the date as requested. This is provided for those that build more complex queries where you do not want OdataLink to page the data by date.
	# Enter a [[Default Date Range]] to control how much data is retrieved.		# Enter a [[Default Date Range]] to control how much data is retrieved.
	#: These dates will apply when no date filters are applied via the [[OData client]].		#: These dates will apply when no date filters are applied via the [[OData client]].

Ash: added best practice statement

2026-03-11T05:45:13Z

added best practice statement

← Older revision		Revision as of 00:45, 11 March 2026
Line 1:		Line 1:
	OdataLink ~~allows you~~ to create as many [[Models\|models]] as required.		For each new report or dashboard, it is best practice to create a separate OdataLink model to manage endpoints, access and availability of the OData Feed.

			Odatalink Admin [[Users\|Admin users]] can create as many [[Models\|models]] as required.

Nic at 04:32, 19 June 2025

2025-06-19T04:32:41Z

Nic at 04:31, 19 June 2025

2025-06-19T04:31:15Z

← Older revision		Revision as of 23:31, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~resize\|1.2em~~\|Security Options}}		#;<br \>{{large\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

Nic at 04:28, 19 June 2025

2025-06-19T04:28:49Z

← Older revision		Revision as of 23:28, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~font-size~~\|~~120%~~\|Security Options}}		#;<br \>{{resize\|1.2em\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

Nic at 04:26, 19 June 2025

2025-06-19T04:26:48Z

← Older revision		Revision as of 23:26, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~largediv~~\|Security Options}}		#;<br \>{{font-size\|120%\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

Nic at 04:24, 19 June 2025

2025-06-19T04:24:44Z

← Older revision		Revision as of 23:24, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~large~~\|Security Options}}		#;<br \>{{largediv\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

Nic at 04:23, 19 June 2025

2025-06-19T04:23:59Z

← Older revision		Revision as of 23:23, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>Security Options		#;<br \>{{large\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

Nic at 04:22, 19 June 2025

2025-06-19T04:22:31Z

← Older revision		Revision as of 23:22, 18 June 2025
Line 13:		Line 13:
	# Override the '''Model Code''' if required.		# Override the '''Model Code''' if required.
	#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]]. If you decide to change it, note that it must be at most 20 characters long. Only letters, numbers dashes and spaces are allowed.		#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]]. If you decide to change it, note that it must be at most 20 characters long. Only letters, numbers dashes and spaces are allowed.
			#;<br \>Data File Options
	# Choose the [[Model Type\|Data File Type]] to which this model will connect.		# Choose the [[Model Type\|Data File Type]] to which this model will connect.
			#Tick/untick the '''Consolidation Allowed''' checkbox;
			#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
			#;<br \>Security Options
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.
	#: '''Anonymous''' will not require any credentials when accessing data.		#: '''Anonymous''' will not require any credentials when accessing data.
			# Tick/untick the '''Firewall Enabled''' checkbox;
			#: Controls whether the Firewall is active and protecting your data via a list of authorised [[IP Addresses]].
			# Tick/untick the '''Enabled''' checkbox;
			#: Controls whether all [[OData Feed URLs\|OData feed urls]] for this [[Models\|model]] are usable.
			#;<br \>Performance Options
	# Choose the [[Archive Types\|Archive Type]].		# Choose the [[Archive Types\|Archive Type]].
	#: '''Live''' optimises the model to ~~retrieve live~~ data.		#: '''Live''' optimises the model for live use.
	#: '''Developer''' optimises the model ~~when developing~~ to not ~~connect with your~~ data ~~file as often~~.		#: '''Live (no archive)''' provides access to data without caching any information (worse performance).
	#: '''~~Static~~''' ~~makes~~ the ~~model only return cached~~ data ~~without connecting~~ to ~~your~~ data ~~file~~.		#: '''Developer''' optimises the model for development is faster but refreshes are once every 8 hours
	# ~~Enter a~~ '''Default ~~Start Date~~''' ~~and~~ '''~~End Date~~''' to control how much data is retrieved.		#: '''Static''' optimises the model for historica data that never changes.
			# If using the '''Live''' [[Archive Types\|archive types]], you can also configure whether to archive old historical data. You can do so by choosing how the '''Cut Off Date''' is calculated.
			#: '''Do not archive data by date''' disables the archiving mechanism except for specific endpoints.
			#: '''Archive data prior to cut off date''' archives any data created prior to the cut off date entered.
			#: '''Archive data prior X months''' archives any data created prior to the cut off date calculated from the number of months entered.
			#: '''Archive data prior X days''' archives any data created prior to the cut off date calculated from the number of days entered.
			# Choose the [[Archive Paging\|Archive Paging]].
			#: '''Default''': OdataLink will page the date as requested.
			#: '''By Month''': OdataLink will page the data one calendar month at a time. This may increase the performance for VERY LARGE data files.
			#: '''By Year''': OdataLink will page the data one calendar year at a time. This may increase the performance for LARGE data files.
			# Enter a [[Default Date Range]] to control how much data is retrieved.
	#: These dates will apply when no date filters are applied via the [[OData client]].		#: These dates will apply when no date filters are applied via the [[OData client]].
	# ~~Ensure~~ the ~~'''Settings Endpoints Allowed''' is unticked unless required~~.		# If applicable, enter the [[Default Page Size]].
	#: ~~See [[Settings Endpoints]]~~ for ~~more information~~.		#: This controls the number of records that will be returned on a single call for most endpoints^.
	# ~~Ensure~~ the ~~'''Firewall Enabled''' is ticked~~.		#;<br \>Miscellaneous Options
	# ~~Ensure the ''~~'~~Enabled~~''' ~~checkbox is ticked~~.		# Choose the [[OData Client Compatibility\|OData Client Compatibility]] option required.
			#: We recommend leaving this setting as ''(Auto Detect)''.
	# Click '''Create Model'''		# Click '''Create Model'''

Nic at 22:03, 3 February 2022

2022-02-03T22:03:45Z

← Older revision		Revision as of 17:03, 3 February 2022
Line 12:		Line 12:
	#: OdataLink will automatically generate a model code.		#: OdataLink will automatically generate a model code.
	# Override the '''Model Code''' if required.		# Override the '''Model Code''' if required.
	#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]].		#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]]. If you decide to change it, note that it must be at most 20 characters long. Only letters, numbers dashes and spaces are allowed.
	# Choose the [[Model Type\|Data File Type]] to which this model will connect.		# Choose the [[Model Type\|Data File Type]] to which this model will connect.
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.

← Older revision		Revision as of 23:31, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~resize\|1.2em~~\|Security Options}}		#;<br \>{{large\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

← Older revision		Revision as of 23:28, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~font-size~~\|~~120%~~\|Security Options}}		#;<br \>{{resize\|1.2em\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

← Older revision		Revision as of 23:26, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~largediv~~\|Security Options}}		#;<br \>{{font-size\|120%\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

← Older revision		Revision as of 23:24, 18 June 2025
Line 17:		Line 17:
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
	#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.		#: This option controls whether the [[Consolidation OData Feed\|Consolidation OData feed]] is available or not.
	#;<br \>{{~~large~~\|Security Options}}		#;<br \>{{largediv\|Security Options}}
	# Choose the [[Login Types\|Login Type]] required to access the data.		# Choose the [[Login Types\|Login Type]] required to access the data.
	#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.		#: '''Basic''' login will require the username and password of a [[Users\|user]] when accessing data.

← Older revision		Revision as of 23:32, 18 June 2025
Line 13:		Line 13:
	# Override the '''Model Code''' if required.		# Override the '''Model Code''' if required.
	#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]]. If you decide to change it, note that it must be at most 20 characters long. Only letters, numbers dashes and spaces are allowed.		#: The ''secret'' code which will form part of the [[OData Feed URLs\|OData feed url]]. It must be unique for your [[Account\|account]]. If you decide to change it, note that it must be at most 20 characters long. Only letters, numbers dashes and spaces are allowed.
	#;<br \>Data File Options		#;<br \>{{large\|Data File Options}}
	# Choose the [[Model Type\|Data File Type]] to which this model will connect.		# Choose the [[Model Type\|Data File Type]] to which this model will connect.
	#Tick/untick the '''Consolidation Allowed''' checkbox;		#Tick/untick the '''Consolidation Allowed''' checkbox;
Line 25:		Line 25:
	# Tick/untick the '''Enabled''' checkbox;		# Tick/untick the '''Enabled''' checkbox;
	#: Controls whether all [[OData Feed URLs\|OData feed urls]] for this [[Models\|model]] are usable.		#: Controls whether all [[OData Feed URLs\|OData feed urls]] for this [[Models\|model]] are usable.
	#;<br \>Performance Options		#;<br \>{{large\|Performance Options}}
	# Choose the [[Archive Types\|Archive Type]].		# Choose the [[Archive Types\|Archive Type]].
	#: '''Live''' optimises the model for live use.		#: '''Live''' optimises the model for live use.
Line 44:		Line 44:
	# If applicable, enter the [[Default Page Size]].		# If applicable, enter the [[Default Page Size]].
	#: This controls the number of records that will be returned on a single call for most endpoints^.		#: This controls the number of records that will be returned on a single call for most endpoints^.
	#;<br \>Miscellaneous Options		#;<br \>{{large\|Miscellaneous Options}}
	# Choose the [[OData Client Compatibility\|OData Client Compatibility]] option required.		# Choose the [[OData Client Compatibility\|OData Client Compatibility]] option required.
	#: We recommend leaving this setting as ''(Auto Detect)''.		#: We recommend leaving this setting as ''(Auto Detect)''.