invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Invantive Cloud

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

Before You Upgrade

These changes ask for a check:

Top 25 Changes

  1. Settings files move from XML to JSON
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  8. Loading of provider assemblies from a settings file is blocked
    • 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
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  10. QR code functions take one size value instead of width and height
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  11. Data containers and credentials from Invantive Credentials Server
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • Enhancement
    • Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

All Enhancements

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

Importance: all | 2 and higher | 3 and higher | 4 and higher | 5

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

145 of 466 shown.

Installation and platform

Settings files move from XML to JSON

A settings file in XML is converted to JSON when it is read. The user and installation settings, the cached list of databases and the databases of the user are also written in JSON, through an atomic write, and a damaged XML file is recovered where possible. From 27.0 the JSON file takes precedence; the XML file is still written for older releases on the same workstation and is planned to disappear.

What to Do

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.

  • action needed
  • importance 5
Proxy and load balancer set-up through a ForwardedHeaders section

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.

  • importance 4
File names longer than 260 characters work on Windows

Where Windows allows it, file and folder paths up to 32,767 characters are accepted. The setup program declares support for long paths and the trace shows whether they work.

  • importance 3
Modules behind a proxy know their public address from X-Forwarded-Prefix

A module can read the public path prefix that the proxy sends in X-Forwarded-Prefix. The setting to forward all headers no longer lets the framework consume this header, so pages keep linking to the public address.

  • importance 3
The keychain and settings files are written safely

The keychain and settings files hold either the old or the new contents, also after a crash or a full disk, are guarded with a file lock when two programs use them, are written less often and open faster.

  • importance 3

Licensing and sign-in

Data containers and credentials from Invantive Credentials Server

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.

  • importance 4

Invantive Credentials Server, Concept of Invantive Credentials Server

Exact Online companies outside the service area are no longer accepted

Exact Online divisions of companies in a country on an exclusion list, or outside the service area, are no longer offered, except for a fixed list of companies that were allowed before. A log line states the exclusion.

What to Do

Companies in countries outside the service area are no longer available in Exact Online.

  • action needed
  • Exact Online
  • importance 4

Service area of Invantive Cloud

Invantive License Service: clearer messages, grace period and new modules

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.

  • importance 4

License Service

Allow use of a database per product

A database connection can be allowed or blocked per product: MCP Server, UniversalSQL Server, Bridge Online and Apps Online. MCP Server refuses a database that is not allowed for it.

  • importance 3
Invantive Connect can sign users in to Cloud and exchange credentials

Cloud accepts users signed in through Invantive Connect next to AWS Cognito. The credentials of a BI tool for Bridge Online and UniversalSQL Server are exchanged for a token at Connect, and a refusal now says why. MFA can no longer be switched off by the user.

  • importance 3
Invantive MCP Server is recognised as an application

The Invantive MCP Server is now a known application for licence checks and for the choice of client settings.

  • importance 3
Licence keys can be supplied through environment variables

A licence key can be given in the environment variables INVANTIVE_LIC_KEY and INVANTIVE_LICX_KEY, also with surrounding text or line breaks. This helps with unattended starts, for example in scripts and containers.

  • importance 3

Environment variables

OAuth redirect address unified for web platforms

Platforms that sign in with OAuth now use one redirect address under the invantive.com domain. Some used a separate address under invantive.eu.

  • Dynamics 365 CRM
  • Loket.nl
  • Dropbox
  • HubSpot
  • Fortnox
  • importance 3
Sign-up checks the email address with Customer Service

At the first step of sign-up, the email address is also checked for disposable, relay and blocked domain names and for known spam addresses. Such an address is refused with the matching message.

  • importance 3

Security

IP address validation configurable with allow lists, deny lists and ranges

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.

  • importance 4
Loading of provider assemblies from a settings file is blocked

A provider that a settings file loads from an assembly file now fails with an error, because no files are on the allowed list yet. The EDIFACT provider no longer loads its template assembly from disk. Plan for this when a script or settings file relies on custom providers or EDIFACT templates.

What to Do

A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.

  • action needed
  • EDIFACT
  • importance 4
Stronger detection of abuse and forged forwarding headers

Attack prevention writes a first block at warning level and reports it centrally, blocks addresses that request many different unknown paths, and answers probes from Invantive servers without blocking them. Failed log-ons are counted across accounts and addresses, forged forwarding headers are reported once per hour, and personal form data is removed from error details.

  • importance 4
Attack prevention blocks an address for 5 minutes by default

An address that requests a protected URL is now blocked for 5 minutes by default. Before, the default was 15 minutes.

  • importance 3
Fewer paid country lookups, and search engines are recognised by their published addresses

The country of a new client address is looked up first and the more expensive details only when needed. Search engine crawlers are accepted on public content only when their address lies in the ranges that Google, Bing, Apple and DuckDuckGo publish; the new setting UseSearchEngineCrawlers controls this.

  • importance 3
Filtered requests are answered with 403 instead of 500 by default

A request that a request filter rejects now gets HTTP status 403 unless a status is configured. Before, the default was 500. A refused IP address also passes its own status through the exception.

  • importance 3
Harden session cookies and the check of sign-in tokens

Cookies of the portal and the API are marked as not readable by scripts and are not sent along with cross-site requests. The API now only accepts access tokens of a signed-in user that were issued for the Invantive Cloud application itself; tokens that were issued for another application of the same user pool are refused.

  • importance 3
Limit repeated sign-up attempts from the same IP address

Repeated sign-up attempts from one IP address are delayed by 2 to 10 seconds, depending on how quickly they follow each other. When the wait is longer than 15 seconds, the request is refused with a message.

  • importance 3
MCP Server accepts clients from the United States

The country restriction no longer refuses addresses in the United States for MCP Server, where the AI platforms that call it run. Other reasons for a refusal still apply.

  • importance 3
MaxMind look-ups are cached, can be limited and survive an empty balance

Look-ups of the country and risk of a client address at MaxMind are done once per address at a time and are cached in memory and in the database. When the MaxMind balance is empty, older results are reused for longer and a separate error is reported instead of refusing clients. Administrators can switch look-ups off, query the country only, or disable the database cache.

  • importance 3
Prevent SQL injection through inlined values on MySQL and PostgreSQL

String values that are placed in generated SQL for MySQL are now escaped for backslashes as well as quotes. A PostgreSQL session now sets standard_conforming_strings to on and fails with an error when the server does not accept this.

  • MySQL
  • PostgreSQL
  • importance 3
Release builds no longer skip the geo-block for a Development environment

In a release build, a server started with the environment name Development no longer accepts addresses that are refused because of their country. The check for the development environment remains in debug builds only.

  • importance 3
Sensitive values are masked in traces, error data and OAuth logs

Passwords, secrets, tokens, API keys, cookies, authorisation headers and one-time codes are no longer written in clear text in traces, exception data and the log text of OAuth calls.

  • importance 3

SQL engine

Correlated subqueries are supported

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.

  • importance 5
QR code functions take one size value instead of width and height

The functions that create a QR code and a QR code for a European payment (EPC) now take a single size per element instead of separate width and height. Existing statements that pass width and height must be changed. The QR code library has been replaced.

What to Do

Adjust statements that call the QR code functions with a separate width and height.

  • action needed
  • importance 4

Function BARCODE_QR

Add data dictionary views for keys and foreign keys

Two new data dictionary views list the primary keys and the foreign keys of tables, including keys of several columns. The columns view gets the original database data type and whether a value is required on update.

  • importance 3
Add technical documentation and more table and view properties to the data dictionary

The data dictionary lists technical documentation for tables. The view catalogue gains 13 columns, among them the supported operations, documentation, an example, whether the view is partition specific, and the estimated latency and throughput. Technical documentation was added to a number of Exact Online views.

  • importance 3
Add the DESCRIBE statement to show the columns of a select or table

The new statement DESCRIBE returns the columns that a select statement, a table, a view or a table function answers, without reading any row.

  • importance 3

[Describe statement](https://documentation.invantive.com/Invantive+UniversalSQL/Grammar/Statement+Types/Describe+Statement+(describeStatement%29)

Cancel queries, SYNCHRONIZE and PSQL loops faster and more reliably

A running query, synchronise, script loop or web request reacts to a cancel request sooner, and background threads are stopped.

  • Twinfield
  • importance 3
Cancel statements and log on more reliably

Cancelling stops statements between rows and between statements of a batch, and background work of a log on is stopped before its connection is closed. Parallel readers can be disposed more than once and no longer leak resources.

  • importance 3
Column references may carry a schema and table qualifier

A column can be written as column, qualifier.column or schema.table.column, as in SQL Server.

  • SQL Server
  • importance 3
Copying data keeps the original database data type

The data type as the database reports it is kept with a column and used for bulk insert and create table. Wide decimal columns keep their integer digits when copied to MySQL, Oracle or SQL Server.

  • Oracle
  • MySQL
  • SQL Server
  • importance 3
Division and office list is kept when the USE statement changes the selection

Selecting divisions or offices with the USE statement no longer discards the loaded list. The list is not retrieved again and the state of each entry is kept. Newly selected entries are added to the existing selection.

  • importance 3
HTTP functions can ignore web errors

The functions that fetch or post web content accept an extra argument to continue when the web server answers with an error, and the error text states the HTTP status code.

  • importance 3
Integer constants in SQL keep an integer type

A whole number written in a statement is now handled as an integer instead of a decimal number. Result types of expressions on such constants can differ from before.

What to Do

Check expressions that rely on whole numbers being decimal; the data type of the result can differ.

  • action needed
  • importance 3
Register the SQL functions REGEXP_COUNT and REGEXP_LIKE for licensing

The SQL functions to count and test regular expression matches are registered with the licence requirements of advanced calculation.

  • importance 3
Table function to split a text into runs of characters

A new table function returns the runs of a given length of a text, with their positions. It can be joined to find texts that resemble each other. Use of the function is controlled by a function right.

  • importance 3
number_to_speech supports more languages

The SQL function number_to_speech can spell numbers in English in addition to Dutch and now accepts exactly two arguments: the number and the language.

  • importance 3

Scripting

Parts of a PSQL block can run in parallel

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.

  • importance 5

Package dbms_parallel, Package dbms_atomic

Scripts can run operating system commands with the new package dbms_os

The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.

  • importance 4

Package dbms_os

A script can query its own execution profile

Runs of Invantive Script, their statements, started operating system commands, variables and exit codes are registered and can be queried with plain SQL through the new data container Script. The name of the profile log can be chosen, and statements register the memory they allocated.

  • importance 3
Extend the cloud_http package for web applications

The package offers functions for the public URL of a module, the origin and the query string of the request and a redirect. Functions record the release in which they appeared.

  • importance 3

Query Tool user interface

Progress panel shows live row counts and real-time figures per step

The Progress panel of a running statement now follows the rows read and written while a step runs, and not only when it ends. Calls that are still busy show the rows and the bytes sent and received so far.

  • importance 3

Platforms and drivers

DeepL driver

A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.

  • DeepL
  • importance 5
Add write support to AFAS Online

AFAS Online connectors that only write become tables per update connector. Objects below the main element, such as the lines of a financial entry, get a table of their own that can be inserted into within a transaction.

  • AFAS Online
  • importance 4
New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5

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.

  • Inspectlet
  • Matomo
  • Nextcloud
  • Tweede Kamer
  • importance 4
Pipedrive platform

Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

  • Pipedrive
  • importance 4
Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list

The LinkedIn driver and the SOAP-based Loket.nl driver are no longer part of the product. The Dynamics CRM driver no longer registers its predefined list of tables and columns.

What to Do

Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.

  • action needed
  • LinkedIn
  • Loket.nl
  • Microsoft Dynamics CRM
  • importance 4
Support filtering and sorting of the OData model used by MCP

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.

  • importance 4
The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum

The legacy Oracle driver is no longer registered and Oracle is handled by the managed driver, a log-on to a database older than version 18 is refused, and the Invantive Web Service driver and its data container are no longer offered.

  • Invantive Web Service
  • Oracle
  • importance 4
Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs

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.

  • Visma.net
  • importance 4
A lost connection to a relational database is set up again

A connection to a relational database that was lost is rebuilt and the application log-on is repeated on the new session, so the next statement does not fail. The pool of connections shrinks when it is not needed.

  • importance 3
Add company and deal attributes to the Brevo driver

The Brevo driver returns the attributes of companies and deals.

  • Brevo
  • importance 3
Bring the ActiveCampaign driver level with API v3

The driver gains columns and tables, such as notes, custom objects, custom field options, deal roles and bulk import of contacts. Writes that the platform could not carry out are withdrawn, and the request rate follows the limits that the platform reports.

  • ActiveCampaign
  • importance 3
Connection forms are described by the attributes of a driver

Provider attributes now state the kind of value, the accepted values and whether a value is required, for more numeric types. Two data dictionary views show these properties. A web service URL is requested at log on only for platforms where the user supplies it.

  • Bridge Online
  • Dynamics 365 CRM
  • Magento
  • Mendix
  • Nmbrs
  • importance 3
Crisp: 50 more tables, filters at the platform and procedures to clear fields

The Crisp driver offers about 50 additional tables, sends filters on conversation tables to Crisp and exposes more conversation data. New procedures clear a field of a people profile.

  • Crisp
  • importance 3
Exact Online XML tables follow the XML schema of 3 August 2026 and load faster

The XML tables are updated to the current schema, and the data model is read from a predefined list of fields instead of being derived from the schema on every start.

  • Exact Online
  • importance 3
Extend Gripp CRM with more tables and server-side filtering

Gripp CRM gets more tables, including tables for embedded lists, and more conditions are evaluated by Gripp itself, which reduces the rows transferred.

  • Gripp CRM
  • importance 3
Extend Magento with writes, packages and custom attributes

Magento gets a full data model with read, insert, update and delete, a package for operations that are no table rows, sample statements and one column per custom attribute of a product.

  • Magento
  • Robaws
  • importance 3
Extend the Twinfield driver with settings, runs and code lists

New table functions read office, user, VAT code and project rate settings, and payment and collection runs. Code lists of the platform are given in the column descriptions, and a browse that only counts rows asks for one column. Page size on wide transaction tables is limited.

  • Twinfield
  • importance 3
Gripp CRM tables now have a schema name

The tables of Gripp CRM are now placed in a schema. Statements that use the old table names may have to be changed.

What to Do

Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.

  • action needed
  • Gripp CRM
  • importance 3
Magento and Open Besluitvorming are production platforms; Yuki and Robaws leave run-out

Magento, Open Besluitvorming and Stripo are registered as production platforms, and Yuki and Robaws are production platforms again after they were marked as run-out.

  • Magento
  • Open Besluitvorming
  • Robaws
  • Stripo
  • Yuki
  • importance 3
PostgreSQL: setting fail-on-missing-tables

A new setting fail-on-missing-tables on the PostgreSQL driver controls the check that every primary key in the metadata has an accessible table or view. When off, the check is skipped.

  • PostgreSQL
  • importance 3
Read all read operations of the Yuki API

Yuki gets tables for the read operations of its published web services that were not available yet. Yuki stays read-only.

  • Yuki
  • importance 3
Refused Exact Online reads are remembered and listed

Calls that Exact Online refuses are remembered across sessions and no longer requested again and again. The new view RequestTablesWithoutRights lists the tables and companies for which a read was refused because of missing rights.

  • Exact Online
  • importance 3
SFTP connections are really supported and FTP calls are asynchronous

The SFTP driver now connects to an SFTP server with a password, with separate time-outs for connecting and for a single operation. Before, it could not perform the calls. The FTP driver was made asynchronous.

  • SFTP
  • FTP
  • importance 3
Set the idle period before SQL connections are closed

A new provider attribute sets after how many seconds an idle connection to a SQL database is closed. Server products keep connections for 300 seconds by default.

  • SQL Server
  • MySQL
  • PostgreSQL
  • Oracle
  • importance 3
Set up databases for Inspectlet and Tweede Kamer (v2)

New databases can be created for the platforms Inspectlet and Tweede Kamer (v2) from the portal, with their own pages and icons for Inspectlet, Matomo and Nextcloud.

  • Inspectlet
  • Tweede Kamer
  • importance 3
Show the Credentials Server URL of a database and allow its use (beta)

On the page of a database, the address of the Credentials Server is shown with a setting to allow its use, marked as beta. The Cloud services can fetch OAuth tokens through the Credentials API.

  • importance 3
Show the MCP Server URL of a database and allow its use (beta)

On the page of a database, the URL of the MCP Server is shown with a copy button, together with a setting to allow its use. The MCP Server is marked as beta.

  • importance 3
Show the MCP Server URL of a database and allow its use (beta)

On the page of a database, the URL of the MCP Server is shown with a copy button, together with a setting to allow its use. The MCP Server is marked as beta.

  • importance 3
SnelStart data model updated to the API definition of 27 May 2026

The SnelStart tables and columns follow the new API definition. More reference columns are included and decimal values are read as decimal numbers. One slow, experimental view stays disabled.

  • SnelStart
  • importance 3
Speed up SnelStart counts and read documents and long text filters

SnelStart gets a table for sales invoice lines from orders. Counts read only the key column. Document tables with an empty parent identifier no longer fail, and a filter on long text is narrowed with a prefix.

  • SnelStart
  • importance 3
Stripo Email platform

Stripo Email can be read and written as a new platform with emails, templates and modules.

  • Stripo
  • importance 3
Support SQL Server geography, geometry and hierarchyid data types

Columns of the SQL Server types geography, geometry and hierarchyid can now be read through the SQL Server driver.

  • SQL Server
  • importance 3
Twinfield: more offices can be used with the Invantive client ID

The list of offices that may be used with the Invantive client ID has more offices, including office 00001, and the new setting additional-allowed-offices names further offices.

  • Twinfield
  • importance 3
Update Kadaster to the current OpenAPI specification

The tables of Kadaster follow the OpenAPI specification of the platform.

  • Kadaster
  • importance 3
Update Robaws to the latest API and add a package for operations

Robaws follows the API specification of 2026-11-01. A package offers operations that are no table row, such as archiving, locking, booking an invoice and downloading the PDF of a document.

  • Robaws
  • importance 3

Wikipedia gets tables for search, pages with content, the history and links of a page and files, and a parameter to choose the language wiki.

  • Wikipedia
  • importance 3
Update the Logius COR driver to the new host and API version 1

The driver uses the new Logius register host and API version 1. The old host no longer resolves. Error answers use the new format.

  • Logius COR
  • importance 3
Web calls wait and retry better

Timeouts apply as configured, a stalled connection is cut off and treated as temporary, retries wait longer each time with a random part and follow the Retry-After header, a session slows down before the minutely rate limit is used up, a token endpoint that does not answer is dropped after 30 seconds, and damaged compressed answers are read again.

  • Dynamics CRM
  • importance 3

Export and import

Download the settings of a database as JSON

The settings of a database can be downloaded as a JSON file in addition to the XML file.

  • importance 3
Export to HTML and Rich Text Format; the Excel export follows the settings

Results can be exported to HTML and RTF with the chosen columns, row range and row limit. The Excel export follows the settings for columns, rows and SQL statement and can put the SQL on a separate worksheet.

  • importance 3

Exporting results

UTF-8 files are written without a byte order mark by default

Exports, trace files, plug-in files and the input and output of operating system commands are written as UTF-8 without a byte order mark unless one is asked for.

  • importance 3

Performance

More work is sent to the platform: row limit, grouping, selected columns and joins

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.

  • ActiveCampaign
  • Bridge Online
  • Crisp
  • Exact Online
  • IBM Db2
  • Inspectlet
  • Invantive Bridge Online
  • Matomo
  • MySQL
  • ODBC
  • OData
  • Odoo
  • Oracle
  • PayPal
  • PostgreSQL
  • SQL Server
  • Tweede Kamer
  • importance 5
Big Data JSON reads files much faster and skips files that cannot match

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.

  • Big Data JSON
  • importance 4
Data is loaded in the background while a session is idle

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.

  • Exact Online
  • Freshdesk
  • Freshservice
  • importance 4
Exact Online incremental tables reload less often and are read faster

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.

  • Exact Online
  • importance 4
Bulk insert for Oracle and MySQL

Rows are inserted into Oracle with array binding and into MySQL with the bulk loader, which is faster than row-by-row inserts.

  • MySQL
  • Oracle
  • importance 3
Data Cache no longer runs forced garbage collection; three settings removed

The Data Cache driver no longer starts a full garbage collection after replications. The settings garbage-collection-physical-memory-load-threshold, garbage-collection-replication-interval-count and garbage-collection-replication-minimum-interval-sec are removed. Remove them from settings files that still set them.

What to Do

Remove the three garbage-collection settings of the Data Cache driver from settings files.

  • action needed
  • Data Cache
  • importance 3
Disable GSS (Kerberos) negotiation on PostgreSQL connections for faster log-on

Every new PostgreSQL connection first asked the server for Kerberos encryption, which servers without Kerberos refuse by closing the connection. The setting is now disabled by default, which makes opening connections faster.

  • PostgreSQL
  • importance 3
Faster log-on with many data containers

Translations are kept locally and fetched at most once a day, the keychain is read once when switching database, icons are downloaded in parallel, and discovery no longer waits for the slowest platform: a platform that is still busy is shown when it answers.

  • AFAS Online
  • CBS
  • Exact Online
  • HubSpot
  • Salesforce
  • importance 3
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.

  • Exact Online
  • In-memory
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • XAF
  • importance 3
Oracle is read faster and sends fewer extra statements

Data is fetched in larger batches from the first round trip, rows are limited and paged on the server, the output buffer is read only while something listens, and sessions send fewer statements for settings.

  • Oracle
  • importance 3
Zstandard compression for trace files, caches and SQL functions

Trace files, persistent caches, saved result sets and the disk cache of web answers are compressed with Zstandard, which is faster than gzip at a similar size. Two SQL functions compress and decompress with Zstandard, and a text file with gzip or Zstandard content is read as plain text.

  • importance 3

Logging and diagnostics

Register every call to a platform in the connection activity

Calls of drivers to platforms, including database drivers, are registered with begin and end, rows and duration. The connection monitor shows them while they run and with the action of the user that caused them. Earlier, several calls were not registered or were counted twice.

  • importance 3

Documentation

Help links, the splash screen, the default address of Customer Service and the links of data sources point to the invantive.eu domain.

  • Dynamics CRM
  • Microsoft Graph
  • PayPal
  • importance 3

Other

Error answers follow the Accept header

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.

  • importance 4
Give API errors more detail and forward them to UniversalSQL Server

Error responses of the Cloud API carry more elements: recoverability, request URL, correlation ID, time of occurrence, requester address, user agent and tips. UniversalSQL Server receives these elements. Error messages for OData are extended likewise.

  • importance 3
New error pages with icons, tips and the correct HTTP status

Error pages have a new design with an icon per kind of error, including 401, 429 and 451, show tips from the documentation, and return the matching HTTP status code. The access denied page also shows tips. The page for HTTP 451 offers a link to the start page.

  • importance 3
Progress panel of the SQL editor: rotate, export as picture or flow chart, file reads

The progress panel of the SQL editor can be turned to another side, and exported as a picture or as a Mermaid flow chart. Reads over files show files and bytes read, and numbered steps are corrected. A progress reading is only available to the session that ran the statement.

  • importance 3
SQL editor object tree shows packages, procedures and functions of native platforms

For a database that is queried natively, the object tree lists the packages, procedures and functions of the platform next to its tables. A routine with several signatures is listed once per signature.

  • importance 3

All Bug Fixes

Defects of the older release that are repaired.

Licensing and sign-in

Lock-out after failed log-ons ends correctly

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.

  • importance 4
Refresh Exact Online tokens correctly when requests of one session run concurrently

Platforms that renew refresh tokens, such as Exact Online, accept only the newest token. Concurrent requests of one session each held an older copy and failed with an error about an outdated refresh token. A renewed token is now shared by all connections in the process.

  • Exact Online
  • importance 4
First log-on, last log-on and number of log-ons are registered per product and overall

Log-ons with a password were counted as Bridge Online for every product, and some products were not counted at all. The calling product is now recognised, and the overall first and last log-on and the count cover all products, so service users that never use the web show them too.

  • importance 3
Repeat authorisation also when an OAuth error is wrapped in another error

When a sign-in error was wrapped inside another exception, the automatic retry with a new authorisation did not start and the original error was shown. Wrapped OAuth errors are now recognised wherever they occur.

  • Exact Online
  • importance 3
Time spent waiting for a free request slot no longer counts as running time

The daily limit on the time spent on fresh data also counted the time a request waited in the queue for a free slot. A customer was refused with a limit exceeded by 58 million milliseconds. The waiting time is now excluded, and the cancellation of waiting requests and the translated message about waiting too long were improved.

  • importance 3

Security

Connection settings page shows labels and suitable fields and masks secret values

The page to change the settings of a data container showed the technical code of each setting, used a text box for every type, and showed secret values such as passwords in clear. It now shows the label and a fitting control, and masks values that the driver does not allow to be shown.

  • importance 4
Security mail reaches users who have no separate audit address

Users who never set a separate audit email address received no security mail. The mail now goes to their ordinary address, and a trace is written when neither address exists.

  • importance 3
XML from outside is no longer allowed to load external entities

Processing XML from external services, XSLT transformations and the XML of an RSA key no longer resolves DTDs or external entities.

  • Twinfield
  • VIES
  • Visma Severa
  • importance 3

SQL engine

Joins return the correct rows

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.

  • importance 5
Filters no longer lose rows or evaluate wrongly

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.

  • Microsoft Access
  • SQL Server
  • importance 4
Barcodes: PDF417 symbols are generated and EAN-13 text and short codes are correct

Generating a PDF417 barcode always failed, for numeric, text and binary content. Short numeric PDF417 codes got no padding or error correction, and the text under an EAN-13 barcode repeated a digit and left out the check digit. A code with fewer than 13 digits caused an error.

  • importance 3
Calling a pipelined table function could fail with error itgenclr009

Calling a pipelined table function in certain statements raised error itgenclr009. The call now passes all required arguments.

  • importance 3
Databases with the same name in different groups were confused

When two databases in a settings file have the same name in different groups and no explicit id, they got the same internal id. Stored data such as a cached sign-in token could then be used for the wrong database. The group name is now part of the id.

  • importance 3
Function date_trunc gave wrong dates for millennium, century and decade

Truncating a date to millennium, century or decade returned a date in the next year or a wrong date. The result is now the first day of the period, such as 2000-01-01.

  • importance 3
Function instr gave wrong results for reverse search and occurrences

The instr function returned wrong positions for a negative start position, for an occurrence higher than one and for a start beyond the text. The search was rewritten.

  • importance 3
Function normalize removed path separators that were allowed

The function that normalises file names removed the path separators even when they were allowed. It also now treats the forward slash like the backslash when shortening a name.

  • importance 3
HTTPDOWNLOAD failed with a null reference when it read a cached result

The function HTTPDOWNLOAD could fail with an unexpected error when its earlier result was read back from the memory cache. Cached results are now restored correctly.

  • importance 3
INTERSECT, EXCEPT and duplicate column names return the standard result

A chain of INTERSECT selects answered a intersect (b union c), SELECT * EXCEPT skipped columns that were not excluded, EXCEPT with several columns was read ambiguously, and a group function over a select list with duplicate column names failed.

  • importance 3
Repair and harden the REGEXP functions

REGEXP_INSTR returned a position one past the end and REGEXP_REPLACE started one character too early. Flags that contradict each other follow Oracle, and a pattern that takes more than one second now raises an error instead of hanging.

  • importance 3
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.

  • In-memory
  • importance 3
Rows after the first page are read

Grids and collections that load rows in pages did not read rows beyond the part already loaded. All rows are returned now.

  • importance 3
Send the correct value for user functions in set-based updates

An update such as set modified_by = user, or with coalesce over the user, sent a null to the database instead of the name of the logged-on user. A not-null column then refused the update, for example on PostgreSQL.

  • PostgreSQL
  • importance 3

Platforms and drivers

Exact Online incremental data is no longer damaged or overwritten

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.

  • Exact Online
  • importance 4
A write that is refused with HTTP 403 is reported as an error

An update or synchronize on Exact Online Employees reported rows updated while every write was refused with Forbidden. The refusal is now raised as an error for writes and is still ignored for reads.

  • Exact Online
  • importance 3
Close connections that remain open after a failed log-on

When one data container refused to log on, the data containers opened before it stayed open. Repeated attempts left idle connections on the database; 101 failed attempts left about 120 connections.

  • importance 3
Do not repeat an Exact Online XML write after a server error

A write that Exact Online answered with HTTP 500 was sent again, although Exact Online may have carried it out. A write is repeated only when the driver says it is safe.

  • Exact Online
  • importance 3
Exact Online: GLAccountClassificationsEx failed with itgendcr011

A statement on the table function GLAccountClassificationsEx with the parameter GLSchemeCode failed with itgendcr011 because the filter column was renamed. The renaming now applies only to the tables that use it.

  • Exact Online
  • importance 3
Exact Online: repeated error when reading account classifications

After a failed or cancelled retrieval of the account classifications, the same error (itgenshr062) was returned for every following request. The retrieval is now started again after a failure.

  • Exact Online
  • importance 3
Oracle query could fail with a null reference error on .NET 10

A query on an Oracle database could stop with a null reference error when running on .NET 10. The logging of the executed statement is now done safely.

  • Oracle
  • importance 3
Oracle: errors when a SELECT with IN runs in parallel

A SELECT with an IN list on Oracle could fail with a null reference inside the Oracle driver. The Oracle driver now runs one native call at a time to avoid this.

  • Oracle
  • importance 3
Setting divisions failed when the Exact Online Premium connector is enabled

Selecting divisions did not work when the Exact Online Premium connector was enabled. The selection is now passed on to the Exact Online connection.

  • Exact Online
  • importance 3
Shorten the retry wait on HubSpot rate limit answers and use the 10-second window

HubSpot rate limiting now uses the window that the platform prescribes. After an HTTP 429 answer the driver retries a few times with a bounded wait. Before, one page request could wait over 30 minutes and then hide the real cause.

  • HubSpot
  • importance 3
Twinfield: no licence error for offices when a custom client ID is used

A user with an own Twinfield client ID could get error itgentfr280 for an office that is not on the Invantive list. The check now applies only to the Invantive client IDs.

  • Twinfield
  • importance 3

Export and import

Apply export settings consistently and keep dates in universal time

Exports to HTML and RTF now use the same selection of columns, rows and row limit as other formats. A text date with a fixed format no longer shifts with the time zone of the machine. An export that cannot carry the SQL statement, such as CSV, refuses to omit it silently.

  • importance 3
Repair Excel export with empty user or company name and apply the output password

An Excel export no longer fails with an internal error when the user name or company name is empty. A workbook with an output password is now encrypted, and the footer shows the application name and version.

  • importance 3
Repair NDJSON output of several result sets

NDJSON output wrapped the result sets in an object. The rows now follow each other as lines, as the format requires.

  • importance 3

Performance

Memory use no longer grows without limit on busy servers

Four in-memory stores were never cleaned up: blocked IP addresses that did not return, the link between session identifiers and users, the cancellation source of every request, and the memory of duplicate events. They are now pruned or released, so a server under a scan or with many sessions keeps a stable memory use.

  • importance 3

Logging and diagnostics

Heartbeat endpoint answers unhealthy when the application says so

When the application-specific test reported a failure, the endpoint still answered healthy because it recomputed the health from the application data alone. The failure is now kept.

  • importance 3

Other

Prevent an HTTP 500 on the start page and let the API start when its licence check fails

Some visitors received a bare HTTP 500 on the start page of the portal because the link to the start page in a language could not be built. The Cloud API now starts even if its licence check fails and answers every request with a normal error message.

  • importance 3

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

More Information

How This Note Was Made

  • 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.