Hi,

I running an SQL so I can find the databases with the largest amount of free space. This is in case I can compact the databases.

However SQL cannot find the SYS.Database table.

Can someone please explain how to fix?

[SQL]TEST:%SYS>>select * from SYS.Database
ERROR #5540: SQLCODE: -30 Message:  Table 'SYS.DATABASE' not found

[SQL]TEST:%SYS>>  << entering multiline statement mode, 'GO' to execute >>
   1>>select DatabaseName, Directory, Size, Free, DiskFreeSpace
   2>>from SYS.Database
   3>>order by DiskFreeSpace DESC
   4>>go
ERROR #5540: SQLCODE: -30 Message:  Table 'SYS.DATABASE'

When debugging a routine in vscode which requires input to a READ, there doesn't appear to be any way to enter the input.  If the routine is running in a terminal with vscode attached then input can be done there, but can it be done with no attached process?

FHIR repositories, applications and servers typically serve clinical data in small quantities, whether to return data about a patient, their medications, vaccines, allergies, among other information. However, it is common for a large amount of data in FHIR/JSON format to be requested to be used to load into Data Lakes, identifying study cohorts, population health, or transferring data from one EHR to another. To meet these business scenarios that require large extractions and loads of data, it is recommended to use the FHIR Bulk Data Access feature provided by HL7 institution.

The InterSystems

Introduction to running WSGI in IRIS

With IRIS 2024+, users can host WSGI applications using Security.Applications. As an example, a user can do something like this

Minimum working example

Hi all!Here I would like to share how we use vector search and GenAI with InterSystems technology.As an example, I'll describe BG-AppealAI project, which our company submitted to the InterSystems Vector Search, GenAI and ML Contest.BG-AppealAI application can write an appeal if you upload an insurance contract and the insurance company’s letter with a refusal to pay medical expenses.Of course, we are aware that at the moment AI has not reached such a level as to create ready-made legal documents.

We are trying to create a JWT in order to get oauth2 token from login.microsoftonline.com and then use that token to get key/secret from an Azure Key Vault.

It seemed like it would be quite straightforward by using the Create method of class %Net.JSON.JWT

But already trying to set the first header parameter alg PS256 as specified by https://learn.microsoft.com/en-us/entra/identity-platform/certificate-c… becomes a problem. Just to test, I do this:

set JOSE = {
 "alg": "PS256"
}

and then using that and an arbitrary claims as parameters in Create method gives this

"Unsupported JOSE

Hi, this post was initially written for Caché. In June 2023, I finally updated it for IRIS. If you are revisiting the post since then, the only real change is substituting Caché for IRIS! I also updated the links for IRIS documentation and fixed a few typos and grammatical errors. Enjoy :)

In this post, I show strategies for backing up InterSystems IRIS using External Backup with examples of integrating with snapshot-based solutions. Most solutions I see today are deployed on Linux on VMware, so a lot of the post shows how solutions integrate VMware snapshot technology as examples.

IRIS backup

Hello All,

 I'm new to InterSystems, just wanted to check if we can configure the Visual Studio code to use it as Studio for Intersystems development. I tried following the instructions in few posts but nothing worked. Please  guide me to setup this

Urgently Looking for the following InterSystems Technology Skills:
(Must have Strong InterSystems (ISC) technology background and some Google cloud skills experience along with InterSystems IRIS).

1. Has 5+ years using InterSystems Object oriented scripting skills with FHIR experience on IRIS. HL7 and/or ADT and/or CCDA to FHIR.
2. 5+ years working experience on InterSystems IRIS
3. 5+ years having an Understanding on different Data standards including FHIR, HL7.
4. Different healthcare Data formats to be converted to FHIR using IRIS-InterSystems Platform.
5.

Description

Support the Department of Veterans Affairs (VA) Office as a Senior Health Data Migration Engineer. Assess the current VA's data migration requirements, maintain and update the strategy to meet the requirements. Review error and trace logs. Track messages by domain and reconcile table counts with Cerner. Review secure data message transmission logs. Track the number of records sent per message by domain. Monitor Queue Depth by service, process and operation. Track retry attempts and suspended messages. Validate and update data integration reports in support of VX130 data domains. Review, update, and maintain Cerner to CDW, VistA, Millennium or Cloud Database data mappings for potential data migrations. Evaluate and integrate data from multiple sources, which requires data mapping from one data source to another minimizing any data loss. Document VistA Extraction and monitoring process and update existing documentation quarterly. Interpret Cerner’s Data model to be used for the construction of API’s, queries, and reports that will be consumed by internal or external applications. Review Domain adds to Ensemble Production. Validate Ensemble data flows built using VX130 ClassBuilder.

Job Title: Software Engineer- IRIS InterSystems

Work Location: Remote

Note:

Main Demand is that we need someone with technical familiarity of IRIS, Familiar with Integration, software development, maintenance, designing, configuration and so on. FHIR good to have. Do not go 100% by the Job description, lets have a discussion and get to know whats exact demand is.

• We are seeking a skilled IRIS/InterSystems Engineer to join our dynamic team.

Waters/Integrated Software Solutions is a software development company providing mainly laboratory health solutions for over 30 years to some of the most well-respected hospitals/organizations around the world. Clients include Newborn Screening laboratories in the United Kingdom, the Middle East, Canada, the United States, and Australia. Established in 1983, they came from modest beginnings in Sydney with a small team of passionate people who wanted to help change laboratory software for the better.

The Role Overview:

To join a dedicated software team working in delivering flexible, robust, and

Dear community, we are building up a digital backbone for our 17 hospitals and looking for reinforcement within the team. Maybe this is something for you or someone you know?

👩‍💻 Are you an (#InterSystems) developer and would you like to join an intelligent, bright and internationally diverse team (mainly in Zurich, but also in South Africa and the Middle East)?
🤘 Are you keen to use your skills for clinically relevant use cases and to build a Group-wide value-creating platform?
😁 Are you up for mischief and humor in the workplace? 
📣 Are you willing to share frustration with us when things

We're looking for an experienced developer to join our team and help with the project on a part-time basis (20-30 hours a week). Required experience includes InterSystems Cache, PHP, and API. We're ready to start immediately if you're available. Fluency in English and the ability to work in the US time zone is preferred.

About Us:
Redline Coders, an IT consulting firm in California.

Position Details:
- Remote
- 20-30 hours a week
- Duration: 1-2 months

Need Iris Engineer to build ADT to FHIR, CCD to FHIR conversion on IRIS platform.

Onshore- offshore model. candidate will be providing guidance to offshore team about IRIS design patterns and all.

o IRIS expertise is expected.

• Working experience on InterSystems IRIS.
• 7-10+ years in Understanding different Data standards including FHIR, HL7.
• 7-10+ years in Different healthcare Data formats to be converted to FHIR using IRIS-InterSystems platform
• 7-10+ years building ADT, custom Object script, ETC
• Experience with cloud technologies

Will be working ET/CT time zone shift.

No

Hello,

Our team is growing and we have an FTE, fully remote role open for an interoperability engineer. We utilize Healthshare Connect Cloud and host an instance of Epic Ambulatory. Please apply below or message me for more information.
https://careers.davita.com/job/R0355708/Integration-Engineer-Epic

Hello All,

I am looking for some Integration engineers who have expertise in IRIS/Healthshare in North America.

Have a project going on , if interested please feel free to reach out to me.

Just curious what the process is for debugging either a .py file that is uploaded to a specific namespace/location or a python classmethod defined in a .cls file.

My method can be run via the "Debug" breadcrumb but it doesnt hit breakpoints it just runs without a debugger. Also objectscript methods debug correctly

Using Flask, REST API, and IAM with InterSystems IRIS

Part 3 – IAM

InterSystems API Manager (IAM) is a component that allows you to monitor, control, and manage traffic from HTTP-based APIs. It also acts as an API gateway between InterSystems IRIS applications and servers.

Hi Community,

Enjoy the new video on InterSystems Developers YouTube:

⏯ Globals in Embedded Python for Dummies

Hi Folks!

Have a very simple question, I hope :)

How can I make sure that user 'John' is already created in the IRIS system?

Preferabbly via SQL?

thanks a lot!

Using Flask, REST API, and IAM with InterSystems IRIS

Part 2 – Flask App

Flask is a web development microframework written in Python. It is known for being simple, flexible, and enabling rapid application development.

Installing Flask is very simple. Once you have python installed correctly on your operating system, we need to install the flask library with the pip command. For REST API consumption, it is advisable to use the requests library. The following link provides a guide to installing flask: https://flask.palletsprojects.com/en/stable/installation/

Using Flask, REST API, and IAM with InterSystems IRIS

Part 1 - REST API

Hello

In this article we will see the implementation of a REST API to perform the maintenance of a CRUD, using Flask and IAM.

In this first part of the article we will see the construction and publication of the REST API in Iris.

First, let's create our persistent class to store the data. To do this, we go to Iris and create our class:

Hi,

Is it possible to change the WebGateway Port i.e. from i.e. 57773 to 443 to use it as:

https://myserver/iris/csp/sys/%25CSP.Portal.Home.zen.....etc.

Meaning: https://myserver:443/iris/csp/sys/%25CSP.Portal.Home.zen

Are there any known problems or other suggestions? 

Hey everyone.

I came across some issues when setting up Freeze and Thaw batch scripts for use with VMWare in a Windows ecosystem, and I wanted to share what I found in the hopes it can help others. This was undertaken in an environment using Healthconnect 2019.1.x.

IRIS not up (2)

It seems that the sample script from the documentation in my my case would tell me that the environment was not running (despite it running). To correct this, I provided the filepath to the Mgr location as so:

c:\InterSystems\HealthConnect\bin\irisdb -s"C:\InterSystems\HealthConnect\Mgr" -U%%SYS

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

As you might have heard, we just introduced the InterSystems API Manager (IAM); a new feature of the InterSystems IRIS Data Platform™, enabling you to monitor, control and govern traffic to and from web-based APIs within your IT infrastructure. In case you missed it, here is the link to the announcement.

In this article, I will show you how to set up IAM and highlight some of the many capabilities IAM allows you to leverage.

Overview

After having some discussions at Global Summit and using a lot of package managers in my day to day development (npm,nuget,Chocolatey, etc) in addition to recently using the InterSystems Package Manager for some CICD process I'm building using Intersystems IRIS and IRIS 4 Health, I wanted an easy and integrated way to search/view/install packages related to the Intersystems tech stack.

I recently built a VSCode extension for IPM repositories that I will be open sourcing and publishing to the marketplace but wanted create this post to get some feedback from the community.

Some features

Hi all,

I have a passthru REST setup using EnsLib.HTTP.GenericService and EnsLib.HTTP.GenericOperation. Works well.

I am adding some logic to the Operation and for some scenarios I want to return an HTTP 40x response status code.

I create an httpResponse object within the Business Operation, but I can't figure out how to set the http response status code that is returned to my Posstman client that initiated the request. I set StatusCode=400, and StatusLine and ReasonPhrase properties - but when the ultimate requestor (Postman) receives the response back it is a 200 status code.