Hi,
I'm pretty sure I'm not the first one to encounter this, so please share your solution
I'm trying to load a package with 2 dependencies, one of them has 5 dependencies..
is there a better tool / script / wizard for that?

Hi,

I'm trying to run an SQL against Backup.Task table.

There is this class:

Class Backup.Task

documented here:

Hi Guys,

I've the below code to build JSON and send it via httpRequest called from business Operation.

But I'm getting this error, which I'm guessing that the formulated JSON doesn't have the correct format, so I was looking to convert the JSONStream to JSON string and try to validate it so see where the JSON is broken, problem is that I'm expecting that there will thousands of records in this JSON so it will hard to go through it, so is there a way to track for error or why this JSON is failing to send    

Thanks

Hi Everyone,

We are looking for a way to disable production Business Services concurrently so that the whole process takes shorter amount time than just going sequentially in a loop and disable them one at a time (very slow). This is necessary for us to be able to stop all traffic to IRIS so that no data remains after we perform full production stop. 

Thank you!   

How can I remove UNIQUE NOT NULL from an existing column via DDL?

I currently have a table in production that was originally created via DDL, where the column was defined as UNIQUE NOT NULL:

CREATE TABLE database.Books ( ID %Library.UniqueIdentifier PRIMARY KEY, TagExternal VARCHAR('') UNIQUE NOT NULL,  

I now need to change this column so that it is no longer UNIQUE and no longer NOT NULL, making it equivalent to:

TagExternal VARCHAR(''),

As promised, here comes the second part.

But before I begin, here's the view from my hotel window in Boston, where I went before the READY. And a grand building on the right is the office of InterSystems. Not bad, ha?

Anyway, after getting some sleep after the Demos and Drinks the day before, we were back at it the next day, which started with more keynotes.

Was wondering if anyone had a Dynamic way to see if a Global is still being used by a Class File. 

We have been monitoring our Global Size recently, and I am trying to find problematic Class files that are not being cleaned up or used appropriately. I have come across some globals that do not seem to have a Class attached to them anymore, and instead of deleting globals 1 by 1, I was looking for a way that we could dynamically do this since the globals have data that is stale in them.

Thanks

Scott

Hi! 
We are working on containerizing our IRIS product. We want to extract the message log that is shown in the terminal, but if possible, we want to format the output as JSON and include some extra fields from the instance to enhance our monitoring. Is this possible?
Any guide or example about it?
Thanks!

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ Triage Chatbot

We are using IRIS for Health to develop an agentic AI chatbot workflow that can interact with a patient using voice commands, reach out to an EHR or other system for context, and provide recommendations back.

Presenters: 
🗣 @Vic Sun, Sales Engineer at InterSystems 
🗣 @Brad Nissenbaum, Sales Engineer at InterSystems 
🗣 Danielle Micciantuono, Clinical Solutions Specialist at InterSystems

I have a question around mapping between different datasets during the HL7 -> SDA3 -> FHIR transformation.

We have a FHIR server which uses the standard ISC HL7->SDA3->FHIR conversion when ingesting HL7 messages. There is the odd requirement to enrich FHIR data from the original HL7 message. due to site specific HL7. Our approach is to extend HS.Gateway.HL7.HL7ToSDA3 with a custom GetSDA method that includes the original HL7 Message ID via CustomPairs.

I am configuring a set of Linux (RHEL 9) servers to operate as an IRIS 2025.1 mirror set. Mirroring traffic is using TLS, so each IRIS server has the necessary TLS configurations. However installation of ISCAgent on the dedicated arbiter host didn't make any mention of TLS or certificates. Nor did I find anything about this when searching IRIS documentation.

Am I missing something? Does the traffic between the IRIS hosts and the arbiter host use TLS? Should I be installing any certs on the arbiter host to facilitate secure communication?

Abstract

Solar irradiance forecasting is critical for grid stability in photovoltaic (PV) power plants. This article replicates and extends the methodology of Lara-Benítez et al. (2023) "Short-term solar irradiance forecasting in streaming with deep learning" replacing the original offline simulation with a fully operational streaming pipeline built on InterSystems IRIS. We leverage IRIS Interoperability Productions as the streaming backbone, Embedded Python to run MLP, LSTM, and CNN deep learning models, and IntegratedML as an AutoML baseline.

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ HL7 Validation Error Profiler: Rapid Insights into Batch HL7 Data Quality Issues

This demo highlights how HL7 validation logs can be transformed into scalable, actionable data quality insights using a lightweight application built on top of Health Connect.

• Batch ingestion and parsing of HL7 validation error logs into structured data
• Aggregation of errors by segment, field, and type to reveal systemic issues
• Interactive dashboard (Streamlit) for filtering, exploration, and root cause analysis
• Rapid identification of top error patterns across entire data feeds
• Natural language chatbot for intent-driven data investigation and querying
• PDF report generation for sharing clear, evidence-based feedback during data source onboarding 

Special thanks to @Henry Wojnicki for his contributions to designing and refining the application workflow.

🗣 Presenter: @Lynn Wu, Sales Engineer at InterSystems

Hello everyone,

The Certification Team of InterSystems Learning Services is excited to announce the release of our new InterSystems IRIS SQL Professional exam. It is now available for purchase and scheduling in the InterSystems exam catalog. This exam is geared towards IRIS SQL experts, and it deals with a variety of advanced IRIS SQL topics that you can find in the exam page.

Despite the fact that LOCK (docs) is a foundational part of InterSystems IRIS, responsible for concurrency, there is not a lot of discussion on the Developer Community about it. Which is understandable, considering it's stable and fairly low-level command. In this article, I will show a simple example of how to use locks with interoperability.

This article introduces SHAP explainability methods as an approach to understand the reasons behind predictions in machine learning black-box models. It also includes a simple Jupyter notebook that you can use and modify to gain hands-on experience with these concepts:

https://www.kaggle.com/code/jorgeivnjh/explainability-in-ml-models

https://github.com/JorgeIvanJH/Explainability-in-ML-models

We will leverage these concepts for a future implementation in our Continuous Training Pipeline: https://community.intersystems.com/post/complementing-iris-mlflow-continuous-training-ct-pipeline

Okay… first things first - sorry it took me so long to write this up. There was just too much happening, too many conversations, too many photos, too much travel and honestly… too much excitement to sit down and write right away.

READY 2026 started the way it always does, with that unique mix of anticipation and energy in the room. Look at these excited faces! 

@Gabriel Ing, @Mariam Makhmutova, @Olga Zavrazhnova, @Dean Andrews, @Anastasia Dyubaylo, @Iryna Mykhailova 

(Let's be honest, this was the end, and everyone was happy that we survived 😁)

When managing critical healthcare data through an integration engine you want to know the moment a queue starts backing up or a service drops. 

Unfortunately, this usually leads to an email inbox stuffed full of notifications that can sometimes seem impossible to maintain.

Well, I’ve not solved that problem. 

But I have created something that could help...

Hey Community,

Round 1 of the Community Bounty Program "Idea to Application" is officially open. Three ideas from the Ideas Portal are ready to be implemented — pick one or more, build it, publish it on Open Exchange, and earn Global Masters points. 

🏅Every qualifying submission earns a Credly badge, Global Masters badge, and 10k+ points. Implement all ideas this round and unlock Tier 2 rewards.

Hi Guys,

I've the following code:

and I would like to convert the resulting json from JSONStream to JSON string?
thanks  

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ Message Operational Data Store

Create an operational data store using the data flowing through your production. Create user-defined analytics tables based on fields and paths to their data from incoming documents with varying standards (FHIR, CDA, HL7v2, etc.).

Presenters: 
🗣 @Kwabena Ayim-Aboagye, Sales Engineer at InterSystems
🗣 @Christopher Carmichael, Sales Engineer at InterSystems
🗣 @Jeff Semmens, Senior Sales Engineer at InterSystems

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ AI-Assisted Rare and Complex Disease Detection

This demo shows how InterSystems Health Gateway can be used to pull in outside patient records from networks like Carequality, CommonWell, and eHealth Exchange, creating a more complete longitudinal view in a clinical viewer. That full record is then analyzed by AI to surface potential rare disease considerations with clear reasoning, helping clinicians see patterns they might otherwise miss.

Presenters: 
🗣 @Jesse Reffsin, Senior Sales Engineer at InterSystems
🗣 @Georgia Gans, Sales Engineer at InterSystems
🗣 @Annie Tong, Sales Engineer at InterSystems

#North American Demo Showcase entry. 

>> Answer the question below to be entered in the raffle!

⏯️ AI Assistants for the Unified Care Record Powered by Gemini

In this demo, you will see how Gemini works directly with FHIR data, and how it leverages the harmonized dataset provided by InterSystems Unified Care Record. It also showcases multiple AI assistants helping multiple groups of users, e.g. clinicians, patients.

🗣 Presenter: @Simon Sha, Sales Architect at InterSystems

As an experiment in agentic coding in ObjectScript I'm using VS Code to try and create an implementation of an SFTP server.

SFTP is built on top of SSH, so the first phase involves implementing an SSH server. While working on the KEX part of that the agent (using GPT-5.3-Codex) reported:

1. IRIS has what we already need for signing and hashing: RSASHASign, RSASHAVerify, RSAGetLastError, SHAHash, SHA1Hash, SHA3Hash.
2. It does not list a Diffie-Hellman key exchange or modular exponentiation API in %SYSTEM.Encryption.

It then offered these options:

1. Keep using IRIS APIs for cert/key/sign/hash.