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. |
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
This Note
Groups
- Data model 38
- Provider attributes 2
- Capabilities 0
- Performance 1
- Bug fixes 0
- Enhancements 0
- Log-on and platform 1
More
What Changed, by Group
Every change is in one group: the group answers the question that you ask before you upgrade.
- Data model
- 38
- Do my statements and views still work?
- Provider attributes
- 2
- Do I have to change my connection string, provider file or settings?
- Capabilities
- 0
- What can the driver do with a table?
- Performance
- 1
- Is it faster, and does it call the platform less?
- Bug fixes
- 0
- Is the defect that I met repaired?
- Enhancements
- 0
- What can I do now that I could not?
- Log-on and platform
- 1
- Do I have to log on again, or change something because of the platform?
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.
- Use version 1.1 of the Open Archives API with new table functions
- Log-on and platform
- Importance 4 of 5.
- Table function OPENARCH.OPENARCH.openarch_archive_record_statistics is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_births is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_breakdown is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_census is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_deaths is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_event_types is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_family_names_by_place is added
- Data model
- Importance 3 of 5.
- Table function OPENARCH.OPENARCH.openarch_marriages is added
- Data model
- Importance 3 of 5.
- Driver setting technical documentation url changes
- Provider attributes
- Importance 3 of 5.
- Read answers of the platform with less memory
- Performance
- Importance 2 of 5.
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
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
OPENARCH.OPENARCH.openarch_archive_statistics: 1 added, 0 removed, 0 changed+archive_name(varchar2)
OPENARCH.OPENARCH.openarch_archives: 2 added, 0 removed, 0 changed
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
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
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
- Data model documentation of the driver
- Questions and answers on the forum
- Invantive Cloud page of the driver
- Documentation of the platform
- All release notes
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.