Archive Types: Difference between revisions

From OdataLink
Jump to navigation Jump to search
No edit summary
No edit summary
 
(12 intermediate revisions by 3 users not shown)
Line 1: Line 1:
== Overview ==  
== Overview ==  


To speed up the time it takes to refresh data, OdataLink's models include an archive. You can control how the archive works by changing the '''Archive Type''' option.
While a super strength of OdataLink is the ability to pull live data, it can come with a performance cost. To mitigate that, OdataLink can archive data in our servers which returns data faster than from the live source. OdataLink has different options for caching depending on your situation. You can control how the archive works by changing the '''Archive Type''' option.


The possible values are:
The possible values are:
* Live
* Live (with Archive)
* Live (no archive)
* Live (no archive)
* Developer
* Static
* Static




=== Live ===
=== Live (with Archive) ===


When the '''Archive Type''' is set to '''Live''', OdataLink will serve data directly from your [[Data Files!data file]].
When the '''Archive Type''' is set to '''Live (with Archive)''', OdataLink will serve data directly from your [[Data Files|data file]].


This is the preferred option once you have finished building your reports and development is complete.
This is the preferred option once you have finished building your reports and development is complete.


Some endpoints which cannot be edited, such as [[Xero Accounting Endpoint: JournalsAccrual]] and [[Xero Accounting Endpoint: JournalsCash]] will get cached in an encrypted archive to speed up refreshes. This only applies to endpoints whose data never changes.
Some endpoints which cannot be edited, such as [[Xero Accounting Endpoint: JournalsAccrual|JournalsAccrual]] and [[Xero Accounting Endpoint: JournalsCash|JournalsCash]] will get cached in an encrypted archive to speed up refreshes. This only applies to endpoints whose data never changes.


It is also possible to configure a '''Cut Off Date''' which will instruct OdataLink to archive all data prior to this date. This increases the performance when pulling large amounts of historical data. The Cut Off Date can either be entered directly, or calculated from number of months or days prior to today.
[[File:archive_cut_off.png|thumb|right|400px|Archive Data Cut Off Date]]
The following options are available to configure the '''Cut Off Date''' for Archiving:


=== Live (no archive) ===
;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.


When the '''Archive Type''' is set to '''Live (no archive)''', OdataLink will serve data directly from your [[Data Files!data file]].
It is also possible to configure it so that OdataLink '''polls for changes'''. For more on polling, see [[Configure OdataLink to poll for changes]].


This is option is only recommend for those that need maximum security. It does come at the cost that some endpoints will be particularly slow.
It may also be important to configure the [[Archive Paging]] option, which can force paging by month or year.




=== Developer ===
=== Live (no archive) ===


When the '''Archive Type''' is set to '''Developer''', OdataLink will be optimised for developing reports. In this mode, Live data will only be served once every 8 hours. If a refresh takes place within 8 hours of the last refresh, it will instead served cached data stored in an encrypted archive.
When the '''Archive Type''' is set to '''Live (no archive)''', OdataLink will serve data directly from your [[Data Files|data file]].
The benefit is that it makes refreshes faster but at the cost of not always retrieving the latest data.  


This is the default when creating a model.
This is option is only recommended for those that need maximum security. It does come at the cost that some endpoints will be particularly slow.
 
This is the preferred option when building reports. It should be changed to '''Live''' or '''Live (no archive)''' once development is complete.




Line 43: Line 48:
This option is mostly used for data that never changes such as historical data.
This option is mostly used for data that never changes such as historical data.


== Change Logs ==
:'''2026-05-01'''
:The '''Developer''' archive type has been phased out in favour of a '''Developer Option''' can be turned on as part of the '''Live (with archive)''' archive type. This was done to simplify the archive type and allow you to toggle the developer setting without losing other configuration options.


== Related ==
== Related ==


[[Switch Models Archive Type from Developer to Live]]
[[Changing a model's Archive Type from Developer to Live]]


[[Editing a model's details]]
[[Editing a model's details]]

Latest revision as of 19:20, 30 April 2026

Overview

While a super strength of OdataLink is the ability to pull live data, it can come with a performance cost. To mitigate that, OdataLink can archive data in our servers which returns data faster than from the live source. OdataLink has different options for caching depending on your situation. You can control how the archive works by changing the Archive Type option.

The possible values are:

  • Live (with Archive)
  • Live (no archive)
  • Static


Live (with Archive)

When the Archive Type is set to Live (with Archive), OdataLink will serve data directly from your data file.

This is the preferred option once you have finished building your reports and development is complete.

Some endpoints which cannot be edited, such as JournalsAccrual and JournalsCash will get cached in an encrypted archive to speed up refreshes. This only applies to endpoints whose data never changes.

It is also possible to configure a Cut Off Date which will instruct OdataLink to archive all data prior to this date. This increases the performance when pulling large amounts of historical data. The Cut Off Date can either be entered directly, or calculated from number of months or days prior to today.

Archive Data Cut Off Date

The following options are available to configure the Cut Off Date for Archiving:

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.

It is also possible to configure it so that OdataLink polls for changes. For more on polling, see Configure OdataLink to poll for changes.

It may also be important to configure the Archive Paging option, which can force paging by month or year.


Live (no archive)

When the Archive Type is set to Live (no archive), OdataLink will serve data directly from your data file.

This is option is only recommended for those that need maximum security. It does come at the cost that some endpoints will be particularly slow.


Static

When the Archive Type is set to Static, OdataLink will only query data from your data file once.

This option is mostly used for data that never changes such as historical data.


Change Logs

2026-05-01
The Developer archive type has been phased out in favour of a Developer Option can be turned on as part of the Live (with archive) archive type. This was done to simplify the archive type and allow you to toggle the developer setting without losing other configuration options.

Related

Changing a model's Archive Type from Developer to Live

Editing a model's details