InterSystems Official
· Jan 31, 2023

InterSystems announces General Availability of InterSystems IRIS, IRIS for Health, HealthShare Health Connect, & InterSystems IRIS Studio 2022.3

InterSystems is pleased to announce the 2022.3 release of InterSystems IRIS Data Platform, InterSystems IRIS for Health, HealthShare Health Connect, and InterSystems IRIS Studio are now Generally Available (GA).

2022.3 is a Continuous Delivery (CD) release. Many updates and enhancements have been added in 2022.3, in SQL management, cloud integration, Kafka and JMS adapters, the SQL Loader, and other areas. The new FHIR SQL Builder and enhancements to Columnar Storage are included, but both are still experimental features (not for production, with an active Early Access Program in place).  

 

Release Highlights

Platform Updates

InterSystems IRIS Data Platform 2022.3 expands support to include the following new & updated operating systems for production workloads:

  • Oracle Linux 9
  • SUSE 15 SP4.

SQL Enhancements

InterSystems IRIS SQL now offers a machine-readable format for query plans. Using this new option, the $SYSTEM.SQL.Explain() method will now produce a JSON-based rendering of the query plan with significantly more detail on the plan itself as well as the tables and indices it accesses. Where the previous XML-based format used simple English phrases to describe different steps, the new format is easier to consumer for tools that wish to perform more thorough analysis or graphical rendering of query plans. 

This release introduces an opt-in capability to sample runtime parameters for SQL statements. The Statement Index already records a rich set of metadata such as detailed runtime statistics and query plans for each statement, which typically has any literals substituted for placeholders that parameterize the cached query code. Now, the statement index can be extended with a sampling of the actual runtime values for those parameters. These can then be combined with the normalized statement text to, for example, build a representative workload that can be run against another deployment, for example to benchmark a new hardware environment or experiment with a different set of indices for the schema. 

InterSystems IRIS SQL now supports CREATE SCHEMA and DROP SCHEMA commands to include in scripts for setting up and tearing down your application environment.  

Speed, Scale, & Security

This release offers full elasticity for InterSystems IRIS Sharded clusters. DBAs can now call an API method to mark a shard for removal. Once this method is issued, data immediately gets offloaded from the designated shard to other data nodes in the cluster and automatically disconnect the node when all data buckets have been successfully moved to other shards. This process leverages the same mechanism as Online Rebalancing, meaning users can continue to query sharded tables and ingest data into them while the data is being moved.  

Analytics & AI

  • Updated version of InterSystems Reports (Logi Report 19.2):  Key improvements are:
    • Bookmark feature - save parameters and filters on a web report
    • Report Studio available on the Report Server to provide additional report editing directly from Server
  • Updated version of Adaptive Analytics (AtScale 2022.3) Key improvements are:
    • Support for the timeline feature in Microsoft Excel
    • Data Catalog API to expose the AtSCale Semantic Layer to data catalog vendors

More details on all these features are available through these links below:

 

How to get the software

As usual, CD releases come with classic installation packages for all supported platforms, as well as container images in Docker container format.  For a complete list, refer to the Supported Platforms document.

Installation packages and preview keys are available from the WRC's Continuous Delivery Releases site or through the evaluation services website.

InterSystems IRIS Studio is available from the Components distribution page.

Container images for both Enterprise and Community Editions of InterSystems IRIS and IRIS for Health and all corresponding components are available from the new InterSystems Container Registry web interface.

yesFor additional information about docker commands, please see this post:: Announcing the InterSystems Container Registry web user interface. The build number for this developer preview release is 2022.3.0.606.0


FHIR SQL Builder

As we described before, FHIR SQL Builder is an experimental feature and is part of an active EAP (Early Access Program).To get access to this feature, please, email Patrick Jamieson, Product Manager for IRIS for Health at patrick.jamieson@intersystems.com.

Discussion (3)2
Log in or sign up to continue

Good to know, that now it's available for both platforms by the same name

$ docker manifest inspect containers.intersystems.com/intersystems/iris-community:2022.3.0.606.0                                                                                                                                             
{
   "schemaVersion": 2,
   "mediaType": "application/vnd.docker.distribution.manifest.list.v2+json",
   "manifests": [
      {
         "mediaType": "application/vnd.docker.distribution.manifest.v2+json",
         "size": 1584,
         "digest": "sha256:a9ad0e317042db836f3fb620200a0a269543a03714da475232b1a47ce8ce7839",
         "platform": {
            "architecture": "amd64",
            "os": "linux"
         }
      },
      {
         "mediaType": "application/vnd.docker.distribution.manifest.v2+json",
         "size": 1584,
         "digest": "sha256:80ffdd649c7ad9bc7d94a97538a88b0f11e15961a2ef9ea12715dba5ba2631a6",
         "platform": {
            "architecture": "arm64",
            "os": "linux",
            "variant": "v8"
         }
      }
   ]
}

A note on the InterSystems Reports and Adaptive Analytics components:

Adaptive Analytics and InterSystems Reports are released independently of InterSystems IRIS but we group them in with the release announcement.  Adaptive Analytics v 2022.3 and InterSystems Reports v19.2 are available from the Components distribution page and the InterSystems Reports Server v19.2 container is available from the InterSystems Container Registry.