invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of OpenArch

Driver Release Note - Cloud

OpenArch driver 27.0, from 26.0

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

Data models compared: 26.0.340-PROD+6295 and 27.0.6-PROD+6293.

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

  • 42 changes
  • 0 can break a statement
  • 0 groups not available

What Changed, by Group

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

Download Changes as CSV

Before You Upgrade

No change of this step is marked as breaking.

Top 11 Changes

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

Data model

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

  • 38 changes
  • model files

Tables, Views and Table Functions

Table function OPENARCH.OPENARCH.openarch_archive_record_statistics is added

The table function has 3 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_births is added

The table function has 14 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_breakdown is added

The table function has 3 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_census is added

The table function has 5 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_deaths is added

The table function has 14 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_event_types is added

The table function has 4 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_family_names_by_place is added

The table function has 2 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_marriages is added

The table function has 14 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_matches is added

The table function has 6 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_professions_by_place is added

The table function has 2 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_source_types_by_archive is added

The table function has 4 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_transcription is added

The table function has 11 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_transcription_inventories is added

The table function has 4 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_transcriptions is added

The table function has 9 columns and can select.

  • importance 3
Table function OPENARCH.OPENARCH.openarch_weather is added

The table function has 10 columns and can select.

  • importance 3

Columns

8 added, 0 removed, 2 changed, in 5 tables.

OPENARCH.Native.NATIVEPLATFORMSCALARREQUESTS: 0 added, 0 removed, 2 changed

  • ~ DURATION_MS (database_data_type: int64 → double)
  • ~ DURATION_MS (dotnet_data_type: int64 → double)

OPENARCH.OPENARCH.openarch_archive_statistics: 1 added, 0 removed, 0 changed

  • + archive_name (varchar2)

OPENARCH.OPENARCH.openarch_archives: 2 added, 0 removed, 0 changed

  • + isilcode (varchar2)
  • + search (varchar2)

OPENARCH.OPENARCH.openarch_archives_by_name: 3 added, 0 removed, 0 changed

  • + archive_org (varchar2)
  • + person_id (varchar2)
  • + url (varchar2)

OPENARCH.OPENARCH.openarch_persons_per_year: 2 added, 0 removed, 0 changed

  • + archive_code (varchar2)
  • + url (varchar2)

Parameters, Packages and Procedures, Keys and Code Values

Parameter archive_code is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter birthplace is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter country_code is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter eventplace is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter lang is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter not_archive is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter number_show is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter number_show is added to OPENARCH.OPENARCH.openarch_persons_per_year

Optional.

  • importance 2
Parameter relationtype is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter sort is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter sourcetype is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Parameter start is added to OPENARCH.OPENARCH.openarch_archives_by_name

Optional.

  • importance 2
Procedure dcr_metadata.get_partitions is removed
  • importance 1

Provider attributes

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

  • 2 changes
  • model files

Driver setting technical documentation url changes

Technical documentation url changes from https://www.openarch.nl/api/docs/ to https://www.openarchieven.nl/api/docs/.

  • https://www.openarch.nl/api/docs/ → https://www.openarchieven.nl/api/docs/
  • importance 3
Engine-wide connection attributes change

28 attributes added, 2 removed and 5 settings of attributes changed. These attributes belong to the SQL engine and exist for every driver; the Query Tool notes describe them.

  • importance 2

Capabilities

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

  • 0 changes
  • model files

No changes in this group.

Performance

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

  • 1 changes
  • commits

Read answers of the platform with less memory

The driver reads the JSON answers of the platform with a reader that allocates less memory. Large downloads put less load on memory and garbage collection.

  • importance 2
  • confidence medium

Bug fixes

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

  • 0 changes
  • commits

No changes in this group.

Enhancements

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

  • 0 changes
  • commits

No changes in this group.

Log-on and platform

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

  • 1 changes
  • commits

Use version 1.1 of the Open Archives API with new table functions

The driver now reads from version 1.1 of the Open Archives API and adds table functions for births, deaths, marriages, matches, statistics, weather, census and transcriptions. Page sizes follow the limit of the platform, and a count asks the platform for one row only. Filters on columns are applied after the rows were read. Requests carry a descriptive user agent.

  • importance 4
  • confidence medium

In Numbers

Objects of the data model at both ends of the step.

Objects 26.0 27.0 Change
tables 5 5 +0
views 1 1 +0
table functions 0 0 +0
columns 75 188 +113
function parameters 8 87 +79
attributes of driver 0 0 +0
tables that can insert 1 1 +0
tables that can update 0 0 +0
tables that can delete 0 0 +0

More Information

How This Note Was Made

  • 2026-11-01T10:40:19.0105344Z
  • 2026-11-01T12:55:20.1654518Z
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Fields that only the newer model has.
  • Commit items were classified by one reader; the model changes are derived and need no reading.
  • Commits: the commits of the driver directory in the range that have no equivalent patch in the older state, without merges and version stamps; each was classified by reading its message and change.
  • Model: the NDJSON files of data-models/database of the workspace of each release are compared record by record; only fields that both models have are compared, and texts are counted, not listed.
  • A model generated from a later build of the same release (for example 26.0.340 for 26.0) stands for the release.
  • 39 links between a change and a source commit are recorded.