Hi, Community!

Have you thought about becoming a subject matter expert (SME) for InterSystems Certification?

The benefits are many—but you can hear directly from five members of our SME community as they discuss:

How did participating in exam development boost your own expertise?

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Unlocking a World of Possibility @ Ready 2025

These are the strategic plans of my example for the External Languages Contest 2025

BroadSea - Core OHDSI Walkthrough with InterSystems OMOP

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ The Evolution of AI: Embracing Agency @ Ready 2025

Hi Community,

We're super excited and thankful to our 52 InterSystems colleagues who participated in the 📺 Demo Games for InterSystems Sales Engineers 📺 and created 19 amazing videos.

Our colleagues worldwide put their creativity, technical know-how, and demo magic to the test. What started as an internal contest to showcase technical skill and demo excellence became a true stage for imagination with some entries looking less like demos and more like short films, complete with acting, storytelling, and even a cinematic touch.

Also, we'd like to thank all the members of the Community who took the time to watch them and vote for their favourites! 

And now it's time to announce the winners!

We're excited to announce a new version release of the SQLTools VS Code extension. 

SQLTools connects VS Code users to the most commonly used databases using drivers, including InterSystems IRIS. With over 3.5 million downloads, it is helping users work with their data much more easily.

Version 0.28.2 is now available and includes:
- New CSV export format options.
- Improved connection quickpick and status bar item.
- Query error strings now wrap.
- Document settings that require a restart after changing.
- Resolve contradictory SSL settings in MySQL driver.

Hey Community,

We're excited to invite you to the next InterSystems UKI Tech Talk webinar: 

👉AI Vector Search Technology in InterSystems IRIS

⏱ Date & Time: Thursday, September 25, 2025 10:30-11:30 UK

Speakers:
👨‍🏫 @Saurav Gupta, Data Platform Team Leader, InterSystems
👨‍🏫 @Ruby Howard, Sales Engineer, InterSystems

Hi Team,

I've basic learning in Ensemble. I want to create a code as per following request. Please help in clearing following questions

We have a business process-AA. In this business process, we have onRequest method, here after performing some logic, I have to call a method ProcessAAlogic. 

In ProcessAAlogic method, after initial processing, we have to call a business operation BB asynchronously (which will give a flag "AACompleted" having value 1 or 0) in pResponse object.
Now based on this AACompleted flag, I have to call other methods which are part of onRequest method  i.e.

Hey Community!

We're happy to share the next video in the "Code to Care" series on our InterSystems Developers YouTube:

⏯  Explaining Agentic AI Through Automated Bug Fixing

We are trying to make an ODBC connection via our intersystems ensemble (2016.2 running on ubuntu). However, when I am testing the connection I receive a pop-up that: "Http object response incomplete or invalid.0,#R". Note that the iodbctrace.log remains empty (and it is working because on the first try it registered a 459 error that I should activate kerberos, which I did). Any advise where I should look?
I have taken the following actions:

1. Expand the cacheodbc.

As the title says, I've noticed that files that gets saved to the disk where the database lies (.DAT file) in the stream directory, does not get purged. Is this expected and do we need to create our own schedule task to clean this folder up?

I could only find old answers that say this, however I find it a bit odd if that is the case because they are considered temporary files. Perhaps I do not handle the streams correctly in the code?

set##class%Stream.FileBinary

Hi everyone,

I'm currently seeking a new position related to InterSystems technologies. I suppose I could call myself an expert in integration development with IRIS Interoperability (Ensemble). It is my major skill. In addition, I have extensive experience in database modeling on the Caché platform and API development, from specifications to unit testing. I develop high-load, mission-critical software on InterSystems IRIS Data Platform. My Caché ObjectScript programming experience includes hundreds of data flows, thousands of business hosts, dozens of APIs, and many other modules. I worked to integrate such apps as SAP S/4HANA, Oracle Siebel, and SAP Commerce Cloud. I have experience with various related areas, including SQL, Java, Embedded Python, mobile development, IRIS management, DevOps, Apache Kafka, etc. I am always looking for ways to be better, developing skills in new areas such as Java, Flutter (Dart), or Python within my own projects (see my GitHub).

Visual Studio Code releases new updates every month with new features and bug fixes, and the August 2025 release is now available.

Actually, I want to know specific production component status. I used "Ens.Config.Production" to get the status of component. But it will return only the component enabled/disabled. Anyone is having any Idea to get the specific production component status?

My problem was separating HL7 messages by message type.  I had to create multiple File Operations.  So I with custom code I am able to use 1 File Adapter for 1 interface and multiple message types.  I did experiment pulling the MSH 4 out of the raw content to further access dynamic information, but that may open a need for more robust error checking / lookup default actions.

Using the recommended naming convention of "To_FILE_<IntegrationName>"

I decided to use a generic file name and path in the default settings.

I created a custom class that extended the EnsLib.File.

I've been trying to set up a script I can run after installing an instance to enable IPM across all namespaces. I have been able to install IPM successfully using

set r = ##class(%Net.HttpRequest).%New(),
    r.Server="pm.community.intersystems.com",
    r.SSLConfiguration="ISC.FeatureTracker.SSL.Config" 
d r.Get("/packages/zpm/latest/installer"),
    $system.OBJ.LoadStream(r.HttpResponse.Data,"c")

and then running the zpm commands

repo -r -n registry -url https://pm.community.intersystems.com/ -user "" -pass ""
enable -map -globally

Hey Community,

We're pleased to invite all the developers to the upcoming kick-off webinar for the InterSystems .Net, Java, Python, and JavaScript Contest!

During the webinar, you will discover the exciting challenges and opportunities that await developers in this contest. We will also discuss the topics we would like the participants to cover and show you how to develop, build, and deploy applications using the InterSystems IRIS data platform.

Date & Time: Wednesday, September 24 – 11:30 am EDT | 5:30 pm CEST  

I used to mannually test objectscript code in InterSystems Studio.  Does anyone know how to do this is VS Code?

Due to MySQL's interpretation of SCHEMA differing from the common SQL understanding (as seen in IRIS/SQL Server/Oracle), our automated Linked Table Wizard may encounter errors when attempting to retrieve metadata information to build the Linked Table.

(This also applies to Linked Procedures and Views)

When attempting to create a Linked Table through the Wizard, you will encounter an error that looks something like this:

ERROR #5535: SQL Gateway catalog table error in 'SQLPrimaryKeys'. Error: ' SQLState: (HY000) NativeError: [0] Message: [MySQL][ODBC 8.3(a) Driver][mysqld-5.5.5-10.4.

In the previous article, we saw how to build a customer service AI agent with smolagents and InterSystems IRIS, combining SQL, RAG with vector search, and interoperability.

In that case, we used cloud models (OpenAI) for the LLM and embeddings.

This time, we’ll take it one step further: running the same agent, but with local models thanks to Ollama.

Hi,

so we introduced GIT in our workflow and we exported all files with $SYSTEM.OBJ.ExportUDL

Everything fine so far. But for some reason the export adds an extra line for classes (Routines are OK as far as I can see):

On Serverside it isn't there

The Problem is now that when we checkout a branch and a class changed we automatically compile it from the repository to a namespace that is made for the developer. E.g. DEV_001, DEV_002 and so on.

In the WRC, we often see customers raise questions regarding a new Web Gateway setup where the Management Portal half-loads, but doesn’t show images. This article will explain why this error occurs, as well as how to fix it. This explanation is focused on the Web Gateway serving InterSystems IRIS instances, but the same explanation should apply to the CSP Gateway serving Caché instances as well.

The Problem:

You just installed the Web Gateway on a stand-alone Web Server.

We are excited to announce the general availability of JediSoft IRISsync®, our new synchronization and comparison solution built on InterSystems IRIS technology.  IRISsync makes it easy to synchronize and compare IRIS instances.

IRISsync was voted runner-up in the "Most Likely to Use" category at InterSystems READY 2025 Demos and Drinks.

A huge thanks to everyone who supported us — we’re thrilled to see IRISsync resonating with the InterSystems user community!

IRISsync provides clear visibility into differences between environments.

Plug-N-Play on Pattern Match WorkBench

Article to announce pre-built pattern expressions are available from demo application.

AI deducing patterns require ten and more sample values to get warmed up.

The entry of a single value for a pattern has therefore been repurposed for retrieving pre-built patterns.

Example: Email address

Paste an sample value for example an email address in description and press "Pattern from Description".

The sample is tested against available built-in patterns and any matching patterns and descriptions are displayed.

Patterns can also be retrieved by Keyword.

No Code Text to SQL w/ Databricks Genie and InterSystems OMOP

Using OpenEHR with InterSystems IRIS

Occasionally. we get questions about using OpenEHR with InterSystems.   Typically, these discussions focus on why and how an organization wants to implement OpenEHR in building applications. Here’s a brief guide:

• InterSystems is focused on interoperability:  we prioritize interoperability through standards such as HL7, IHE, DICOM, and ISO. In our experience, no single standard addresses all the needs of complex healthcare data.

I am struggling in understanding how FDN works within Health Share, in particular those that are related to Provider Directory within Health Share. Does anyone have examples of using FDN that they would be able share?

#InterSystems Demo Games entry

⏯️ Text-to-SQL and MQTT Monitoring

A text-to-sql demo on mqtt data analytics with RAG.

🗣Presenter: @Jeff Liu, Sales Engineer, InterSystems

You’ve probably already seen that the September Article Bounty is in full swing! 🚀

You can either submit an existing up-to-date article on one of the topics and earn 30 points,
or write a brand-new article from scratch and get a bounty of 🏆 5,000 points once it’s approved! 🎉