---
title: "Release notes of Invantive Cloud"
description: "The enhancements and bug fixes of the Invantive products per release, with what to check before upgrading."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/products?product=invantive-cloud&platform=In-memory
---

# Release notes of Invantive Cloud

**Products:** [Invantive Authenticator](/en/release-notes/products.md?product=invantive-authenticator&product=invantive-cloud&platform=In-memory) | [Invantive Bridge](/en/release-notes/products.md?product=invantive-bridge&product=invantive-cloud&platform=In-memory) | [Invantive Bridge Online](/en/release-notes/products.md?product=invantive-bridge-online&product=invantive-cloud&platform=In-memory) | [Invantive Bridge Online Samples](/en/release-notes/products.md?product=invantive-bridge-online-samples&product=invantive-cloud&platform=In-memory) | [Invantive Business for Windows](/en/release-notes/products.md?product=invantive-business-for-windows&product=invantive-cloud&platform=In-memory) | [Invantive Business Server](/en/release-notes/products.md?product=invantive-business-server&product=invantive-cloud&platform=In-memory) | **[Invantive Cloud](/en/release-notes/products.md?platform=In-memory)** (chosen) | [Invantive Connect](/en/release-notes/products.md?product=invantive-cloud&product=invantive-connect&platform=In-memory) | [Invantive Control for Excel](/en/release-notes/products.md?product=invantive-cloud&product=invantive-control-for-excel&platform=In-memory) | [Invantive Data Access Point](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-access-point&platform=In-memory) | [Invantive Data Hub](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-hub&platform=In-memory) | [Invantive Data Loader](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-loader&platform=In-memory) | [Invantive Estate for Windows](/en/release-notes/products.md?product=invantive-cloud&product=invantive-estate-for-windows&platform=In-memory) | [Invantive MCP Server](/en/release-notes/products.md?product=invantive-cloud&product=invantive-mcp-server&platform=In-memory) | [Invantive Optimizer](/en/release-notes/products.md?product=invantive-cloud&product=invantive-optimizer&platform=In-memory) | [Invantive Query Tool for Windows](/en/release-notes/products.md?product=invantive-cloud&product=invantive-query-tool&platform=In-memory) | [Invantive Query Tool Multi-Platform](/en/release-notes/products.md?product=invantive-cloud&product=invantive-query-tool-multi-platform&platform=In-memory) | [Invantive Runtime](/en/release-notes/products.md?product=invantive-cloud&product=invantive-runtime&platform=In-memory) | [Invantive Studio](/en/release-notes/products.md?product=invantive-cloud&product=invantive-studio&platform=In-memory) | [Invantive Support Assistant](/en/release-notes/products.md?product=invantive-cloud&product=invantive-support-assistant&platform=In-memory) | [Invantive UniversalSQL Server](/en/release-notes/products.md?product=invantive-cloud&product=invantive-universalsql-server&platform=In-memory)

**Releases:** [26.0 to 27.0](/en/release-notes/products.md?product=invantive-cloud&step=26.0-to-27.0&platform=In-memory) | [new in 27.0](/en/release-notes/products.md?product=invantive-cloud&step=new-in-27.0&platform=In-memory) | [25.0 to 26.0](/en/release-notes/products.md?product=invantive-cloud&step=25.0-to-26.0&platform=In-memory)

<div class="rn-block" id="invantive-cloud-26.0-to-27.0">

<div class="rn-head">

Release Note - Hosted

## Invantive Cloud 27.0, from 26.0

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

The older state is the first build of release 26.0, not its last: later builds of 26.0 received ports of changes made for 27.0, so those changes are part of this step. The 27.0 line also contains the beta builds 26.1.x.

- **286** enhancements
- **180** bug fixes
- **10** things to check before upgrading

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [Before You Upgrade](#invantive-cloud-26.0-to-27.0-before)
- [Top 25 Changes](#invantive-cloud-26.0-to-27.0-top)
- [All Enhancements](#invantive-cloud-26.0-to-27.0-new) 1
- [All Bug Fixes](#invantive-cloud-26.0-to-27.0-fixed) 1
- [What It Builds On](#invantive-cloud-26.0-to-27.0-builds)
- [More Information](#invantive-cloud-26.0-to-27.0-more)

**Enhancements**

- [Performance](#invantive-cloud-26.0-to-27.0-e-performance) 1

**Bug Fixes**

- [SQL engine](#invantive-cloud-26.0-to-27.0-b-sql-engine) 1

</div>

<div class="rn-main">

<div class="rn-before" id="invantive-cloud-26.0-to-27.0-before">

### Before You Upgrade

These changes ask for a check:

- [Settings files move from XML to JSON](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E001)
  - Settings files are converted from XML to JSON when they are read. From 27.0 the JSON file takes precedence and the XML file is removed in release 28.0: edit the JSON file from now on and keep a copy of the XML file until then.
- [Exact Online companies outside the service area are no longer accepted](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E008)
  - Companies in countries outside the service area are no longer available in Exact Online.
- [QR code functions take one size value instead of width and height](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E013)
  - Adjust statements that call the QR code functions with a separate width and height.
- [Integer constants in SQL keep an integer type](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E054)
  - Check expressions that rely on whole numbers being decimal; the data type of the result can differ.
- [Gripp CRM tables now have a schema name](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E069)
  - Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.
- [Row count variable is empty before the first statement](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E152)
  - Check scripts that compare the row count of the previous statement with zero before the first statement.
- [Duration columns in system views have a decimal type and more precise values](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E144)
  - Check queries that expect whole numbers in the duration columns of the session and execution views.
- [Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E018)
  - Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.
- [Loading of provider assemblies from a settings file is blocked](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E011)
  - A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.
- [Data Cache no longer runs forced garbage collection; three settings removed](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E095)
  - Remove the three garbage-collection settings of the Data Cache driver from settings files.

</div>

<a id="invantive-cloud-26.0-to-27.0-top"></a>

### Top 25 Changes

<div class="rn-top">

1. [Settings files move from XML to JSON](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E001)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
2. [More work is sent to the platform: row limit, grouping, selected columns and joins](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E005)
   - *Enhancement*
   - A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.
3. [Joins return the correct rows](/en/release-notes/products?product=invantive-cloud#CLD-27.0-B001)
   - *Bug Fix*
   - A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.
4. [Correlated subqueries are supported](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E002)
   - *Enhancement*
   - A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.
5. [DeepL driver](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E004)
   - *Enhancement*
   - A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
6. [Parts of a PSQL block can run in parallel](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E003)
   - *Enhancement*
   - PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.
7. [Exact Online companies outside the service area are no longer accepted](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E008)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
8. [Loading of provider assemblies from a settings file is blocked](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E011)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
9. [Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E018)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
10. [QR code functions take one size value instead of width and height](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E013)
    - *Enhancement*
    - **action needed**
    - Action needed before or after the upgrade.
11. [Data containers and credentials from Invantive Credentials Server](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E007)
    - *Enhancement*
    - A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.
12. [Data is loaded in the background while a session is idle](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E023)
    - *Enhancement*
    - A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.
13. [New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E016)
    - *Enhancement*
    - Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.
14. [Invantive License Service: clearer messages, grace period and new modules](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E009)
    - *Enhancement*
    - A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.
15. [Big Data JSON reads files much faster and skips files that cannot match](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E022)
    - *Enhancement*
    - Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.
16. [Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E021)
    - *Enhancement*
    - The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.
17. [Exact Online incremental tables reload less often and are read faster](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E024)
    - *Enhancement*
    - Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
18. [Support filtering and sorting of the OData model used by MCP](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E019)
    - *Enhancement*
    - The OData data model that is built for MCP supports filtering and ordering, and carries annotations about what is supported. The model is cached and rebuilt from database metadata. Several edits during development repaired earlier edits of the same feature.
19. [IP address validation configurable with allow lists, deny lists and ranges](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E010)
    - *Enhancement*
    - An administrator can now set the IP address validation of the web servers in the settings: use of the allow list, the deny list and Invantive Customer Service can each be switched off, extra addresses and address ranges can be allowed or denied, and the built-in default lists can be excluded. Addresses on an allow or deny list are decided before any look-up is made.
20. [Proxy and load balancer set-up through a ForwardedHeaders section](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E006)
    - *Enhancement*
    - The way a server learns the client address behind a proxy or load balancer is now set in one section of the settings, with a choice between the Kestrel mechanism and the Invantive mechanism, the headers to follow, the number of hops, the known proxies and the allowed host names. The earlier setting that said that the server runs behind a proxy is removed. The start-up trace explains what was configured and what the framework applied.
21. [Filters no longer lose rows or evaluate wrongly](/en/release-notes/products?product=invantive-cloud#CLD-27.0-B005)
    - *Bug Fix*
    - A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.
22. [Exact Online incremental data is no longer damaged or overwritten](/en/release-notes/products?product=invantive-cloud#CLD-27.0-B006)
    - *Bug Fix*
    - Users of one subscription replaced each other's incremental image, a request that ended while an image was saved could leave chunks of two versions, a refresh that only added rows was taken as unchanged, and incremental data could end up in the folder of other cache settings or ignore the disk cache settings of the statement.
23. [Error answers follow the Accept header](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E025)
    - *Enhancement*
    - An error answer is written as HTML, JSON, Markdown, plain text or XML, whichever the request prefers; with nothing acceptable it uses the default of the endpoint. A request abandoned by the caller is registered with status 499, and more paths of credential files and debug consoles are blocked.
24. [Lock-out after failed log-ons ends correctly](/en/release-notes/products?product=invantive-cloud#CLD-27.0-B002)
    - *Bug Fix*
    - After repeated failed password attempts, a repeated identical password is refused at once, a refusal no longer counts as a new failed attempt, and a successful log-on resets the counter. The maximum delay is 15 seconds instead of 30, below usual client time-outs.
25. [Pipedrive platform](/en/release-notes/products?product=invantive-cloud#CLD-27.0-E017)
    - *Enhancement*
    - Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

</div>

<a id="invantive-cloud-26.0-to-27.0-new"></a>

### All Enhancements

Changes to behaviour, platforms, drivers and settings, grouped by area.

<div class="rn-filters">

Importance: [all](/en/release-notes/products?product=invantive-cloud&platform=In-memory#invantive-cloud-26.0-to-27.0-new) | [2 and higher](/en/release-notes/products?product=invantive-cloud&platform=In-memory&importance=2#invantive-cloud-26.0-to-27.0-new) | [3 and higher](/en/release-notes/products?product=invantive-cloud&platform=In-memory&importance=3#invantive-cloud-26.0-to-27.0-new) | [4 and higher](/en/release-notes/products?product=invantive-cloud&platform=In-memory&importance=4#invantive-cloud-26.0-to-27.0-new) | [5](/en/release-notes/products?product=invantive-cloud&platform=In-memory&importance=5#invantive-cloud-26.0-to-27.0-new)

Platform: [all](/en/release-notes/products?product=invantive-cloud#invantive-cloud-26.0-to-27.0-new) | [AccountView](/en/release-notes/products?product=invantive-cloud&platform=AccountView#invantive-cloud-26.0-to-27.0-new) (1) | [ActiveCampaign](/en/release-notes/products?product=invantive-cloud&platform=ActiveCampaign#invantive-cloud-26.0-to-27.0-new) (3) | [AFAS](/en/release-notes/products?product=invantive-cloud&platform=AFAS#invantive-cloud-26.0-to-27.0-new) (1) | [AFAS Online](/en/release-notes/products?product=invantive-cloud&platform=AFAS%20Online#invantive-cloud-26.0-to-27.0-new) (4) | [Autotask](/en/release-notes/products?product=invantive-cloud&platform=Autotask#invantive-cloud-26.0-to-27.0-new) (1) | [Big Data JSON](/en/release-notes/products?product=invantive-cloud&platform=Big%20Data%20JSON#invantive-cloud-26.0-to-27.0-new) (1) | [Brevo](/en/release-notes/products?product=invantive-cloud&platform=Brevo#invantive-cloud-26.0-to-27.0-new) (2) | [Bridge Online](/en/release-notes/products?product=invantive-cloud&platform=Bridge%20Online#invantive-cloud-26.0-to-27.0-new) (4) | [CBS](/en/release-notes/products?product=invantive-cloud&platform=CBS#invantive-cloud-26.0-to-27.0-new) (1) | [Chargebee](/en/release-notes/products?product=invantive-cloud&platform=Chargebee#invantive-cloud-26.0-to-27.0-new) (1) | [Crisp](/en/release-notes/products?product=invantive-cloud&platform=Crisp#invantive-cloud-26.0-to-27.0-new) (4) | [Data Cache](/en/release-notes/products?product=invantive-cloud&platform=Data%20Cache#invantive-cloud-26.0-to-27.0-new) (1) | [DeepL](/en/release-notes/products?product=invantive-cloud&platform=DeepL#invantive-cloud-26.0-to-27.0-new) (2) | [Discourse](/en/release-notes/products?product=invantive-cloud&platform=Discourse#invantive-cloud-26.0-to-27.0-new) (1) | [Dropbox](/en/release-notes/products?product=invantive-cloud&platform=Dropbox#invantive-cloud-26.0-to-27.0-new) (2) | [Dynamics 365 CRM](/en/release-notes/products?product=invantive-cloud&platform=Dynamics%20365%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [Dynamics CRM](/en/release-notes/products?product=invantive-cloud&platform=Dynamics%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [Easyflex](/en/release-notes/products?product=invantive-cloud&platform=Easyflex#invantive-cloud-26.0-to-27.0-new) (1) | [EDIFACT](/en/release-notes/products?product=invantive-cloud&platform=EDIFACT#invantive-cloud-26.0-to-27.0-new) (1) | [Exact Online](/en/release-notes/products?product=invantive-cloud&platform=Exact%20Online#invantive-cloud-26.0-to-27.0-new) (32) | [Firebird](/en/release-notes/products?product=invantive-cloud&platform=Firebird#invantive-cloud-26.0-to-27.0-new) (2) | [Fortnox](/en/release-notes/products?product=invantive-cloud&platform=Fortnox#invantive-cloud-26.0-to-27.0-new) (1) | [FoxPro](/en/release-notes/products?product=invantive-cloud&platform=FoxPro#invantive-cloud-26.0-to-27.0-new) (1) | [Freshdesk](/en/release-notes/products?product=invantive-cloud&platform=Freshdesk#invantive-cloud-26.0-to-27.0-new) (3) | [Freshservice](/en/release-notes/products?product=invantive-cloud&platform=Freshservice#invantive-cloud-26.0-to-27.0-new) (2) | [FTP](/en/release-notes/products?product=invantive-cloud&platform=FTP#invantive-cloud-26.0-to-27.0-new) (1) | [Gripp](/en/release-notes/products?product=invantive-cloud&platform=Gripp#invantive-cloud-26.0-to-27.0-new) (1) | [Gripp CRM](/en/release-notes/products?product=invantive-cloud&platform=Gripp%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [HubSpot](/en/release-notes/products?product=invantive-cloud&platform=HubSpot#invantive-cloud-26.0-to-27.0-new) (3) | [IBM Db2](/en/release-notes/products?product=invantive-cloud&platform=IBM%20Db2#invantive-cloud-26.0-to-27.0-new) (1) | [In-memory](/en/release-notes/products?product=invantive-cloud&platform=In-memory#invantive-cloud-26.0-to-27.0-new) (2) | [In-memory storage](/en/release-notes/products?product=invantive-cloud&platform=In-memory%20storage#invantive-cloud-26.0-to-27.0-new) (1) | [Inspectlet](/en/release-notes/products?product=invantive-cloud&platform=Inspectlet#invantive-cloud-26.0-to-27.0-new) (4) | [Invantive Bridge Online](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Bridge%20Online#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Business](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Business#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Estate](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Estate#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Web Service](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Web%20Service#invantive-cloud-26.0-to-27.0-new) (1) | [ionBIZ](/en/release-notes/products?product=invantive-cloud&platform=ionBIZ#invantive-cloud-26.0-to-27.0-new) (1) | [Kadaster](/en/release-notes/products?product=invantive-cloud&platform=Kadaster#invantive-cloud-26.0-to-27.0-new) (1) | [LibreOffice](/en/release-notes/products?product=invantive-cloud&platform=LibreOffice#invantive-cloud-26.0-to-27.0-new) (1) | [LinkedIn](/en/release-notes/products?product=invantive-cloud&platform=LinkedIn#invantive-cloud-26.0-to-27.0-new) (1) | [Logius COR](/en/release-notes/products?product=invantive-cloud&platform=Logius%20COR#invantive-cloud-26.0-to-27.0-new) (1) | [Loket](/en/release-notes/products?product=invantive-cloud&platform=Loket#invantive-cloud-26.0-to-27.0-new) (1) | [Loket.nl](/en/release-notes/products?product=invantive-cloud&platform=Loket.nl#invantive-cloud-26.0-to-27.0-new) (2) | [Magento](/en/release-notes/products?product=invantive-cloud&platform=Magento#invantive-cloud-26.0-to-27.0-new) (3) | [MariaDB](/en/release-notes/products?product=invantive-cloud&platform=MariaDB#invantive-cloud-26.0-to-27.0-new) (1) | [Matomo](/en/release-notes/products?product=invantive-cloud&platform=Matomo#invantive-cloud-26.0-to-27.0-new) (3) | [Mendix](/en/release-notes/products?product=invantive-cloud&platform=Mendix#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Access](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Access#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Dynamics CRM](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Dynamics%20CRM#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Graph](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Graph#invantive-cloud-26.0-to-27.0-new) (1) | [MySQL](/en/release-notes/products?product=invantive-cloud&platform=MySQL#invantive-cloud-26.0-to-27.0-new) (10) | [Nextcloud](/en/release-notes/products?product=invantive-cloud&platform=Nextcloud#invantive-cloud-26.0-to-27.0-new) (2) | [Nmbrs](/en/release-notes/products?product=invantive-cloud&platform=Nmbrs#invantive-cloud-26.0-to-27.0-new) (2) | [OData](/en/release-notes/products?product=invantive-cloud&platform=OData#invantive-cloud-26.0-to-27.0-new) (1) | [ODBC](/en/release-notes/products?product=invantive-cloud&platform=ODBC#invantive-cloud-26.0-to-27.0-new) (3) | [Odoo](/en/release-notes/products?product=invantive-cloud&platform=Odoo#invantive-cloud-26.0-to-27.0-new) (4) | [Open Archives](/en/release-notes/products?product=invantive-cloud&platform=Open%20Archives#invantive-cloud-26.0-to-27.0-new) (1) | [Open Besluitvorming](/en/release-notes/products?product=invantive-cloud&platform=Open%20Besluitvorming#invantive-cloud-26.0-to-27.0-new) (1) | [OpenBesluitvorming](/en/release-notes/products?product=invantive-cloud&platform=OpenBesluitvorming#invantive-cloud-26.0-to-27.0-new) (1) | [Oracle](/en/release-notes/products?product=invantive-cloud&platform=Oracle#invantive-cloud-26.0-to-27.0-new) (15) | [PayPal](/en/release-notes/products?product=invantive-cloud&platform=PayPal#invantive-cloud-26.0-to-27.0-new) (2) | [Pipedrive](/en/release-notes/products?product=invantive-cloud&platform=Pipedrive#invantive-cloud-26.0-to-27.0-new) (2) | [PostgreSQL](/en/release-notes/products?product=invantive-cloud&platform=PostgreSQL#invantive-cloud-26.0-to-27.0-new) (14) | [Rabobank MT940](/en/release-notes/products?product=invantive-cloud&platform=Rabobank%20MT940#invantive-cloud-26.0-to-27.0-new) (1) | [RDW](/en/release-notes/products?product=invantive-cloud&platform=RDW#invantive-cloud-26.0-to-27.0-new) (2) | [Robaws](/en/release-notes/products?product=invantive-cloud&platform=Robaws#invantive-cloud-26.0-to-27.0-new) (3) | [Salesforce](/en/release-notes/products?product=invantive-cloud&platform=Salesforce#invantive-cloud-26.0-to-27.0-new) (1) | [SFTP](/en/release-notes/products?product=invantive-cloud&platform=SFTP#invantive-cloud-26.0-to-27.0-new) (1) | [SnelStart](/en/release-notes/products?product=invantive-cloud&platform=SnelStart#invantive-cloud-26.0-to-27.0-new) (5) | [SQL Server](/en/release-notes/products?product=invantive-cloud&platform=SQL%20Server#invantive-cloud-26.0-to-27.0-new) (13) | [Stripo](/en/release-notes/products?product=invantive-cloud&platform=Stripo#invantive-cloud-26.0-to-27.0-new) (3) | [Teamleader](/en/release-notes/products?product=invantive-cloud&platform=Teamleader#invantive-cloud-26.0-to-27.0-new) (2) | [Teamleader Focus](/en/release-notes/products?product=invantive-cloud&platform=Teamleader%20Focus#invantive-cloud-26.0-to-27.0-new) (2) | [TeamViewer](/en/release-notes/products?product=invantive-cloud&platform=TeamViewer#invantive-cloud-26.0-to-27.0-new) (1) | [Tixly](/en/release-notes/products?product=invantive-cloud&platform=Tixly#invantive-cloud-26.0-to-27.0-new) (1) | [Tweede Kamer](/en/release-notes/products?product=invantive-cloud&platform=Tweede%20Kamer#invantive-cloud-26.0-to-27.0-new) (3) | [Twinfield](/en/release-notes/products?product=invantive-cloud&platform=Twinfield#invantive-cloud-26.0-to-27.0-new) (8) | [VIES](/en/release-notes/products?product=invantive-cloud&platform=VIES#invantive-cloud-26.0-to-27.0-new) (2) | [Visma Severa](/en/release-notes/products?product=invantive-cloud&platform=Visma%20Severa#invantive-cloud-26.0-to-27.0-new) (1) | [Visma.net](/en/release-notes/products?product=invantive-cloud&platform=Visma.net#invantive-cloud-26.0-to-27.0-new) (5) | [Visma.net Financials](/en/release-notes/products?product=invantive-cloud&platform=Visma.net%20Financials#invantive-cloud-26.0-to-27.0-new) (1) | [Wikipedia](/en/release-notes/products?product=invantive-cloud&platform=Wikipedia#invantive-cloud-26.0-to-27.0-new) (1) | [WMI](/en/release-notes/products?product=invantive-cloud&platform=WMI#invantive-cloud-26.0-to-27.0-new) (1) | [XAA](/en/release-notes/products?product=invantive-cloud&platform=XAA#invantive-cloud-26.0-to-27.0-new) (1) | [XAF](/en/release-notes/products?product=invantive-cloud&platform=XAF#invantive-cloud-26.0-to-27.0-new) (1) | [Yuki](/en/release-notes/products?product=invantive-cloud&platform=Yuki#invantive-cloud-26.0-to-27.0-new) (4)

</div>

2 of 466 shown.

<a id="invantive-cloud-26.0-to-27.0-e-performance"></a>

#### Performance

<div class="rn-item" id="CLD-27.0-E098">

##### Lower memory use and faster processing

Encryption, compression, logging, translations, JSON reading, sorting, the in-memory driver and long-running sessions allocate less memory and use less CPU time. Creating a table from a large result streams the rows, and several string functions run faster.

<div class="rn-chips">

- Exact Online
- In-memory
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- XAF
- importance 3

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-fixed"></a>

### All Bug Fixes

Defects of the older release that are repaired.

<a id="invantive-cloud-26.0-to-27.0-b-sql-engine"></a>

#### SQL engine

<div class="rn-item" id="CLD-27.0-B021">

##### Repeated and parallel CREATE OR REPLACE and IF NOT EXISTS statements work

Concurrent create or replace of functions and procedures, a function that kept calling its old body, and parallel create table if not exists or drop table if exists on the same table no longer fail.

<div class="rn-chips">

- In-memory
- importance 3

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-builds"></a>

### What It Builds On

| Kind | Name | From | To |
|---|---|---|---|
| invantive component | Invantive Cloud | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Basics | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Cloud API Shared | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) SQL for Core | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) SQL | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Web Core Library | 26.0.4 | 27.0.92 |
| build tool | Invantive Deploy | 26.0.4 | 27.0.92 |
| third party summary |  |  |  |

<a id="invantive-cloud-26.0-to-27.0-more"></a>

### More Information

- [Product manual](https://go.invantive.com/doc/invantive-cloud)
- [Product documentation](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/invantive-cloud)
- [Downloads](https://go.invantive.com/download/)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 56 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 67 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 54 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 60 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 52 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- For all products together 28 items whose changed lines are 50 to 70 % in the first build of 26.0 and 23 items that a content check would have left out were read against that build; the items that apply to this product are kept or left out on that reading.
- Range: commits of origin/release-27.0 that are not reachable from the first build of release 26.0 (stamp 26.0.4, per repository). Commits that were ported to later builds of 26.0 are therefore included.
- For a product that does not offer SQL to its users, items of the shared libraries outside the areas installation, licensing, security and diagnostics, and items about one platform, are left out and counted as internal.
- The commits are the ones of the range that touch a project of the product; each commit was classified once, for all products, and the items of a product are the items that contain such commits.
- Version stamp commits of the build pipeline are left out.
- A change whose changed lines are for 70 % or more already in the first 26.0 build is left out; items between 50 % and 70 % and all such exclusions were checked by reading the code of that build.
- A bug fix whose repaired lines were written by another commit of the same range is merged into its feature or left out.
- Texts were written from the commit messages and from the changes themselves; items carry a confidence.
- 1343 links between a change and a source commit are recorded.
- 55 exclusions are recorded in the audit of the note.

</div>

</div>

</div>

</div>

