Hello and welcome to the June 2025 Developer Community YouTube Recap.
InterSystems Global Summit
By Rochael Ribeiro Filho, Fernando Ferreira
By Benjamin De Boe, Qi Li
By Alex MacLeod, Jason Sherwin
By Renan Lourenco
By Jim Breen, Jenny Ames, Art Dirik, Chi Nguyen-Rettig
0 0
0 58
InterSystems Developer Community is a community of 25,766 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi developers!

There is a very neat variable in IPM ${ipmdir} that lets packages be installed on a particular IRIS server and ensures that the data and resources they bring don't mess around as ${ipmdir} variable during the installation transforms into:

iris installation dir/ipm/package_name/version/whatever_you_install_here

It is very convenient, e.g., to bring some data and resource files that can be useful during the installation setup, e.g., via FILECOPY. Indeed, suppose you bring some csv_file, e.g. titanic.csv via FILECOPY as:

<FileCopy Name="data/titanic.csv" Target="${ipmdir}data/titanic.csv"/>

or even the whole folder of data in the source code repo into the package:

<FileCopy Name="data/" Target="${ipmdir}data/"/>

And in the case of Iris in Docker it resides in:

/usr/irissys/ipm/package_name/1.0.0/data/titanic.csv

This is all great, but is there any way for the installed code to determine the location of the data files? It'd be neat to let the installed app know somehow where is the data that came with it? Could it be the method in the IPM client that will resolve ${ipmdir} for the app?

0 2
0 55

New to using Analytics and using Dashboards. We have this Report, SQL Query that lists out the Activity per Data Source in Health Share Provider Directory. Instead of running it as a report, because it takes a while to run, was wondering if there is a way to do this as a Dashboard instead.

How can I take the SQL from this report and create a Dashboard instead?

0 3
0 54

The operations manager in our company was using structured logging in IRIS to tail information to an on-prem monitoring tool and started to get concerned with the ever-growing size of the output file. He just leaned across the aisle here and informed me that the output file has no mechanism for rolling this file over at a certain point for archival or disposal. Sure enough, I can't find any documentation to refute this.

0 1
0 56

Hey Developers,

Enjoy the new video on InterSystems Developers YouTube

First Customers Using Vector Search - Real World Experiences and Lessons Learned @ READY 2025

https://www.youtube.com/embed/HZrxAxrQges
[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 56

Recently, we implemented some Java-based services using JDBC. And some time ago, I refactored some legacy PHP programs that used "csession" for communication between systems to use PDO with ODBC.

This raised a question for me about how license management is done in this scenario.
Is a license used per pool? Or per connection? How is this management done?

1 0
0 56

Hey Community!

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

Before the Lightbulb: Understanding the First Phase of the AI Revolution in Medicine

https://www.youtube.com/embed/CPyoUqi-i-o
[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 56

Hi, Community!

Need to install a HealthShare solution module? Follow this simple step-by-step process to get started!

Deploying HealthShare Solution Modules with InterSystems Package Manager

https://www.youtube.com/embed/VJKP0pLW5nI?utm_source=youtube&utm_medium=social&utm_campaign=VJKP0pLW5nI
[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 56
Question
· Sep 10, 2025
FDN Help

New to using FDN, and the Form Wizard on learning.intersystems.com does not go into enough detail to help with my questions...

  1. Is there a way to control text size within the Form Definition?
  2. Is there a way to make Sections more of a Page based caching then, waiting for the entire page to load?
0 1
0 55

Within Provider Data Management, I wanted a way to capture the Code Table mapping errors thrown by HSPD.MDM.FlowControl.Process into a Workflow Task for someone to work. However, because HSPD.MDM.FlowControl.Process can get overwritten during the upgrade process, I cloned it into another Business Process so we can use Workflow Tasks to troubleshoot mapping errors.

0 1
0 54

It’s time to bring some spotlight to the authors and participants of our September Article Bounty! A big thank-you to everyone who took part💙

Special shout-out to those who took the time to write brand-new articles and share their expertise (each received 5,000 points 🎉):

@Robert Cemper >> "IRIS in Docker for beginners"
@sween >> "IKO Plus: Stretched Cross Regional IrisCluster with Tailscale on Google Cloud Platform"
@Ariel Glikman >> "High Availability IAM"
@Pietro Di Leo >> "Running InterSystems IRIS with Docker: A Step-by-Step Guide - Part 1: From the Basics to Custom Dockerfile"
@Guilherme Tonelotti >> "Create a JDBC connection with Mysql Cache"
@Vachan C Rannore >> "From "Oops" to "Aha!" - Avoiding Beginner Mistakes in ObjectScript"

And also to those who joined the challenge and helped us in the search for interesting articles (each received 30 points 🙌):

4 0
1 55
Hello and welcome to the May 2025 Developer Community YouTube Recap.
InterSystems Global Summit
0 0
0 55

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:

4 0
0 54

Hey Community!

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

Foreign Tables In 2025.2 @ Ready 2025

https://www.youtube.com/embed/pIMa7lqWiHc
[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]

<--break->

0 0
0 54
Question
· Nov 10, 2025
Foreign Table datatypes

Hello!

I'm trying to create some foreign tables to a PostgreSQL database. In some cases, columns with certain datatypes cannot be consumed by IRIS and the following error is thrown:

[SQLCODE: <-237>:<Schema import for foreign table did not return column metadata>]

[%msg: <Unkown data type returned by external database>]

For example: serial4 typed ID columns are typical examples. Is it possible, what's the best way of resolving these datatypes, which- seemingly- don't have proper JDBC metadata mappings?

0 0
0 54

Hey Community!

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

Source Control Interoperability Productions in a Decomposed Format @ Ready 2025

https://www.youtube.com/embed/7SF9kntjQmM
[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 54

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.

2 0
0 53