---
title: "Release notes of Data Cache"
description: "What changed in the drivers of Invantive UniversalSQL per release: tables, columns, attributes and capabilities, and what to change in statements and connection strings."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/drivers?driver=data-cache
---

# Release notes of Data Cache

**Drivers:** [ActiveCampaign](/en/release-notes/drivers.md?driver=activecampaign&driver=data-cache) | [Autotask](/en/release-notes/drivers.md?driver=autotask&driver=data-cache) | [Bouw7](/en/release-notes/drivers.md?driver=bouw7&driver=data-cache) | [Brevo](/en/release-notes/drivers.md?driver=brevo&driver=data-cache) | [Calendly](/en/release-notes/drivers.md?driver=calendly&driver=data-cache) | [CBS](/en/release-notes/drivers.md?driver=cbs&driver=data-cache) | [Chargebee](/en/release-notes/drivers.md?driver=chargebee&driver=data-cache) | [CompanyInfo](/en/release-notes/drivers.md?driver=companyinfo&driver=data-cache) | [Conversion](/en/release-notes/drivers.md?driver=conversion&driver=data-cache) | [Crisp](/en/release-notes/drivers.md?driver=crisp&driver=data-cache) | **[Data Cache](/en/release-notes/drivers.md)** (chosen) | [Data Dictionary](/en/release-notes/drivers.md?driver=data-cache&driver=data-dictionary) | [Discourse](/en/release-notes/drivers.md?driver=data-cache&driver=discourse) | [Dummy](/en/release-notes/drivers.md?driver=data-cache&driver=dummy) | [Easyflex](/en/release-notes/drivers.md?driver=data-cache&driver=easyflex) | [ECB Exchange Rates](/en/release-notes/drivers.md?driver=data-cache&driver=ecb-exchange-rates) | [Exact Online](/en/release-notes/drivers.md?driver=data-cache&driver=exact-online) | [Fortnox](/en/release-notes/drivers.md?driver=data-cache&driver=fortnox) | [Freshdesk](/en/release-notes/drivers.md?driver=data-cache&driver=freshdesk) | [Freshservice](/en/release-notes/drivers.md?driver=data-cache&driver=freshservice) | [Gripp CRM](/en/release-notes/drivers.md?driver=data-cache&driver=gripp-crm) | [Horeko](/en/release-notes/drivers.md?driver=data-cache&driver=horeko) | [HubSpot](/en/release-notes/drivers.md?driver=data-cache&driver=hubspot) | [In-Memory Storage](/en/release-notes/drivers.md?driver=data-cache&driver=in-memory-storage) | [ionBIZ](/en/release-notes/drivers.md?driver=data-cache&driver=ionbiz) | [Kadaster](/en/release-notes/drivers.md?driver=data-cache&driver=kadaster) | [KeePass](/en/release-notes/drivers.md?driver=data-cache&driver=keepass) | [Knack](/en/release-notes/drivers.md?driver=data-cache&driver=knack) | [KOOP (NL) BWB](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-bwb) | [KOOP (NL) CVDR](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-cvdr) | [KOOP (NL) Europese Richtlijnen](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-europese-richtlijnen) | [KOOP (NL) Officiele Publicaties](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-officiele-publicaties) | [KOOP (NL) PLOOI](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-plooi) | [KOOP (NL) PUC Open Data](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-puc-open-data) | [KOOP (NL) Samenwerkende Catalogi](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-samenwerkende-catalogi) | [KOOP (NL) Staatsalmanak](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-staatsalmanak) | [KOOP (NL) Staten Generaal Digitaal](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-staten-generaal-digitaal) | [KOOP (NL) Tuchtrecht](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-tuchtrecht) | [KOOP (NL) Verdragenbank](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-verdragenbank) | [KOOP (NL) Wetgevingskader](/en/release-notes/drivers.md?driver=data-cache&driver=koop-nl-wetgevingskader) | [Localazy](/en/release-notes/drivers.md?driver=data-cache&driver=localazy) | [LogiusCor](/en/release-notes/drivers.md?driver=data-cache&driver=logiuscor) | [Loket.nl REST](/en/release-notes/drivers.md?driver=data-cache&driver=loket-nl-rest) | [Mail](/en/release-notes/drivers.md?driver=data-cache&driver=mail) | [Minox](/en/release-notes/drivers.md?driver=data-cache&driver=minox) | [Mollie](/en/release-notes/drivers.md?driver=data-cache&driver=mollie) | [Nmbrs](/en/release-notes/drivers.md?driver=data-cache&driver=nmbrs) | [Odoo](/en/release-notes/drivers.md?driver=data-cache&driver=odoo) | [Open Exchange Rates](/en/release-notes/drivers.md?driver=data-cache&driver=open-exchange-rates) | [OpenArch](/en/release-notes/drivers.md?driver=data-cache&driver=openarch) | [OpenSpending](/en/release-notes/drivers.md?driver=data-cache&driver=openspending) | [OS](/en/release-notes/drivers.md?driver=data-cache&driver=os) | [Outlook](/en/release-notes/drivers.md?driver=data-cache&driver=outlook) | [Postman](/en/release-notes/drivers.md?driver=data-cache&driver=postman) | [RDW](/en/release-notes/drivers.md?driver=data-cache&driver=rdw) | [ROBAWS](/en/release-notes/drivers.md?driver=data-cache&driver=robaws) | [Roller](/en/release-notes/drivers.md?driver=data-cache&driver=roller) | [Simplicate](/en/release-notes/drivers.md?driver=data-cache&driver=simplicate) | [SnelStart](/en/release-notes/drivers.md?driver=data-cache&driver=snelstart) | [Teamleader Focus](/en/release-notes/drivers.md?driver=data-cache&driver=teamleader-focus) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=data-cache&driver=teamleaderorbit) | [Teamleader Orbit](/en/release-notes/drivers.md?driver=data-cache&driver=teamleader-orbit) | [Tixly](/en/release-notes/drivers.md?driver=data-cache&driver=tixly) | [Tweede Kamer](/en/release-notes/drivers.md?driver=data-cache&driver=tweede-kamer) | [Tweede Kamer NL](/en/release-notes/drivers.md?driver=data-cache&driver=tweede-kamer-nl) | [Twinfield](/en/release-notes/drivers.md?driver=data-cache&driver=twinfield) | [Visma Severa](/en/release-notes/drivers.md?driver=data-cache&driver=visma-severa) | [Visma.net Financials](/en/release-notes/drivers.md?driver=data-cache&driver=visma-net-financials) | [Visual FoxPro](/en/release-notes/drivers.md?driver=data-cache&driver=visual-foxpro) | [Wikipedia](/en/release-notes/drivers.md?driver=data-cache&driver=wikipedia) | [Yuki](/en/release-notes/drivers.md?driver=data-cache&driver=yuki)

**Releases:** [26.0 to 27.0](/en/release-notes/drivers.md?driver=data-cache&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/drivers.md?driver=data-cache&step=new-in-27.0)

<div class="rn-block" id="data-cache-26.0-to-27.0">

<div class="rn-head">

Driver Release Note - Internal

## Data Cache driver 27.0, from 26.0

| Build | Date | Description |
|---|---|---|
| `26.0.4` | 22-03-2026 | first build of release 26.0 |
| `27.0.93` | 10-11-2026 | latest build of release 27.0 at the time of writing |

The older end is the first build of release 26.0, not its last, because later builds of 26.0 received ports of changes made for 27.0. The data model of a release is the model that a later build of the same release generated.

- **12** changes
- **1** can break a statement
- **3** groups not available

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [By Group](#data-cache-26.0-to-27.0-groups)
- [Before You Upgrade](#data-cache-26.0-to-27.0-before)
- [Top 12 Changes](#data-cache-26.0-to-27.0-top)

**Groups**

- [Data model](#data-cache-26.0-to-27.0-g-data_model)
- [Provider attributes](#data-cache-26.0-to-27.0-g-provider_attributes)
- [Capabilities](#data-cache-26.0-to-27.0-g-capabilities)
- [Performance](#data-cache-26.0-to-27.0-g-performance) 3
- [Bug fixes](#data-cache-26.0-to-27.0-g-bug_fixes) 5
- [Enhancements](#data-cache-26.0-to-27.0-g-enhancements) 2
- [Log-on and platform](#data-cache-26.0-to-27.0-g-authentication_platform) 2

**More**

- [More Information](#data-cache-26.0-to-27.0-more)

</div>

<div class="rn-main">

<a id="data-cache-26.0-to-27.0-groups"></a>

### What Changed, by Group

Every change is in one group: the group answers the question that you ask before you upgrade.

<div class="rn-cards">

- [Data model](#data-cache-26.0-to-27.0-g-data_model)
  - &ndash;
  - *not available*
  - Do my statements and views still work?
- [Provider attributes](#data-cache-26.0-to-27.0-g-provider_attributes)
  - &ndash;
  - *not available*
  - Do I have to change my connection string, provider file or settings?
- [Capabilities](#data-cache-26.0-to-27.0-g-capabilities)
  - &ndash;
  - *not available*
  - What can the driver do with a table?
- [Performance](#data-cache-26.0-to-27.0-g-performance)
  - 3
  - Is it faster, and does it call the platform less?
- [Bug fixes](#data-cache-26.0-to-27.0-g-bug_fixes)
  - 5
  - Is the defect that I met repaired?
- [Enhancements](#data-cache-26.0-to-27.0-g-enhancements)
  - 2
  - What can I do now that I could not?
- [Log-on and platform](#data-cache-26.0-to-27.0-g-authentication_platform)
  - 2
  - **1 can break a statement**
  - Do I have to log on again, or change something because of the platform?

</div>

[Download Changes as CSV](/en/release-notes/drivers/data-cache/26.0-to-27.0.csv) | [Data Model of Data Cache](/en/datamodels/invantivedatareplicator)

<div class="rn-before" id="data-cache-26.0-to-27.0-before">

### Before You Upgrade

The data models of this step could not be compared, so changes of tables and columns that break a statement are not known. The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

These changes can stop an existing statement, view, connection string or script from working:

- [Oracle Legacy no longer supported as backing database](#IDC-27.0-L001)
  - Change the backing provider of the Data Cache or Data Replicator from the legacy Oracle provider to the Oracle managed provider.

</div>

<a id="data-cache-26.0-to-27.0-top"></a>

### Top 12 Changes

Changes that can break a statement first, then by importance. Columns are summarised per table in the data model.

<div class="rn-top">

1. [Oracle Legacy no longer supported as backing database](#IDC-27.0-L001)
   - *Log-on and platform*
   - Breaks an existing statement or script.
2. [Faster initial load: tables load in parallel, limited by the backing database](#IDC-27.0-P001)
   - *Performance*
   - Importance 3 of 5.
3. [Data Replicator error on the backing connection string repaired; events logged in UTC](#IDC-27.0-B001)
   - *Bug fixes*
   - Importance 3 of 5.
4. [Cancellation of a running synchronisation and download of messages](#IDC-27.0-E001)
   - *Enhancements*
   - Importance 3 of 5.
5. [Removal of forced garbage collection after replication](#IDC-27.0-P002)
   - *Performance*
   - Importance 2 of 5.
6. [Smaller and faster cache files by compressing with Zstandard instead of gzip](#IDC-27.0-P003)
   - *Performance*
   - Importance 2 of 5.
7. [Fewer null reference errors when metadata or settings are missing](#IDC-27.0-B002)
   - *Bug fixes*
   - Importance 2 of 5.
8. [Messages with an action longer than one character no longer block a batch](#IDC-27.0-B003)
   - *Bug fixes*
   - Importance 2 of 5.
9. [Refusal of a number of table partition versions per delete below 1](#IDC-27.0-B004)
   - *Bug fixes*
   - Importance 2 of 5.
10. [Session heart beat uses the right column for the process owner](#IDC-27.0-B005)
    - *Bug fixes*
    - Importance 2 of 5.
11. [Backing database version and service tier are checked by the database drivers](#IDC-27.0-L002)
    - *Log-on and platform*
    - Importance 2 of 5.
12. [Short names for three connection attributes and a folder selector for the cache folder](#IDC-27.0-E002)
    - *Enhancements*
    - Importance 1 of 5.

</div>

<a id="data-cache-26.0-to-27.0-g-data_model"></a>

### Data model

Do my statements and views still work? Tables, views, table functions, columns, parameters, keys, code values, packages and procedures that appear, disappear, are renamed or change type.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="data-cache-26.0-to-27.0-g-provider_attributes"></a>

### Provider attributes

Do I have to change my connection string, provider file or settings? Attributes of the connection and settings of the driver that appear, disappear or change default or place where they can be set.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="data-cache-26.0-to-27.0-g-capabilities"></a>

### Capabilities

What can the driver do with a table? Whether a table or table function can be selected from, inserted into, updated and deleted from.

> **Not available.** The data model of this driver comes from build 22.1.262-BETA+4120 in the 26.0 workspace and from build 22.1.262-BETA+4120 in the 27.0 workspace; the groups from model files need a model that a build of each release generated, and generating it needs an account that is not at hand.

<a id="data-cache-26.0-to-27.0-g-performance"></a>

### Performance

Is it faster, and does it call the platform less? Paging, batching, caching, filters and projections sent to the platform, fewer requests, less memory.

<div class="rn-chips">

- 3 changes
- commits

</div>

<div class="rn-item" id="IDC-27.0-P001">

##### Faster initial load: tables load in parallel, limited by the backing database

The initial load now loads several tables at the same time, each on its own thread and in random order, up to the limit of the backing database and at most 32. A setting for the maximum number of parallel refreshes remains available.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-P002">

##### Removal of forced garbage collection after replication

The cache no longer forces a full memory clean-up after replication. The three settings that controlled this (memory load threshold, replication interval, minimum interval) are no longer offered.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-P003">

##### Smaller and faster cache files by compressing with Zstandard instead of gzip

Result sets stored in the disk cache are compressed with a faster method that gives smaller files. The cache is rebuilt where needed.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="data-cache-26.0-to-27.0-g-bug_fixes"></a>

### Bug fixes

Is the defect that I met repaired? Wrong or missing rows, wrong values, crashes and wrong messages, repaired in a release line that had the defect.

<div class="rn-chips">

- 5 changes
- commits

</div>

<div class="rn-item" id="IDC-27.0-B001">

##### Data Replicator error on the backing connection string repaired; events logged in UTC

The anonymised form of the backing connection string was reloaded before the connection was opened, which led to an error on the Data Replicator. It is now set after opening. Start times of events in the event log are now written in UTC instead of local time.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-B002">

##### Fewer null reference errors when metadata or settings are missing

Several places that assumed that settings, table function parameters or version information exist now check for this first and fail with a normal error or skip the item.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-B003">

##### Messages with an action longer than one character no longer block a batch

The action of incoming messages is stored in a column of one character. The value is now converted to that character and left empty when it is missing or longer, instead of failing the whole batch.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-B004">

##### Refusal of a number of table partition versions per delete below 1

The setting for the number of table partition versions per delete of facts is rejected when it is below 1, with a message and a hint. A value of 0 left the delete loop without progress.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-B005">

##### Session heart beat uses the right column for the process owner

The column for the process owner was addressed under a name without underscore, which does not match the repository column process_owner. The session registration now uses the correct name.

<div class="rn-chips">

- importance 2
- confidence medium

</div>

</div>

<a id="data-cache-26.0-to-27.0-g-enhancements"></a>

### Enhancements

What can I do now that I could not? New functions and options that are not a table or a column.

<div class="rn-chips">

- 2 changes
- commits

</div>

<div class="rn-item" id="IDC-27.0-E001">

##### Cancellation of a running synchronisation and download of messages

Long running synchronisation, the download of incoming messages, the delete of forwarded messages and compression of facts now check for cancellation, so a statement can be stopped.

<div class="rn-chips">

- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-E002">

##### Short names for three connection attributes and a folder selector for the cache folder

The attributes for the maximum length of logical view names and column names and the purge interval of the event log have shorter names. The old names remain accepted. The cache folder attribute is marked as a directory.

<div class="rn-chips">

- importance 1
- confidence high

</div>

</div>

<a id="data-cache-26.0-to-27.0-g-authentication_platform"></a>

### Log-on and platform

Do I have to log on again, or change something because of the platform? Log-on and token handling, scopes and permissions, a new version of the platform API, retired endpoints and changed limits.

<div class="rn-chips">

- 2 changes
- commits

</div>

<div class="rn-item" id="IDC-27.0-L001">

##### Oracle Legacy no longer supported as backing database

The Data Cache cannot use the legacy Oracle provider as backing database any more. The Oracle provider for managed code is supported.

<div class="rn-action">

**What to Do**

Change the backing provider of the Data Cache or Data Replicator from the legacy Oracle provider to the Oracle managed provider.

</div>

<div class="rn-chips">

- **can break a statement**
- importance 3
- confidence medium

</div>

</div>

<div class="rn-item" id="IDC-27.0-L002">

##### Backing database version and service tier are checked by the database drivers

The Data Cache asks the driver of the backing database whether it is supported as host of the cache, including its minimum version and for Azure its service tier.

<div class="rn-chips">

- importance 2
- confidence low

</div>

</div>

<a id="data-cache-26.0-to-27.0-more"></a>

### More Information

- [Data model documentation of the driver](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/invantive-data-replicator)
- [Documentation of the platform](https://documentation.invantive.com/2017R2/data-cache-data-model/webhelp/index.html)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- 166 lines removed from DataCacheProvider.cs and CheckSupportedAsDataCacheBackingDatabase added in AnsiSqlProviderBase, SqlServer, Oracle, MySql, PostgreSql providers (other directories). Subject says "Add checks"; whether thresholds are stricter than 26.0 was not compared.
- Commit items were classified by one reader; the model changes are derived and need no reading.
- Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
- Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
- A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
- 17 links between a change and a source commit are recorded.
- 4 exclusions are recorded in the audit of the note.

</div>

</div>

</div>

</div>

