Adding models: Difference between revisions
No edit summary Tag: Manual revert |
No edit summary |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
OdataLink | 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. | |||
| Line 13: | Line 15: | ||
# 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 27: | ||
# 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. | ||
#: '''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). | ||
#: '''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. | ||
# | # If using the '''Live (with archive)''' [[Archive Types|'''archive types''']], you can also configure whether OdataLink polls for changes. | ||
#: ''' | #: '''Turning Polling On''' will allow OdataLink to poll of changes to provide live data in the most optimal manner. | ||
#: ''' | #: Set the '''Sensitivity''' in months to control the date range used when polling. | ||
#: ''' | #: 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]]. | ||
# 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)''. | ||