Here at InterSystems, we often deal with massive datasets of structured data. It’s not uncommon to see customers with tables spanning >100 fields and >1 billion rows, each table totaling hundred of GB of data. Now imagine joining two or three of these tables together, with a schema that wasn’t optimized for this specific use case. Just for fun, let’s say you have 10 years worth of EMR data from 20 different hospitals across your state, and you’ve been tasked with finding….

12 3
6 361
InterSystems Developer Community is a community of 25,912 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

A .iostream file got stored in /intersystems/HCENG01B12/mgr/Temp for a BatchFileOperation class while HC was on the secondary node. HealthConnect is now on the primay node and cannot find that .iostream file path. The operation starts throwing errors when the RolloverSchedule is reached

OnKeepalive() returned ERROR #5012: File '/intersystems/HCENG01B12/mgr/Temp/QWhoZAwFF3f9jQ.iostream'
does not exist

How can I resolve this issue?

0 3
0 44

Hello InterSystems EHR community,

InterSystems Certification is currently developing a certification exam for CCR Tier 2 users, and if you match the exam candidate description below, we would like you to beta test the exam! The exam will be available for beta testing starting January 27, 2026.

Beta testing will be completed March 28, 2026.

0 0
0 39
Hello and welcome to the 2025 Developer Community YouTube Recap.
Top 10 videos from InterSystems Ready 2025
InterSystems Different by Design
By Scott Gnau, Peter Lesperance, Tom Woodfin, Gokhan Uluderya, Jeff Fried, Daniel Franco
Analytics and AI with InterSystems IRIS - From Zero to Hero
By Benjamin De Boe, Thomas Dyar, Carmen Logue
The Road to AI in Healthcare
By Don Woodlock, Sean Kennedy, Alex MacLeod, Erica Song, James Derrickson, Julie Smith, Kristen Nemes, Varun Saxena, Dimitri Fane, Jonathan Teich, Judy Charamand
0 0
0 26
Announcement
· Jan 14
New AI CCR Assistant

CCR now includes an AI-powered 'CCR Assistant', available to beta testers. The CCR Assistant helps you quickly get answers about common CCR workflows, terminology, or best practices. Every response includes references to relevant ICC Training courses, making it easy to dive deeper into any topic. As a future improvement, the links will point directly to the specific page of the ICC Training PDF that was used to generate the response.

8 4
0 147

Currently in the health connect code, we are using Epic FHIR API Patient.Create, code return 200 or 201 status values, we process the message based on this return values.

Now I need to use Epic FHIR Patient.$match API, need to check FHIR Error code 4101 for this API. I looked for FHIR statndard return code, but this this seems not standard code, please advice how can I check 4101 value?

0 1
0 39

Hey Community,

We're pleased to invite everyone to the upcoming kick-off Webinar for the InterSystems Full Stack 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: Monday, February 2 – 12:00 pm EST | 6:00 pm CET

https://www.youtube.com/embed/0TaAkrnz4cc?si=WftjDCvpEWccdY4h
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
0 43

How many times have you had to receive or generate a JSON and wished you could work on it using DTLs without having to deal with DynamicObjects trying to remember the name of each field? Do you want to break down and make your giant JSON file more digestible?

In my case, never, but I thought that someone might find it useful to have a feature that captures your JSON and breaks it down into a series of ObjectScript classes that you can work with more easily and conveniently.

Well then...behold JSON2Class in all its glory!

Open Exchange app
5 0
0 66

Hello Community,

I am facing a JDBC connection issue after migrating from Caché 2016 to Caché 2018.1. When I attempt to connect using the following connection settings:

CACHE_DATASOURCE_URL=jdbc:Cache://localhost:1972/TEST

CACHE_DB_USERNAME=test

CACHE_DB_PASSWORD=test

I consistently receive the following error:

[Cache JDBC] Communication link failure: Access Denied

This configuration worked perfectly with Caché 2016. I have verified the following:

0 7
1 64

Hey Community!

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

⏯ Practical Approches to Transforming Your Data Into FHIR @ Ready 2025

https://www.youtube.com/embed/jApp3PHT5Hg
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 37

What is a FHIR Profile?

A FHIR profile is a collection of rules and constraints used to customize and refine a base Fast Healthcare Interoperability Resources (FHIR) resource. Profiling is a vital process that adapts the base FHIR resource standard to satisfy the unique requirements of a specific use case, geographic region, medical institution, or clinical workflow.

While the base FHIR specification provides generic, flexible definitions for resources (such as Patient, Observation, or Medication), profiles transform these generic resources into more precise ones. This ensures consistent and interoperable data exchange tailored for a particular community or implementation.

FHIR is designed to cover various healthcare scenarios globally. Profiles allow implementers to adapt this general platform without losing the benefits of standardization.

Open Exchange app
2 2
1 89
Article
· Jan 25 2m read
Reviews on Open Exchange - #63

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.

0 0
0 29

Hi, I have simple email alert setup (EnsLib.EMail.AlertOperation) where in operations I have SMTP server setup and Recipients emails.

Also I find Alert Groups dropdown option in operations, processes, how this is different from setting up simple email alert with recipients list?

Please advise.

1 1
0 28

We’re excited to announce the first mini hackathon “Building AI Agents with InterSystems”, taking place on a pre-conference day as part of InterSystems READY 2026.

In this hands-on challenge, participants will design and build AI agents using upcoming InterSystems capabilities, exploring how intelligent automation, orchestration, and reasoning can be applied to practical use cases.

    📅 Event date: 27 April 2026
    📍 Location: Gaylord National Resort & Convention Center, National Harbor, Maryland
    🔗 Learn more here: Building AI Agents with InterSystems mini-hackathon at InterSystems READY 2026

    5 0
    1 43

    Needs some help with FHIR return code 200 or 201 when processing HL7 messages in HealthConnect.

    Issue:

    1. If FHIR code is 200 or 201, HealthConnect keep processing HL7 messages

    2. If FHIR code is NOT 200 or 201, HealthConnect keep suspend the HL7 messages in the messages queue, then keep processing NEXT subsequent HL7 messages in the TEXT file if the FHIR code is 200 or 201

    0 5
    0 79

    Where can I download the Cache ODBC drivers?

    Where can I download the Cache ODBC drivers for Windows?

    I need to connect to a cache database by odbc but the FPTs that I have found do not work,
    could you tell me where to download the ODBC drivers

    0 16
    0 10.8K

    Hey Community!

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

    ⏯ How Big Research Bets Are Made Without a Crystal Ball

    https://www.youtube.com/embed/JE2ssBbsh8w
    [This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

    2 0
    0 23
    Article
    · Jan 21 2m read
    Archiving my OEX packages

    Over the last 9 years, I published more than 90 packages in OEX.
    And over this time, conditions and environments changed.
    In the beginning, there was

    • no Docker
    • no IPM/ZPM
    • no embedded Python, no AI
    • Caché, Ensemble, CSP, ZEN, .... were dominating

    As time changed, also product versions and external languages changed.
    Adjustment of a few packages was no issue in the beginning,
    and was a matter of support quality to my "consumers".

    2 0
    0 42

    Why do these clauses affect SQL performance?

    select ID from some_table where row_status in ('I','U') order by ID limit 5 - makes the query infinite
    select top 10 ID from some_table where row_status in ('I','U') order by ID - the same
    select ID from some_table where row_status in ('I','U') order by ID - is fast

    Actually there are no rows in the table having row_status 'I' or 'U'.

    I asked Gemini and it recommended me rewrite the query as

    0 13
    0 103

    Hi Community!

    Starting from January 2026, developers who turn product ideas from the Ideas Portal into real, working solutions with be awarded with 7,000 points on Global Masters and a badge.

    ✨ What you get:
    🧙‍♂️ Idea to Reality Wizard badge —     awarded once to community members who implement a product idea suggested at the Ideas Portal
    ⭐ 7,000 Global Masters points — awarded for every implemented idea from the "Community Opportunity" list.

    Details:

    5 1
    0 128