Apache Airflow is the leading open-source platform to programmatically author, schedule, and monitor data pipelines and workflows using Python. Workflows are defined as code (DAGs), making them version-controlled, testable, and reusable. With a rich UI, 100+ built-in operators, dynamic task generation, and native support for cloud providers, Airflow powers ETL/ELT, ML pipelines, and batch jobs at companies like Airbnb, Netflix, and Spotify.

Airflow Application Layout

Hi Community,

It's voting time! Cast your votes for the best applications in our InterSystems "Bringing Ideas to Reality" Contest:

🔥 VOTE FOR THE BEST APPS 🔥

How to vote? Details below.

I use $SELECT() in Architect to aggregate various data conditions into a single dimension.

I have a data table like this: id, user, userData1, userData2...

Introduction

In today's rapidly evolving threat landscape, organizations deploying mission-critical applications must implement robust security architectures that protect sensitive data while maintaining high availability and performance. This is especially crucial for enterprises utilizing advanced database management systems like InterSystems IRIS, which often powers applications handling highly sensitive healthcare, financial, or personal data.

Hey Community!

We're happy to share a new video from our InterSystems Developers YouTube:

⏯  SQL Tricks and Tips @ Ready 2025

Given a JSON schema at runtime, I want to programmatically create persistent classes with corresponding properties and indices. Is there a way to dynamically compile and load such classes?

Hey Developers,

Enjoy the new video on InterSystems Developers YouTube

⏯ Enhancing Customer Engagement with Vector Search - Building a Customer Facing Chatbot @ READY 2025

Hello Community! 👋
Welcome to the second part of the IRIS IO Utility series. This extension represents my submission for the InterSystems "Bringing Ideas to Reality" Contest 2025 and offers you an intuitive and powerful interface for importing and exporting data directly inside VS Code.

• You can find the extension on my GitHub page: pietrodileo/iris_io_utility
• VSIX file to install the extension on VSCode can be found on the related release page: releases: iris-io-utility

If you find this extension useful, please consider voting for me at the contest!

In the previous article, we covered:

Hi everyone. Long time no see. Again, I would like to share what I am studying recently Create Foreign Tables Using SQL via JDBC.

Since I am learning about the IRIS BI at the same time, so I started with this Sample-BI docker environment

https://github.com/intersystems/Samples-BI

After starting the environment, login to the management portal http://localhost:52773/csp/sys/UtilHome.csp  with the user Superuser.

Switch the namespace to IRISAPP.

😀 We will find out that all the sample data are stored in this namespace IRISAPP. Let's find a simple table for testing the Foreign Table feature 🤣

Introduction

Hi, Community!

See how to efficiently validate incoming CDA documents and comply with standards using the cloud-based CDA Validation Service!

Streamlining CDA Data Feed Setup in Health Connect Cloud

InterSystems FAQ rubric

Too run SQL in Terminal use $system.SQL.Shell().

Please refer to the sample below.

Supply Chain refers to a set of processes and activities performed by the company's business areas and its suppliers and partners (stakeholders), from the acquisition of raw materials, through production, to delivery to the end consumer. It can be better managed using SCM solutions with the orchestration of the InterSystems IRIS:

If one of your packages on OEX receives a review, you get notified by OEX only of YOUR own package.   
The rating reflects the experience of the reviewer with the status found at the time of review.   
It is kind of a snapshot and might have changed meanwhile.   
Reviews by other members of the community are marked by * in the last column.

I also placed a bunch of Pull Requests on GitHub when I found a problem I could fix.    
Some were accepted and merged, and some were just ignored.     
So if you made a major change and expect a changed review, just let me know.

Hi all,

Does anyone know of a way to make Ens.ScheduleHandler alert on error?

Cheers,

Otto

Hi Community,

Are you looking for resources to help your team onboard? Use these guides to get started!

Updated 12/09/25

Hi Community,

You can unlock the full potential of InterSystems IRIS—and help your team onboard—with the full range of InterSystems learning resources offered online and in person, for every role in your organization. Developers, system administrators, data analysts, and integrators can quickly get up to speed.

Onboarding Resources for Every Role

Developers

• Online Program: Getting Started with InterSystems IRIS for Coders(21h)
• Classroom Training:
  • Developing with InterSystems Objects and SQL(5 days)
  • Developing System Integrations (5 days) 

System Administrators

Updated 12/09/25

Hi Community,

Need to find the most relevant onboarding for your HealthShare Unified Care Record® team? Maximize your team's knowledge and success by diving into this curated list of offerings from InterSystems Learning Services—which includes online and in-person training for a variety of roles in your organization.

Onboarding Resources for Every Role

System Integrators

I'm pleased to announce the publication of gj :: dataLoader, a new VS Code extension that simplifies the task of loading data from local CSV files into SQL tables on your InterSystems IRIS servers.

Here's an introductory video:

gj :: dataLoader is now available on Marketplace for direct installation into VS Code. It is my entry in the "Bringing Ideas to Reality" Contest 2025 and implements this idea - https://ideas.intersystems.com/ideas/DPI-I-667

Feedback is welcome.

New contest — new chance to earn points on Global Masters!

7,000 points for each walkthrough video submission 🧐

What this is about:
We're looking for feedback on the Interoperability UI in the latest release, 2025.3.
You can check what's new in this recent announcement by @Aya Heshmat 
How to take part: 

Hi Community,

With the General Availability of the 2025.3 release of InterSystems IRIS® data platform, InterSystems IRIS® for Health™, and HealthShare® Health Connect, we are now collecting your ideas for improvement. 

If the new release inspired you or highlighted opportunities to enhance the developer experience, please share your suggestions on the InterSystems Ideas Portal - every idea is reviewed by our product teams and can influence future releases.

What are best practices for JSON transformation in IRIS interoperability? This is for a non-healthcare use case, so any tools we happen to have around FHIR might not be available. The motivating use case is trimming down a verbose and needlessly complex REST API response to feed to an LLM - trying to reduce token usage and maybe get better results from less noisy data.

The previous article introduced IrisOASTestGen, a tool designed to generate REST API test code for InterSystems IRIS based on OpenAPI 2.0 specifications. It demonstrated how to scaffold test cases using the default templates bundled with OpenAPI Generator.

This follow-up focuses on the next natural step: customizing the generated test code. By extending the code generation logic with Mustache templates, it becomes possible to express richer semantics, implement CRUD-aware tests, and create more meaningful test suites.

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>[...other tags...]</entry></component></component></ClinicalDocument>I would like to have a way to obtain only the content of the

Keywords:  Vibe coding, Windsurf, IRIS, TIE

Why not?   "Vibe coding" is never about the vibe!

Has anyone not been trying "vibe coding" so far?

Even merely 3 years ago, if anyone asked

• "Could I do IRIS implementation for NHS TIE in English or Spanish or just Chinese ?", or
• "Can I just instruct TIE in English to build itself an e2e route, to pick up a PDF report then turn into ORU/MDM message and submit into the PAS ?", or
• "Could we query IRIS database in English only, and build up dashboard or ad hoc report of my own by English instructions?"

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.

I need to connect IRIS to a third-party FHIR server which in turn is connected to Keycloak.

For machine-to-machine communications, client credentials grants should be used. I don't know why exactly but the FHIR server requires access tokens to contain the "openid" scope, otherwise it returns 401 (unauthorized).

If the access token returned by Keycloak contains that scope, IRIS complains about ""ERROR #8859: Unsupported response to access token request: OpenID Connect is not supported for password and client credentials grant type". The error is produced by the OAuth2.Response class, line 393:

Auditing is a critical capability ensuring the security of your server, and for quite a while ago we have included the ability to audit SQL statements run on the server.

With v2024.3 out already we're providing finer-grained options for defining these events to audit.

Let’s spotlight the brilliant authors and contributors of our November Article Bounty! 💙
Thank you to everyone who took part and shared their knowledge with the community.

A special shout-out goes to those who created brand-new articles and contributed their expertise — each received 5,000 points 🎉

@Zion Amsalem -- "Consuming REST-APIs for dummies (beginner-friendly)"
@Robert Cemper -- "Network Debugging for Beginners - 1"
@Iryna Mykhailova -- "Connecting C# to InterSystems IRIS via ODBC"
@Vachan C Rannore -- "My experience with APIs and POS integration."
@Padmaja Konduru -- "Production Terminal Commands"