Documentation Invantive
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

Notes de mise à jour de Invantive Data Access Point

Notes de mise à jour - Hébergé

Invantive Data Access Point 27.0, de 26.0

Construire Date Description
26.0.336 29-09-2026 first build of release 26.0
27.0.54 01-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.

  • 219 améliorations
  • 149 corrections de bogues
  • 10 Éléments à vérifier avant la mise à jour

Avant de procéder à la mise à niveau

Ces modifications nécessitent une vérification :

Les 25 principales modifications

  1. Settings files move from XML to JSON
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  2. More work is sent to the platform: row limit, grouping, selected columns and joins
    • Amélioration
    • 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
    • Correction d'un bug
    • 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
    • Amélioration
    • 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
    • Amélioration
    • 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
    • Amélioration
    • 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
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  8. Loading of provider assemblies from a settings file is blocked
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  9. Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  10. QR code functions take one size value instead of width and height
    • Amélioration
    • mesures à prendre
    • Action needed before or after the upgrade.
  11. Data is loaded in the background while a session is idle
    • Amélioration
    • 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.
  12. New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5
    • Amélioration
    • 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.
  13. Invantive License Service: clearer messages, grace period and new modules
    • Amélioration
    • 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.
  14. Big Data JSON reads files much faster and skips files that cannot match
    • Amélioration
    • 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.
  15. Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs
    • Amélioration
    • 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.
  16. Exact Online incremental tables reload less often and are read faster
    • Amélioration
    • 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.
  17. Data containers and credentials from Invantive Credentials Server
    • Amélioration
    • 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.
  18. IP address validation configurable with allow lists, deny lists and ranges
    • Amélioration
    • 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.
  19. Proxy and load balancer set-up through a ForwardedHeaders section
    • Amélioration
    • 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.
  20. Filters no longer lose rows or evaluate wrongly
    • Correction d'un bug
    • 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.
  21. Exact Online incremental data is no longer damaged or overwritten
    • Correction d'un bug
    • 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.
  22. Error answers follow the Accept header
    • Amélioration
    • 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.
  23. Error answers follow the Accept header: HTML, JSON, Markdown or XML
    • Amélioration
    • Error answers are written in the format the client asks for. Data requests answer with JSON unless the client prefers another format. The error page no longer shows the user name, e-mail address or company of the signed-in user, because error pages are pasted into mails and forum posts. Requests for XSL files also send an Accept header.
  24. Pipedrive platform
    • Amélioration
    • Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.
  25. Scripts can run operating system commands with the new package dbms_os
    • Amélioration
    • 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.

Toutes les améliorations

Modifications apportées au comportement, aux plateformes, aux chauffeurs et aux paramètres, regroupées par domaine.

Importance: tout | 2 et plus | 3 et plus | 4 et plus | 5

Plate-forme: tout | AccountView (1) | ActiveCampaign (3) | AFAS (1) | AFAS Online (3) | Autotask (1) | Big Data JSON (1) | Brevo (2) | Bridge Online (4) | CBS (1) | Chargebee (1) | Crisp (4) | Data Cache (1) | DeepL (1) | Discourse (1) | Dropbox (1) | Dynamics 365 CRM (2) | Dynamics CRM (2) | Easyflex (1) | EDIFACT (1) | Exact Online (33) | 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 (2) | Invantive Bridge Online (1) | Invantive Business (1) | Invantive Estate (1) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (2) | Magento (3) | MariaDB (1) | Matomo (2) | Mendix (1) | Microsoft Access (1) | Microsoft Dynamics CRM (1) | Microsoft Graph (1) | MySQL (10) | Nextcloud (1) | Nmbrs (2) | OData (1) | ODBC (3) | Odoo (4) | Open Archives (1) | Open Besluitvorming (1) | Oracle (14) | PayPal (2) | Pipedrive (1) | PostgreSQL (14) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | SnelStart (5) | SQL Server (13) | Stripo (2) | Teamleader (1) | Teamleader Focus (2) | TeamViewer (1) | Tixly (1) | Tweede Kamer (2) | Twinfield (7) | VIES (1) | Visma Severa (1) | Visma.net (5) | Wikipedia (1) | WMI (1) | XAA (1) | XAF (1) | Yuki (4)

33 sur 368 affiché(s).

Licensing and sign-in

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.

Que faire ?

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

  • mesures à prendre
  • Exact Online
  • importance 4

Service area of Invantive Cloud

A sign-in that fails because the user withdrew consent for the application now gives a specific error with a hint.

  • Exact Online
  • importance 2

SQL engine

Fill estimated latency and throughput of tables with defaults, including Exact Online

Tables and views of the drivers now carry an estimated latency and estimated rows per minute, so that a client can judge which table is cheapest to read. Exact Online uses different default figures for the standard, bulk, sync and incremental tables.

  • Exact Online
  • importance 2

Platforms and drivers

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
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
Add the company name to the Exact Online balance lines per period view

The view with balance lines per period for all periods now returns the name of the company in a new column.

  • Exact Online
  • importance 2
Exact Online: a supplier item note column can be empty

The column that indicates whether notes are copied for a supplier item is now optional.

  • Exact Online
  • importance 2
Exact Online: longer general ledger classification code

The maximum length of the general ledger classification code is extended from 30 to 60 characters.

  • Exact Online
  • importance 2
Report a maximum length of 60 for YourRef columns in Exact Online

The YourRef columns of several Exact Online entities now report a maximum length of 60 characters. Some of them reported 30 or no length before.

  • Exact Online
  • importance 2
Recognise more forms of the Exact Online invalid callback URL error

The message about an invalid callback address is recognised in more wordings and shows the address.

  • Exact Online
  • importance 1
Report the retrieval duration of the Exact Online row counts view with decimals

The column with the retrieval duration in milliseconds of the Exact Online row counts view now has a decimal data type instead of a whole number.

  • Exact Online
  • importance 1

Export and import

Omit a result set without rows when the statement asks for it

A result set can carry an execution hint to be left out of the export when it has no rows. This avoids empty worksheets for result sets that only exist to report problems, such as companies on which Exact Online refused a table.

  • Exact Online
  • importance 2

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

Toutes les corrections de bogues

Problèmes de l'ancienne version qui ont été corrigés.

Licensing and sign-in

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

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
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
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
Do not send virtual fields to the Exact Online REST API

Insert and update statements sent fields to Exact Online that do not exist at the platform.

  • Exact Online
  • importance 2
Exact Online: duplicate Budgets table definition removed

The Exact Online REST driver defined the table Budgets twice; the second definition had unrelated columns of CRM accounts. Only the correct definition is kept.

  • Exact Online
  • importance 2
Exact Online: primary key columns repaired on five tables

Five Exact Online tables had a missing or invalid primary key column. The primary key is now defined.

  • Exact Online
  • importance 2
Exact Online: views that need the XML API fail when the XML API is switched off

With use-xml-api set to false, views based on the Exact Online XML provider, such as FinancialYearsExtended, are now left out instead of failing when used.

  • Exact Online
  • importance 2
Repair a recursion failure on complex Exact Online queries

A very complex query on Exact Online ended in a recursion error (itgenoda061). It is now handled.

  • Exact Online
  • importance 2

A list that had to be sorted on several keys was sorted on the last key only. Catalogue, schema and table names of Exact Online, and links read from a sitemap, now follow the intended order.

  • Exact Online
  • importance 1

Export and import

A file action that cannot be registered no longer fails the read, write or delete

Registering a file read, write or delete for the session overview threw an error when there was no session, which could make a successful file operation fail. A failed registration is now only recorded as a warning. Deleted files are registered as deletes.

  • Exact Online
  • importance 2

Logging and diagnostics

Correct the number of rows counted for Exact Online XML and for Excel, JSON and XML files

The number of rows reported in the statistics of these reads was not complete.

  • Exact Online
  • importance 2

Sur quoi cela s'appuie-t-il ?

Genre Nom De À
invantive component Invantive Data Access Point 26.0.336 27.0.54
invantive component Invantive(R) Basics 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

Plus d'informations

Comment cette note a été rédigée

  • 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.
  • 1035 liens entre une modification et un commit source sont enregistrés.
  • 39 exclusions sont consignées dans le rapport d'audit de la note.