#InterSystems IRIS

Post a job Follow
19 Followers · 5.6K Posts

InterSystems IRIS is a Complete Data Platform
InterSystems IRIS gives you everything you need to capture, share, understand, and act upon your organization’s most valuable asset – your data.
As a complete platform, InterSystems IRIS eliminates the need to integrate multiple development technologies. Applications require less code, fewer system resources, and less maintenance.

Post a job Follow
Question Marco Bruni · Nov 28, 2025

Punctually access specific nodes of an XML document

Hello!
I have the following XML document obtained through a string:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<MainDocument xmlns="urn:hl7-org:v3">
<realmCode code="IT"/>
<title>kjbkjkjbkjb</title>
<effectiveTime value="20090905150716"/>
[.....other tags.....]
<versionNumber value="1"/>
<component>
<body>mhvjhjkvhj</body>
<component>
<section>content</section>
<ID>5</ID>
<title>Certificato</title>
<text/>
<entry>
<Id>5</Id>
[...other tags...]
</entry>
<entry>
<Id>6</Id>
[

#InterSystems IRIS #ObjectScript #XML
7
0 112
Article Dmitry Maslennikov · Dec 8, 2025 8m read

When SQLancer Meets IRIS: What Happens When We Push a Database to Its Limits

Modern SQL engines are enormously complex pieces of software. Even when they appear stable and mature, subtle bugs can hide in their optimizers, type systems, predicate evaluation, or execution layers. These bugs rarely announce themselves loudly. Instead, they quietly produce incorrect results, behave inconsistently, or fail abruptly under specific combinations of SQL constructs.

This is precisely why tools like SQLancer exist. SQLancer automatically generates SQL queries and uses logical “oracles” to detect when a database behaves incorrectly. It has revealed hundreds of real bugs in widely used systems such as MySQL, PostgreSQL, SQLite, and DuckDB.

With this in mind, I attempted to bring SQLancer to InterSystems IRIS, starting with the NOREC oracle — a powerful method for detecting optimizer correctness issues. The journey, however, uncovered not just potential SQL correctness problems, but also a surprising number of driver-level and server-level failures that prevented SQLancer from running at full strength.

This article summarizes why SQLancer is important, how the NOREC oracle works, and what unexpected findings appeared while testing IRIS.

#InterSystems IRIS #SQL
Open Exchange
3
1 138
Article Joan-Baptista Fabregas · Dec 8, 2025 4m read

Scripting with .Net core 10 and Iris SDK

One of the newest features of .Net core 10 with C# 14 is the file-based apps. This feature allows you to execute C# code in a simple .cs file without the need to create a solution, a project, or any of the related structure.

For example you can create a script.cs file using the notepad with the content: 

Console.WriteLine(“This is a script in c#.”);

Then in the command line or the terminal you execute the command:

dotnet run script.cs

There is plenty of information about this new feature of .net 10.

#InterSystems IRIS #.NET #Code Snippet
0
0 76
Article Emil Polakiewicz · Dec 8, 2025 19m read

Step-by-Step Guide: Setting Up RAG for Gen AI Agents Using IRIS Vector DB in Python

How to set up RAG for OpenAI agents using IRIS Vector DB in Python

In this article, I’ll walk you through an example of using InterSystems IRIS Vector DB to store embeddings and integrate them with an OpenAI agent.

To demonstrate this, we’ll create an OpenAI agent with knowledge of InterSystems technology. We’ll achieve this by storing embeddings of some InterSystems documentation in IRIS and then using IRIS vector search to retrieve relevant content—enabling a Retrieval-Augmented Generation (RAG) workflow.

Note: Section 1 details how process text into embeddings.

#InterSystems IRIS #Internal Tech Article Contest #API #Business Service #Generative AI (GenAI) #Python #SQL #Vector Search
Open Exchange
0
0 70
Announcement Larry Finlayson · Dec 8, 2025

Managing InterSystems Servers – Virtual January 5-9, 2026 / Registration space available

Managing InterSystems Servers – Virtual  January 5-9, 2026

  • Configure, manage, plan, and monitor system operations of InterSystems Data Platform technology

  • This 5-day course teaches system and database administrators how to manage InterSystems® Data Platform technology which powers all of our products.

  • Learn to install, configure and secure the data platform, configure for high availability and disaster recovery, and monitor the system.

  • Students also learn troubleshooting techniques.

SELF REGISTER HERE

#InterSystems IRIS #InterSystems IRIS for Health
0
0 53
Article Ashok Kumar T · Nov 10, 2025 2m read

FastJsonSchema: Native High-Performance JSON Validation for IRIS

FastJsonSchema: High-Performance JSON Validation in IRIS

Validating JSON data against JSON Schema is a common requirement for modern applications. FastJsonSchema brings this capability natively to InterSystems IRIS, combining speed, simplicity, and full schema compliance.

Unlike traditional validation approaches, FastJsonSchema generates native ObjectScript code from your JSON Schemas and compiles it directly to iris object code, enabling idiomatic performance without relying on external libraries or runtimes.

#HealthShare #InterSystems IRIS #InterSystems IRIS for Health #TrakCare #Health Connect #Access control #JSON #ObjectScript #Performance #REST API
Open Exchange
1
0 101
Article Pietro Di Leo · Dec 8, 2025 4m read

Introducing IRIS IO Utility: A VS Code Extension for Data Import/Export with InterSystems IRIS

Hello Developers! 👋
I’m excited to introduce IRIS IO Utility, my submission for the InterSystems "Bringing Ideas to Reality" Contest 2025. This VS Code extension provides you an intuitive and powerful interface for importing and exporting data without leaving your IDE. The extension implements and expand this idea submitted on the Ideas Portal turning a common developer need into a real tool: seamless IO operations with any IRIS instance directly inside VS Code.

#InterSystems IRIS #Cloud #Contest #Data Import and Export #ODBC #SQL #VSCode
Open Exchange
0
0 98
Question Matheus Augusto · Nov 25, 2025

Regarding best practices for integration between different datasets and namespaces.

In some cases, it's necessary to manipulate data from one namespace to another. For example, a routine in the "N1" namespace needs data from the "N2" namespace. In legacy systems (using only globals), it's common to make the global universal, but what about persistent classes? Is this type of globalization also possible?

In the same context, how could I make a persistent class global for all namespaces? The only way I know is by putting it in %SYS.

#Caché #InterSystems IRIS #InterSystems Business Solutions and Architectures #Key Question
7
0 124
Question Norman W. Freeman · Nov 5, 2025

Non ascii characters got considered as a question mark inside regex engine. Is this a bug ?

The following regex is matching while I think it should not :

write $match("♥","\?") //print '1' (unexpected)

It should only match the '?' character. I think what happen is the ♥ character got converted to '?' (as it's not within regular ascii range) before being validated by the regex engine.

In fact, this give a clue about what happen : 

write $char($ascii("♥")) //print '?'

Is this an IRIS well known limitation, is there workarounds ? Should I report it to InterSystems ?

In my case, a way to detect non standard ascii code in a string will be good enough.

#InterSystems IRIS #Key Question
8
0 120
Article David Hockenbroch · Dec 4, 2025 6m read

Sub-Table Security

InterSystems IRIS provides extensive configurable security options, yet many developers primarily use roles and resources to secure entire tables or routines. Today, we will delve deeper. We can also secure individual columns and rows separately, but these two mechanisms operate very differently. Let's begin with the columns.

Column Security

For testing and demonstration, we will keep our table structure concise and straightforward. We have a table called "Person" in the USER namespace that contains an ID column, a date of birth column (DOB), first name, and last name. 

#InterSystems IRIS #Access control #Management Portal #ObjectScript #Security #SQL #System Administration
0
1 273
Question Scott Roth · Nov 6, 2024

Histogram data being pushed to github

There are a select few in the group that have been using Github as a Local Client push to a Repository setup in GitHub. Questions were brought up today about the security, and possible issues when it comes to data being pushed in this method.

Looking over code we have noticed that there is Histogram data within some of the class files that could be considered a security issue. Does anyone else have concerns with the Histogram data being within the class files pushed up to github?

#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #Change Management #Git #GitHub #VSCode
2
0 177
Article Timothy Leavitt · Dec 4, 2025 2m read

Temp Files and Singletons: Cleaning Up After Yourself

There's a pattern I've encountered several times where I need to use a temp file/folder and have it cleaned up at some point later.

The natural thing to do here is to follow the patterns from "Robust Error Handling and Cleanup in ObjectScript" with a try/catch/pseudo-finally or a registered object to manage cleanup in the destructor. %Stream.File* also has a "RemoveOnClose" property that you can set - but use with care, as you could accidentally remove an important file, and this flag gets reset by calls to %Save() so you'll need to set it back to 1 after doing that.

There's one tricky case, though - suppose you need the temp file to survive in an enclosing stack level. e.g.:

#InterSystems IRIS #ObjectScript
0
0 91
Discussion Benjamin De Boe · Dec 4, 2025

How do you like to build your AI solutions with InterSystems IRIS?

Hi,

We're working on new capabilities to help you build Agents and AI applications faster with InterSystems IRIS. In order to better understand which entry points and development methodologies would help you most, we've created this brief survey: Building AI solutions with InterSystems IRIS. 

Filling it in should not take much more than 5 minutes, and your feedback on this exciting topic will help us fine tune our designs and prioritize the right features.

Thanks in advance!
benjamin
 

#InterSystems IRIS #InterSystems IRIS for Health #Artificial Intelligence (AI) #Generative AI (GenAI) #Large Language Model (LLM)
0
0 81
Article Mikhail Khomenko · Dec 3, 2025 28m read

Security in IRIS

Security is fundamental to enterprise application development. InterSystems IRIS provides a comprehensive security framework that protects data, controls access, and ensures compliance. This guide introduces essential security features for developers new to IRIS, covering authentication, authorization, encryption, and practical implementation strategies.

#InterSystems IRIS #Access control #DevOps #Docker #Security #System Administration
0
3 258
Article José Pereira · Dec 2, 2025 12m read

Understanding SQL Window Functions (Part 3)

In this final part of our introduction to Window Functions, we will explore the remaining functions that have not been covered yet. You will also discover performance tips and a practical guide to help you decide when (and when not) to use window functions effectively.

1. Offset and Positional Value Functions

Overview

These functions reference values are calculated from other rows relative to the current row, or they are extracted from the first, last, or nth values within a window.

  • LAG(column, offset, default) — retrieves the value offset from the preceding row.
#InterSystems IRIS
0
1 198
Announcement Thomas Dyar · Nov 17, 2025

NEW: "IntegratedML Custom Models" Early Access Program -- Deploy Your Python ML Models in SQL

We're excited to announce the Early Access Program for IntegratedML Custom Models, a powerful new capability coming in IRIS 2026.1!

What Is It?

IntegratedML Custom Models extends the existing IntegratedML/AutoML feature by letting you deploy your own custom Python ML models directly within SQL queries.

#InterSystems IRIS #InterSystems IRIS for Health #Early Access Program (EAP) #IntegratedML #Machine Learning (ML) #Python #Release #SQL
2
4 244
Article Rodolfo Pscheidt Jr · Mar 17, 2025 2m read

Ollama AI with IRIS

 

In this article I will be discussing the use of an alternative LLM for generative IA. OpenIA is commonly used, in this article I will show you how to use it and the advantages of using Ollama

In the generative AI usage model that we are used to, we have the following flow:

  • we take texts from a data source (a file, for example) and embedding that text into vectors

  • we store the vectors in an IRIS database.

  • we call an LLM (Large Language Model) that accesses these vectors as context to generate responses in human language.
#InterSystems IRIS #InterSystems IRIS for Health #Open Exchange #API #Artificial Intelligence (AI) #GitHub #Python #Vector Search
Open Exchange
2
2 397
Article Yuri Marx · Dec 2, 2025 2m read

Use IRIS Load Data in VSCode

The Load Data utility it is an excellent tool to load data from CSV/TXT files into an IRIS SQL Table, but it is required send the target file to the IRIS server and write the Load Data sentence to ingest the file content. Now it is possible select a file in VSCode, set the table destination and submit the request. The vscode-load-data utility will send the file to the IRIS server and run the Load Data command to you! Very simple:

#InterSystems IRIS #CSV #Docker #SQL #VSCode
Open Exchange
0
1 139
Article Developer Community Admin · Mar 18, 2025 10m read

InterSystems IRIS data platform: Architecture

The InterSystems IRIS data platform underlies all InterSystems applications, as well as thousands of customer and partner applications across Healthcare, Financial Services, Supply Chain, and other ecosystems. It is a converged platform, providing transactional-analytical data management, integrated interoperability, and data integration, as well as integrated analytics and AI. It supports the InterSystems Smart Data Fabric approach to managing diverse and distributed data.

#InterSystems IRIS #Resource Library
3
5 606
InterSystems Official Dipak Bhujbal · Dec 1, 2025

Release Notes: InterSystems Cloud Services – Version 25.24.2 Release Notes (November 2025)

Overview

This release introduces major improvements to storage scalability and performance, a significant operating system upgrade across all offerings, and a new default version of the FHIR Server. Together, these updates enhance system reliability, flexibility, and security while ensuring long-term platform supportability.

#HealthShare #InterSystems IRIS #InterSystems IRIS for Health #Health Connect #InterSystems Official #Cloud #Release
0
0 96
InterSystems Official Dipak Bhujbal · Dec 1, 2025

Release Notes: InterSystems Cloud Services – Version 25.20.2 Release Notes (October 2025)

Overview

Version 25.20.2 expands global availability, enhances Advanced Security flexibility, and widens Network Connect integrations. This release introduces support for additional regions, new application-aware security rules, and expanded connectivity options for critical InterSystems services.

#HealthShare #InterSystems IRIS #InterSystems IRIS for Health #Health Connect #InterSystems Official #Cloud #Release
0
0 78
InterSystems Official Dipak Bhujbal · Dec 1, 2025

Release Notes: InterSystems Cloud Services – Version 25.23.2 Release Notes (November 2025)

Overview

Version 25.23.2 delivers targeted improvements to the Advanced Security UI and further streamlines the upgrade and update workflows across InterSystems Cloud offerings. These changes focus on clarity, efficiency, and operational excellence.

New Features and Enhancements


Category Feature / Improvement Details
Advanced Security UI Enhancements for Application Visibility Updated interface provides clearer, more intuitive application mappings, improving understanding of security boundaries, associated policies, and protected resources.
#HealthShare #InterSystems IRIS #InterSystems IRIS for Health #Health Connect #InterSystems Official #Cloud #Release
0
0 81
InterSystems Official Dipak Bhujbal · Dec 1, 2025

Release Notes: InterSystems Cloud Services – Version 25.24.1 (November 2025)

Overview

Version 25.24.1 delivers major enhancements to DNS capabilities, platform reliability, upgrade workflows, and developer experience. This release also includes key fixes and increases in platform limits to better support modern workloads.

New Features and Enhancements


Category

Feature / Improvement

Details
Networking – DNS DNS Mapping (Static DNS Support) DNS support expanded from forwarding-only to full DNS Mapping, allowing creation and management of static DNS entries for improved service discovery and configuration flexibility.
#HealthShare #InterSystems IRIS #InterSystems IRIS for Health #InterSystems Official #Cloud #Release
0
0 71
InterSystems Official Dipak Bhujbal · Dec 1, 2025

Release Notes: InterSystems Cloud Services – Version 25.19.2 (August 2025)

Overview

This release focuses on performance optimization, improved security synchronization, and enhanced network management. The FHIR Server has been upgraded to a new version and migrated to ARM64, delivering significantly better efficiency and throughput. Additionally, several improvements enhance resiliency, subscription management, and network visibility.

#InterSystems IRIS #InterSystems IRIS for Health #InterSystems Official #Cloud #Release
0
0 76
Article Iryna Mykhailova · Nov 30, 2025 4m read

Connecting Java to InterSystems IRIS using JDBC

In the previous article, we talked about ODBC and connecting from C#. And now, let's look at JDBC and Java. The InterSystems JDBC driver is the recommended, high-performance way to integrate your Java applications.

Here is a step-by-step guide to getting your Java application connected to an IRIS instance using the JDBC driver.

Step 1: Obtain and Include the InterSystems IRIS JDBC Driver

Unlike ODBC drivers, which are often installed system-wide, JDBC drivers are typically distributed as JAR files that must be included in your Java project's classpath.

If InterSystems IRIS is installed on your local machine or another you have access to, you can find the file in install-dir/dev/java/lib/ or similar, where install-dir is the installation directory for the instance. Conversely, you can download the jar file from Driver packages page.

Or as suggested by @Dmitry Maslennikov in the comments, use the maven central repository for Maven:

<dependency>
    <groupId>com.intersystems</groupId>
    <artifactId>intersystems-jdbc</artifactId>
    <version>3.10.5</version>
</dependency>

or for Gradle:

implementation("com.intersystems:intersystems-jdbc:3.10.5")

Include the jar file in Project:

  • Maven/Gradle: If you use a build tool, the simplest method is to add the InterSystems JDBC driver as a dependency in your pom.xml or build.gradle file. This automatically downloads and manages the JAR.
  • Manual: For simple projects, you must place the JAR file in a project directory (e.g., /lib) and explicitly add it to your classpath when compiling and running.
#InterSystems IRIS #JDBC
2
0 172
Question Scott Roth · Dec 1, 2025

Resend a single message based on Session ID

I am working on building out a Workflow task that captures errors in mapping to specific tables. Within the Workflow task, I would like to give the owner of the task the ability to resubmit message once the mapping has been corrected. Is there a way to do it in a similar fashion to pulling up the Trace ie...

EnsPortal.VisualTrace.zen?SESSIONID=#(%task.%FormValues.GetAt("MsgHdrID"))#" target="_blank">View Message Trace

Is there a one liner that could be called to resubmit the MsgHdrID (Session ID) from its source to post it again?

#HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS #System Administration
1
0 68