documentatie van Invantive
Invantive Support ForumsAanmelden / Inschrijven

Release-opmerkingen van Invantive Studio

Release Note - Installatieprogramma

Invantive Studio 27.0, van 26.0

Bouwen Datum Omschrijving
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.

  • 189 verbeteringen
  • 156 foutcorrecties
  • 14 wat je moet controleren voordat je een upgrade uitvoert

Voordat u de upgrade uitvoert

Deze wijzigingen moeten worden gecontroleerd:

Top 25 wijzigingen

  1. Settings files move from XML to JSON
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  2. More work is sent to the platform: row limit, grouping, selected columns and joins
    • Verbetering
    • 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
    • Foutcorrectie
    • 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
    • Verbetering
    • 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
    • Verbetering
    • 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
    • Verbetering
    • 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. The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  8. Exact Online companies outside the service area are no longer accepted
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  9. Loading of provider assemblies from a settings file is blocked
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  10. Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  11. QR code functions take one size value instead of width and height
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  12. Remove obsolete Invantive Script statements
    • Verbetering
    • actie nodig
    • Action needed before or after the upgrade.
  13. Data is loaded in the background while a session is idle
    • Verbetering
    • 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.
  14. New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5
    • Verbetering
    • 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.
  15. Invantive License Service: clearer messages, grace period and new modules
    • Verbetering
    • 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.
  16. Data containers and credentials from Invantive Credentials Server
    • Verbetering
    • 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.
  17. Big Data JSON reads files much faster and skips files that cannot match
    • Verbetering
    • 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.
  18. Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs
    • Verbetering
    • 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.
  19. Exact Online incremental tables reload less often and are read faster
    • Verbetering
    • 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.
  20. Filters no longer lose rows or evaluate wrongly
    • Foutcorrectie
    • 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
    • Foutcorrectie
    • 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. Pipedrive platform
    • Verbetering
    • Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.
  23. Scripts can run operating system commands with the new package dbms_os
    • Verbetering
    • 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.
  24. Add write support to AFAS Online
    • Verbetering
    • 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.
  25. Invantive Script statements are checked with a grammar, with better error messages
    • Verbetering
    • Statements of Invantive Script, such as local export results and local log on, are now read by a proper grammar. Keywords may be written in any case and options may follow in any order, while an option given twice or two contradicting options are refused. Errors name the problem more precisely. A few unused statements are withdrawn: the five results-clipboard statements and a variant of define encrypted.

Alle Verbeteringen

Wijzigingen in gedrag, platforms, Drivers en instellingen, gegroepeerd per gebied.

Belang: alle | 2 en hoger | 3 en hoger | 4 en hoger | 5

Platform: alle | AccountView (1) | ActiveCampaign (3) | AFAS (1) | AFAS Online (3) | AFAS Profit (1) | 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 (35) | File system (2) | Firebird (2) | Fortnox (1) | FoxPro (1) | Freshdesk (3) | Freshservice (2) | FTP (1) | Gripp (2) | 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 Credentials Server (1) | Invantive Estate (2) | Invantive Studio (6) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (2) | Magento (4) | 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 (2) | Open Besluitvorming (1) | Oracle (20) | PayPal (2) | Pipedrive (1) | PostgreSQL (14) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | SnelStart (5) | SQL Server (13) | Stripo (2) | Stripo Email (1) | Teamleader (1) | Teamleader Focus (2) | TeamViewer (1) | Tixly (1) | Tweede Kamer (2) | Twinfield (7) | VIES (1) | Visma Severa (1) | Visma.net (5) | Wikipedia (2) | Windows WMI (2) | WMI (1) | XAA (1) | XAF (1) | Yuki (5)

7 van 345 weergegeven.

SQL engine

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
  • belang 3

Platforms and drivers

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
  • belang 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
  • belang 3
Twinfield: clearer error when the cluster address is missing

A Twinfield request without an API address now fails with a specific error before the call is made.

  • Twinfield
  • belang 2

Translations and texts

More messages and hints in the language of the user

Error messages and hints of the engine and several drivers (OAuth, PostgreSQL, Tixly, Twinfield, Gripp, Crisp, Odoo) are available in more languages, Hindi is a known interface language, and singular units are used in durations.

  • Crisp
  • Gripp
  • Odoo
  • PostgreSQL
  • Tixly
  • Twinfield
  • belang 2

Alle Bugfixes

Verholpen fouten in de oudere versie.

Security

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
  • belang 3

Platforms and drivers

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
  • belang 3

Waarop het Voortbouwt

Soort Naam Van Aan
invantive component Invantive Studio 26.0.4 27.0.92
invantive component Invantive(R) Basics 26.0.4 27.0.92
invantive component Invantive(R) Producer GUI Base 26.0.4 27.0.92
invantive component Invantive(R) Producer Data Model 26.0.4 27.0.92
invantive component Invantive(R) Producer GUI 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) SQL for Windows 26.0.4 27.0.92
build tool Invantive Deploy 26.0.4 27.0.92
build tool change Installing and upgrading a .NET 10 product no longer runs the NGEN tool per assembly
build tool change Installer shows an error when another installation is already running
build tool change Final installer window shows the version link
build tool change Progress bar of the installer follows the measured duration of the installation stages
build tool change Installer windows flicker less when moving to the next step
build tool change Installer no longer stalls on an unreachable Customer Service and cancels reliably
build tool change Installer explains in a window why installation settings cannot be downloaded
build tool change Maintenance window checks that the product is still installed
build tool change Installer shows unexpected errors in its own window
build tool change Repair Office add-in name, optional email check and installs run as SYSTEM
build tool change Installs run as SYSTEM are attributed to the end user, not to the SYSTEM account
build tool change Each product gets one .NET 10 installer; the .NET Framework installer is no longer built
build tool change Installer includes the files .NET needs to find native libraries such as WebView2
build tool change Installer carries native runtime folders and Catalan, Hungarian and Romanian resources
build tool change Installer no longer includes the crash dump tool
build tool change Supported Windows versions in release information follow mainstream support dates
build tool change Installer writes its trace to the Invantive Trace folder when trace to file is on
build tool change Installer texts for new messages are available in all supported languages
build tool change Installer email step rejects example and test domains
third party summary

Meer Informatie

Hoe deze notitie tot stand is gekomen

  • 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.
  • 1029 koppelingen tussen een wijziging en een broncommit worden vastgelegd.
  • 27 uitsluitingen worden vastgelegd in het controleverslag bij de toelichting.