I am currently experiencing frustration with trying to Authenticate an Active Directory account through JDBC as the Hospital System moves from OnPrem SQL Server to using Azure SQL Server with Microsoft Entra Authentication.

Microsoft cannot give me a straight answer of what is required from a JDBC standpoint to authenticate from a Linux environment.

I am working with WRC, but we are both struggling to find the specific answer for JDBC.If I use my local desktop and JDBC to connect through DBeaver I don't have an issue.

When you deploy code from a repo, class (file) deletion might not be reflected by your CICD system.
Here's a simple one-liner to automatically delete all classes in a specified package that have not been imported. It can be easily adjusted for a variety of adjunct tasks:

set packages = "USER.*,MyCustomPackage.*"set dir = "C:\InterSystems\src\"set sc = $SYSTEM.OBJ.LoadDir(dir,"ck", .err, 1, .loaded)
set sc = $SYSTEM.OBJ.Delete(packages _ ",'" _ $LTS($LI($LFS(loaded_",",".cls,"), 1, *-1), ",'"), "/generated=0", .err2)

The first command compiles classes and also returns a list of loaded classes. The second command deletes all classes from specified packages, except for the classes loaded just before that. Any generated classes are also skipped since they won't be in the loaded list.

We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL

jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified

They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra. I was given the following URL

jdbc:sqlserver://<server>:<port>;user=<user>;password=<password>;encrypt=true;trustServerCertificate=true;hostNameInCertificate=<certificate>;loginTimeout=30;Authenti

Not sure there are many that connect to MS SQL to execute queries, stored procedures, etc, but our Healthsystem has many different MS SQL based databases we use within the Interoperability environment for various reasons.

With the push to moving from on-prem to the Cloud we ran into some difficulties with our SQL Gateway connections and knowing how to config them to use Microsoft Entra for Active Directory Authentication.

There are many articles out on the web, but there was not one that could give us the full answer to what we needed to do, and Microsoft wasn’t much help.
I figured I would

We now get to make use of the IKO.

Below we define the environment we will be creating via a Custom Resource Definition (CRD). It lets us define something outside the realm of what the Kubernetes standard knows (this is objects such as your pods, services, persistent volumes (and claims), configmaps, secrets, and lots more). We are building a new kind of object, an IrisCluster object.

apiVersion: intersystems.com/v1alpha1
kind: IrisCluster
metadata:
  name: simple
spec:
  licenseKeySecret:
    #; to activate ISC license key
    name: iris-key-secret
  configSource:
    #; contains

Hey, So the title pretty much describes the question:
Where and How can i see the Stream that contains the response back to the client of a CSP application.
When the request is being processed and finished we return a response to the client - We do that by writing the data to a stream and that stream is sent back to the client.
I wanted to know how i can access the point right before that Data is actually written to the client back (meaning the place where the response is actually being send back, the last point of contact).
And was not able to find about it in the DOCS so would love to get a

Hi, I am currently setting up a new API using %CSP.REST - I've gotten swagger spec generation to work like such:

Class Api.DispatchRouter Extends%CSP.REST
{

XData UrlMap
{
<Routes>

<Map Prefix="/test" Forward="Api.Controllers.TestController"/>

<Route Url="/swagger" Method="GET" Call="SwaggerSpec"/>   
</Routes>
}

ClassMethod SwaggerSpec() As%Status
{
    Set tSC = ##class(%REST.API).GetWebRESTApplication($NAMESPACE, %request.Application, .swagger)
    Do swagger.info.%Remove("x-ISC_Namespace")
    Set swagger.basePath = "/csp/myapi"Set swagger.info.title = "My API"

The latest extended maintenance releases of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect are now available.

✅ 2024.1.3

Release 2024.1.3 provides bug fixes for any of the previous 2024.1.x releases, including the fix for the following alert recently issued - Alert: Invalid Data Introduced to Database and Journal files with Specific....

You can find the detailed change lists & upgrade checklists on these pages:

• InterSystems IRIS
• InterSystems IRIS for Health
• HealthShare Health Connect

How to get the software

The software is available as both classic

Hi Developers!

Welcome to Issue #18 of the InterSystems Ideas newsletter! This edition highlights the latest implemented ideas:

✓ Ideas brought to life during the "Bringing Ideas to Reality" programming contest
✓ Ideas implemented by InterSystems in Q4 2024
✓ New article featuring an idea realized by the talented Musketeers team

InterSystems is proud to sponsor NUS Health Hack 2025 and invite innovators, developers, startups and health tech professionals to join this exciting digital health tech hackathon!

Organized by the National University of Singapore - Yong Loo Lin School Of Medicine, this hackathon will take place from February 8th to March 29th, 2025, and will bring together an incredible mix of healthcare professionals, developers, students, startups and tech companies driving innovation in the industry.

Why Join?

• Make an Impact: Solve real-world healthcare challenges.
• Network: Collaborate with like-minded professionals, innovators, and industry leaders.
• Get Support: Access guidance from mentors throughout the 4-week development phase.

InterSystems is providing access to our Vector Search technology, which participants can leverage for their projects. Plus, our tech mentors will be available to offer support throughout the event. Learn more about the InterSystems challenge and prizes here.

How It Works

Hi, I am coming unstuck with a current mapping from HL7 to XML using the DTL editor with an XML schema (imported by XSD).

My output keeps prefixing the elements with "xsd_2" despite this not being defined in the targetnamespace within my XSD file. 

Would anyone have any idea as to where this is creeping in? Any advice would be greatly appreciated. 

My XSD namespace etc are setup as follows:

<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           targetNamespace="http://voicetechnologies.co.uk/winvoice/importation"
           xmlns="http://voicetechnologies.co.uk/winvoice/importation"
     

Hello all! We fully tested our system http://DataAI.link on InterSystems Cache database and on old IRIS. We cannot find a free download of IRIS for developer as it was before. We are looking for help from the community to test our system from the http://DataAI.link by register a user with connection to your testing IRIS database and play with our reports, analytics, AI. Another way is to trust us with connection string to your testing IRIS database and we will test our system and report results to you. Thanks for your help! Irina Yaroshevskaya PhD, Yanbor LLC http://DataAI.link

Updated 12/10/25

Hi Community,

Looking for a way to onboard your team with InterSystems IRIS® for Health? Unlock the full potential of this platform by using these InterSystems learning resources. With a mix of online and in-person training, you can support various roles in your organization and equip your team for success.

Onboarding Resources for Every Role

Developers

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

System Administrators

Developing with InterSystems Objects and SQL – VirtualFebruary 10-14, 2025

• This 5-day course teaches programmers how to use the tools and techniques within the InterSystems® development environment.
• Students develop a database application using object-oriented design, building different types of IRIS classes.
  
  • They learn how to store and retrieve data using Objects or SQL, and decide which approach is best for different use cases.
  • They write code using ObjectScript, Python, and SQL, with most exercises offering the choice between ObjectScript and Python, and some exercises requiring a

Hi,

A SFTP server on which we connect has increased its security level by disabling the use of the ssh-rsa algorithm
Since then, SFTP connections with ssh keys are no longer made through Intersytems but through tools such as FileZila and Putty.Looking at the Logs I see that the generated ssh key of type RSA supports other modern algorithms such as rsa-sha2-256 / rsa-sha2-512 ...I wanted to know if the Intersystems SFTP client supports modern algorithms?Or is there an ssh configuration that excludes rsa-sha2 algorithms that will need to be disabled?

The question I have is if I run an External backup this library rotuine is called:
##Class(Backup.General).ExternalFreeze()

Is there a command I can run that shows me the Iris system is frozen due to the call to ##Class(Backup.General).ExternalFreeze()?

If the system is frozen I cannot sign into Iris terminal session.

I backup the IRIS server using Veeam. Veeam calls the "freeze" script, snapshots the server in VMWare, then calls the "thaw" script.
Veeam then backs up the VMWare snapshot.

I have had cases where Iris was frozen and I'm guessing this could be caused by a call to

Hello guys,

I need to tranform columns into rows or rows into columns.
I'm using only SQL Cache.

The code:

SELECT
    codRepresentante
    ,vendasAbril
    ,vendasAgosto
FROM
    Ped.MetasRepresen
WHERE ano = 2024

The columns: 

Can you help me?

Thanks

Hello,

I hope this is a simple ask..

basically I need to create local files daily at a certain time for example 11:30pm.

1. file name needs to be like  xxx__20250113.txt , the date part should be next day's timestamp with format YYYYMMDD, so I will write about 17 files like that with different names.

2. write a dummy hard coded word for example “Dummy Word” in the file.  the file eventually will be used by other operations to add hl7 message on top of this  in it with the live interface message. 

3. this needs to be done every night at 11:45pm

So how am I going to implement this?

     1.

Hi Community!

We're happy to share the next video in the series dedicated to Gen AI on our InterSystems Developers YouTube:

⏯ Open Source LLMs

Hi Everyone!

The Certification Team of InterSystems Learning Services is currently developing an InterSystems ObjectScript Specialist certification exam, and we are reaching out to our community for feedback that will help us evaluate and establish the contents of this exam.   

Please note that this is one of two exams being developed to replace our InterSystems IRIS Core Solutions Developer exam. You can find more details about the other exam, InterSystems IRIS Developer Professional exam, here. 

How do I provide my input? Complete our Job Task Analysis (JTA) survey! We will present you with a

Hi everyone! I am hiring an InterSystems IRIS Engineer. If you or anyone you know has a qualifying skillset and is interested, please email me your resume and I will give you a call. Thanks!! email: isabella.nolen@insightglobal.com You can also apply to my posting on LinkedIn: https://www.linkedin.com/jobs/view/4125879698/?alternateChannel=search&… 

Position: IRIS Engineer

Location: REMOTE in the United States - must work EST time zone

Working Hours: Monday-Friday 8am-5pm EST

Duration: 6-month contract (extensions

Hi,

I'm using embedded Python as follows:

AUMHTESTTC01:%SYS>do ##class(%SYS.Python).Shell()
Python 3.6.15 (default, Sep 232021, 15:41:43) [GCC] on linux
Type quit() or Ctrl-D to exit this shell.
>>> import iris
>>> mirror=iris.cls('SYS.Mirror')
>>> pri=[]
>>> alt=[]
>>> status=mirror.GetFailoverMemberStatus(pri,alt)
>>> print(status)
1>>> print(pri)
[]
>>> print(alt)
[]
>>> exit()

However the equivalent ObjectScript works:

%SYS>set sc=##class(SYS.Mirror).GetFailoverMemberStatus(.pri,.alt)
%SYS>zw pri
pri=$lb("SERVERA.FOO.BAR.ORG/STAGE","SERVERA.foo.bar.org|2188","Primary","Acti

Hi experts, please, do you know cause this errors in cconsole?
I'd like know what can I investigate.

01/16/25-18:25:40:081 (11368) 0 Job failed in StartDeepSeeAgents^%SYS.DeepSee:  tPriority=H, n=117, pAgentCount=128, pCount=116, $zu(56,3)=<UNKNOWN ERROR>, $zu(56,5)=JOB^%ZSTART, $zu(56,6)=
01/16/25-18:26:45:922 (10800) 2 ROLLFAIL: <STORE>rbbulk+27^ROLLBACK
01/16/25-18:26:45:922 (10800) 2 Process halts and system might hang when CLNDMN retries the rollback
01/16/25-18:26:45:922 (10800) 2 JOBEND_LOCKCLR: not all locks released in TRANSCB job#125, tid=125, h,t=0xbf0d4318,0xbf01b618
01/16/25-18:26:45:92

I'm working on some code that would benefit from being able to see whether or not a project file has been saved in Studio.
I can see when I make changes, that the project name has an asterisk added to it:

In searching for it, however, I haven't been able to find any methods or calls to access the property/check that controls that asterisk.
My question is whether anyone out there knows if that is accessible and if so then how can it be accessed.
I'd like to add a check in my code that enforces that the project file must be saved prior to proceeding with the intended action.

Hey Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Containers & Kubernetes - Proper Use and Lessons Learned @ Global Summit 2024

Hello everyone,

I’m facing issues with replicating data from my Caché 2016 database to a PostgreSQL database. I need to handle around 300 data updates per minute, and whenever certain tables are modified, those changes must be reflected in other databases.

So far, I’ve tried various approaches, including:

• Setting up an intermediary API,
• Using Azure Service Bus,
• Leveraging Caché Jobs,
• All of which rely on table triggers as the entry point.

However, each of these solutions has led to performance bottlenecks and system lockups.

It's been a while since I've posted about Embedded Git on the Developer Community, and I'd like to provide an update on the massive amount of work we've done this year and where we're going next.

Context

If you're building solutions on IRIS and want to use Git, that's great! Just use VSCode with a local git repo and push your changes out to the server - it's that easy.

But what if:

• You're collaborating with other developers on a shared, remote development environment and want to avoid stepping on each others' toes by editing the same file at the same time
• You're using editors based in the

In the previous article. Practices of class members and their execution within embedded Python. We will now turn our attention to the process of switching namespaces, accessing global variables , traversing and routine executions within embedded Python.

Before proceeding to the other functions. let us briefly review the execute function within the iris package. This function is exceptionally beneficial for executing the arbitrary ObjectScript functions and class invocation.

Hello,

We are doing the hl7 integration migration from cloverleaf to InterSystems Healthshare.  so I have an application has workflow like below, and I am seeking the suggestion of the workflow in InterSystems HealthConnect cloud version.

The current application has workflow like this.

1. local server has Cron job every night to create about 10 files with specific name and next day's timestamp in file name with a dummy word in it and the files located in local cloverleaf server. pretty much 1 facility per file, file name has facility name and timestamp in it.

2.