InterSystems Developer Community is a community of 26,505 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more
Article Irene Mykhailova · Apr 21, 2025 3m read

Considerations when Migrating from Oracle, MSSQL etc to IRIS

Migrating from Oracle, MSSQL, or other purely relational database systems to a multimodel InterSystems IRIS is a strategic decision that requires careful planning and execution. While this transition offers significant benefits, including enhanced performance, scalability, and support for modern architectures, it also comes with challenges. In this article I will highlight some of the considerations connected to coding to ensure a successful migration. I will leave everything connected to an actual migration of structures and data outside the scope of this article.


First, when you're considering migrating to a different database system, you need to understand your business logic, whether it's on the side of the application (application server) or the database server. Basically, where do you have your SQL statements that you will need to potentially rewrite? 

#InterSystems IRIS #Best Practices #Databases #SQL
3
1 331
New
Announcement Anastasia Dyubaylo · Apr 4

Videos for InterSystems Developers, March 2026 Recap

Hello and welcome to the March 2026 Developer Community YouTube Recap.
InterSystems Ready 2025
#Developer Community Official #Digest #Video
0
0 11
Question Jacinto Busquets · Mar 20

Have anyone has a class that profiles a table? Example, total rows, total nulls, average, max , min for each column on th

I created a table profile dashboard on Power BI, but I wonder if is possible to do it in Iris by creating a class.

HealthShare Clinical Viewer 2022.2.2 Build: 1000 Adhoc: 23127 [HealthShare Modules: Core:24.0 + Clinical Viewer:24.0] - IRIS for UNIX (Red Hat Enterprise Linux 8 for x86-64) 2022.1 (Build 209_0_23127U) Mon Feb 12 2024 18:21:53 EST [Core:24.0|Clinical Viewer:24.0]

#HealthShare #Caché
5
0 72
New
Announcement Anastasia Dyubaylo · Apr 3

InterSystems READY 2026 sessions are here — start planning your agenda!

Hey Community,

The READY 2026 agenda is taking shape, and we're thrilled to give you a first look at what's in store.

This year's event runs April 27–30 at the Maryland Convention Center, and the session roster is packed — more than 80 sessions spread across four days, designed to assist you in whatever you need, whether you're deep in the code or shaping your organization's technology strategy.

The tracks cover a broad range of topics this year:

#Summit #READY 2026
1
0 29
Announcement Kristina Lauer · Mar 17

Be Ready: Ask a Trainer

Hi Community,

A big perk of attending InterSystems READY 2026 (April 27–30) is the chance to talk to our experts!

Chat with an experienced technical trainer about topics like:

  • Programming, including ObjectScript, Embedded Python, and SQL
  • Interoperability
  • Unified Care Record
  • Change Control Record (CCR)

Sign up for a 45-minute session for yourself or your team—it's free!

📧Email TechExchange@intersystems.com and let us know:

  • Topics you’d like to discuss
  • Trainer name (optional)
  • Available times and dates
  • Who’s attending (you, or your team)
#Learning Portal #READY 2026
2
0 53
New
Article Brett Saviano · Mar 30 2m read

Small VS Code features that will boost your productivity

The official InterSystems VS Code extensions are packed with features that make developing with InterSystems products a breeze. Today I'd like to highlight some small but useful features that you may have missed.

Show All Class Members

You can view all members of the current class, including inherited members, with the click of a button. Just click on the class icon in the top-right corner of the editor window and a filterable list of all members will appear. Clicking on one will reveal it in an editor tab.

#Other #Development Environment #Tips & Tricks #VSCode
7
2 128
Article Vachan C Rannore · Aug 18, 2025 3m read

Practical ObjectScript Coding: From JSON to Globals to SQL

While starting with Intersystems IRIS or Cache, developers often encounter three core concepts: Dynamic Objects, Globals & Relational Table. Each has its role in building scalable and maintainable solutions. In this article, we'll walk through practical code examples, highlight best practices, and show how these concepts tie together. 

1. Working with Dynamic Objects:

Dynamic objects (%DynamicObject and %DynamicArray) allow developers to manipulate JSON-like structures directly in Objectscript. They are especially useful for modern applications that need to parse, transform or generate JSON.

#Caché #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #TrakCare #Globals #JSON #ObjectScript #Relational Tables #SQL
4
6 291
Article Irène Mykhailova · Aug 19, 2025 2m read

How to merge existing accounts (update email) in the InterSystems Developer Ecosystem

Hi Community,

Sometimes you may need to merge multiple accounts or simply update the email address you use across the different portals in the InterSystems Developer Ecosystem. Since each portal works a little differently, here’s a guide to help you through the process.

Change your email

If you’d like to use a different email (for example, use a work email instead of a personal one, or vice versa), here’s how to update it across the portals:

1. Update your email in InterSystems SSO. To do this:

  • follow the prompts on screen to change your email
#Developer Community Official #Developer Community FAQ
4
2 199
New
Discussion Anastasia Safronova · Mar 30

READY 2026: What are you most excited about?

READY 2026 is almost here, and we’re really curious to hear what everyone is looking forward to this year 🚀

What are you most excited about? It could be a topic you want to explore, a question you’re hoping to get answered or something you’re simply curious about.

Share your thoughts below! We’d love to hear what’s on your mind and see what others are excited about too 💬

Feel free to read through the replies and like the ones you relate to! 😊

#Global Masters #READY 2026
6
0 117
Article Robbie Luman · Aug 15, 2025 7m read

Beginner's Guide to %JSON and Dynamic Entities in IRIS

Dynamic Entities (objects and arrays) in IRIS are incredibly useful in situations where you are having to transform JSON data into an Object Model for storage to the database, such as in REST API endpoints hosted within IRIS. This is because these dynamic objects and arrays can easily serve as a point of conversion from one data structure to the other.

#InterSystems IRIS #Code Snippet #Data Import and Export #Data Model #JSON #Key Value #Object Data Model #ObjectScript #Tips & Tricks
5
4 404
New
Article Jinyao · Apr 2 2m read

No-Hallucinate MCP: Real-time Routine Context for ObjectScript

Motivation


Why do we need this?

  1. Lack of Compiled Context: AI tools only see source code; they don't know what the final compiled routine looks like.

  2. Macro Hallucination: Because AI doesn't see our #include files or system macros, it often makes them up, wasting time during debugging.

  3. The Documentation Gap: Deep logic optimization often requires understanding internal macros that aren't fully covered in public documentation.

  4. Manual Overhead: Currently, the only way to fix this is to manually use the IRIS VS Code extension to find the "truth" in the routine.

#Caché #InterSystems IRIS #Open Exchange #Artificial Intelligence (AI) #Generative AI (GenAI)
1
0 41
Discussion Gabriel Ing · Mar 4

Code Golf! Alternating Vowels

Anyone up for a round of golf?

Are you fed up of making a machine write code for you? Do you miss thinking through problems yourself? Then you are in luck, this round, I propose adding the rule of no AI use. obviously its a game of honor with no prize, so I shan't be enforcing this, but you'll know... 

Challenge:

Create a function which takes a string as a parameter, and returns the length of thelongest sequence of alternating consonants and vowels. The sequence is broken by having two vowels or two consonants in a row.

#Caché #InterSystems IRIS #Code Golf #ObjectScript
10
1 247
Question Jayesh Gupta · Jan 3, 2024

Unable to connect to IRIS container through DBeaver via JDBC driver

So I am running IRIS 2023.3 via a Docker container on Windows 11 and when I go to System Administration > Connectivity > SQL Gateway Connections, I am able to connect to the iris container via jdbc. However, when I go to JBeaver and try connecting to IRIS via JDBC I am unable to do so. I know that this is a local laptop issue because when someone else runs it on t heir mac it works fine. 

#InterSystems IRIS
4
0 325
Article Jinyao · Feb 21, 2025 4m read

Modern and Easy-to-Use VSCode Plugin for InterSystems ObjectScript: Class Diagram Visualization with PlantUML

Motivation

I didn't know about ObjectScript until I started my new job. Objectscript isn't actually a young programming language. Compared to C++, Java and Python, the community isn't as active, but we're keen to make this place more vibrant, aren't we?

I've noticed that some of my colleagues are finding it tricky to get their heads around the class relationships in these huge projects. There aren't any easy-to-use modern class diagram tool for ObjectScript.

Related Work

I have tried relavant works:

- InterSystems class view:
1. https://github.

#Caché #InterSystems IRIS #Open Source #Performance #VSCode
Open Exchange
13
5 770
New
Article Benjamin De Boe · Apr 2 2m read

Dealing with Very Large Data in IRIS 2026.1

What’s New in InterSystems IRIS and IRIS for Health 2026.1

InterSystems IRIS 2026.1 is here, and it’s packed with powerful enhancements designed to help organizations scale their data management like never before. Whether you’re dealing with the operational aspects of managing massive datasets or looking to optimize storage costs, this release brings a host of features to simplify life with your data and meet the growing challenges of very large datasets.

#InterSystems IRIS #Big Data #Databases #Relational Tables #SQL
0
0 48
Announcement Anastasia Dyubaylo · Feb 26

InterSystems READY 2025 Alumni – record a video to inspire the next wave

Hey Community!

Have you attended one of the Global Summits or a previous READY 2025? We’d love your help to inspire others to join InterSystems READY 2026!

We’re inviting community members to record a short video (less than 1 minute) answering one or more of these questions:

  • What did you find most valuable about attending?
  • What surprised you?
  • Why should others join READY 2026?
  • Who would benefit most from attending?

Your authentic perspective helps future attendees understand the real impact of these events, beyond the agenda.

🎥 To record a short video, follow the link. No preparation needed.

#Summit #READY 2026
10
0 222
New
Announcement Anastasia Dyubaylo · Apr 1

Developer Community Recap, March 2026

Hello and welcome to the March 2026 Developer Community Recap. 
General Stats
✓ 115 new posts published in March:
– 25 new articles
– 41 new announcements
– 44 new questions
– 5 new discussions
✓ 327 new members joined in March
✓ 16,197 posts published all time
✓ 21,295 members joined all time
#Developer Community Official
0
0 17
New
Article Ariel Glikman · Apr 1 6m read

Getting started with OAuth in your Web Apps

This article is intended as a beginner level article for people that want to learn how to use OAuth2 in their web applications natively.

There is an accompanying video/demo that may be helpful here: 

and you can reproduce this locally with the Open Exchange application attached.

OAuth2 as a native authentication type for web applications

OAuth (Open Authorization) 2.0 is a standard way to let one application call another application’s API without sharing a username and password.

#InterSystems IRIS #API #Authentication #OAuth2 #Video
Open Exchange
0
1 70
Article Harshitha · Aug 3, 2025 2m read

Why It's Time for a TrakCare Techno-Functional Application Specialist Certification

Working in healthcare IT as a young developer, especially on InterSystems TrakCare, you quickly realize one thing: it’s not just about HL7 messages or backend integrations. A hugepart of making TrakCare work smoothly for hospitals comes down to how it’s configured, customized, and supported on the application side.

That’s where people like me come in—techno-functional developers who understand both the tech and how it impacts actual hospital workflows.

We’re Not Just Techies (or Functional Consultants)

Our role sits right in the middle.

#Caché #InterSystems IRIS for Health #TrakCare #Ensemble #InterSystems IRIS #Certification #CSP #HL7 #JavaScript #ObjectScript
3
3 245