Thanks to @Yuri Marx we have seen a very nice example for DB migration from Postgres to IRIS.
My personal problem is the use of DBeaver as a migration tool.
Especially as one of the strengths of IRIS ( and also Caché) before is the availability of the
SQLgateways that allow access to any external Db as long as for them an access usinig 
JDBC or ODBC is available. So I extended the package to demonstrate this.

Hey Community,

Exciting results from a massive workload to test InterSystems API. We'll describe how we're trying to push the boundaries of the current technology in the public cloud:

⏯ Running Large-Scale Rest API in the Cloud

Hi Guys,

So I've been following this guide in using a %Library.ResultSet with a  ClassName / QueryName as described in the first example.

https://docs.intersystems.com/irislatest/csp/documatic/%25CSP.Documatic…

The code I've got so far doesn't work and is as follows:

set rs=##class(%ResultSet).%New()
set rs.ClassName="GMECC.DocmanConnect.Tables.vwNewGPs"set rs.QueryName="GetRows"set sc=rs.Execute("a")  If$$$ISERR(sc) Do DisplayError^%apiOBJ(sc) Quitwhile rs.%Next() { do rs.%Print() }		

And the referenced class is

Class

Maternal Risk can be measured from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Yasir Hussein Shakir published a very useful dataset for training ML algorithms in the detection/prediction of Maternal Risk. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/code/yasserhessein/classification-maternal-healt….

About the Dataset

Many pregnant women die from pregnancy issues as a result of a lack of

I have been developing this project for many years. He helps me a lot in my daily work as a DBA and full stack developer. This project has grown into a platform on which many of my other projects are based. You can read more about the project in the article. And I proposed this project for the contest, maybe it will be useful to you.

A few months ago, Jose and I were discussing the article Video Smart Data Services (Vision & Demo) from @Amir Samary and during that discussion, we started wondering what kind of feature would be nice to have on a future IRIS solution. 

One of the desired features is to have an IRIS iPaaS solution as I questioned here in this comment.

These last months gave me the opportunity to work with different projects and technologies, and put me in touch with applications like Tray.io or Workato, and now I can see how great an IRIS iPaaS solution could be.

IRIS Interoperability has much potential, an

Kidney Disease can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the scientist Akshay Singh published a very useful dataset for training ML algorithms in the detection/prediction of kidney disease. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/akshayksingh/kidney-disease-dataset.

About the Dataset

The kidney disease dataset has the following metadata information (source:

I think each of us has on the computer directories with photo files of relatives and friends, music albums of favorite bands and singers, as well as e-book libraries. I also have them, and I came up with the idea to implement a convenient interface for these files. You can read more about the project in the article. And I proposed this project for the contest, maybe it will be useful to you.

Hi, what’s the best way to check if your query return 0 records?

If$$$ISOK(sc) 	
    		{
   	   		 	Set tResult = sqlStatement.%Execute()
   	    
    			WHILE tResult.%Next()
    			{
					set tRecords = tResult.%ROWCOUNT
   		        }

				if (tRecords = "")
				{
					write"no records" 
				}
			}

Hi Community,

Recently, I migrated a series of Objectscript repositories from XML to UDL format.
After the migration, I was a bit disappointed by the presentation on the GitLab web interface.

Since Objectscript syntax is supported by GitHub, I thought It would be also supported by GitLab. Unfortunately, the library used by GitLab to highlight the code does not have an extension to support Objectscript.

GitLab uses the library Rouge, which can highlight over 200 languages. This is a library written in Ruby (see the GitHub page), but Objectscript is not in the list.
So, I decided to develop an

Hi developers!

What is the easy way to know what are the images available at containers.intersystems.com?

Diabetes can be discovered from some parameters well known to the medical community. In this way, in order to help the medical community and computerized systems, especially AI, the National Institute of Diabetes and Digestive and Kidney Diseases published a very useful dataset for training ML algorithms in the detection/prediction of diabetes. This publication can be found on the largest and best known data repository for ML, Kaggle at https://www.kaggle.com/datasets/mathchi/diabetes-data-set.

The diabetes dataset has the following metadata information (source:

IRIS Interoperability formerly known as Ensemble comes with many built in adapters. It does not have a service or adapter to receive mail. I have written email service to receive mail messages via SMTP which can be passed to email operation.

Now I want to load-test a production which sends messages to an external mail server using email operation. The mail server team does not want me to send them thousands of messages.

I created iris-mail app to have a substitute mail server.

My team works on an IRIS interoperability solution which is running on Red Hat OpenShift container platform. I want to test how many messages can be processed by the running webgateway pods and compute pods with data being stored in the mirrored data pods.

In order to push IRIS out of its comfort zone, I deployed multiple feeder containers and scheduled tasks on each feeder to send a load of messages at the same time.

The annual competition for InterSystems IRIS developers is coming! 

We're super excited to invite you all to join the Grand Prix contest for building open-source solutions using InterSystems IRIS data platform! 

New developers are welcome to join --> create an account now.

🏆 InterSystems Grand Prix Programming Contest 🏆

In prizes: more than $22,000

Contest running: May 9 - 29, 2022

Voting period: May 30 - June 5, 2022

Hey Developers, 

Join us as we share lessons learned from standing up the initial InterSystems cloud offerings. We'll cover the challenges of standing up a SaaS and how to meet them:

⏯ Running InterSystems IRIS Workloads in the Cloud: Lessons Learned

Hi Developers!

This is yet another short post that is intended to simplify developers' life. Now we'll talk about how to make GitHub run unit tests with every push to the repository by adding just one file to the repo. For free.  On Github Cloud. Sounds great, isn't it?

It is possible and very easy to do. Credit goes to @Dmitry Maslennikov (and his repo), ZPM Package Manager, and GitHub Actions.  Let's see how this all works!

There is a popular package "WebTerminal". It is excellent in most situations.
Except:

• running system commands in your operating shell is not so easy
• as it communicates to the IRIS host over HTTP and WSS it consumes 2 connections
  • With only 5 connections in the community license (and the "Grace Period of CSP")
  • you can hit the limits rater fast: 2 Webterminals + 1 SMP and you are done
• WebCommand is a pure CSP page consuming just 1 single connection
• WebCommand allows multiple ObjectScript command lines running in sequence
• With $ or ! your command goes to Operating System same as with

One of the crucial business dimensions is the dimension “Where”.

Hi Community,

We're pleased to invite you to the upcoming webinar in Spanish called "SAM: Monitoring InterSystems IRIS with Grafana and Prometheus".

Date & Time: June 15, 4:00 PM CEST

Speaker: @Pierre-Yves Duquesnoy, Sales Engineer, InterSystems Iberia

How do I use ANSI escape codes to produce green text in InterSystems IRIS terminal?

Is it possible train an IntegratedML model on docker build or docker up?

Hi All,

I am looking for a reporting tool (Analytics purpose) which can be built using cache object script/MUMPS. Basically my requirement is to find a tool where I can implement cache code to report data for my application.

I am unaware of DeepSee and how it works. Please assist for the same.

Hey Developers, 

Create a relational schema from your FHIR repository for building analytics and decision support:

⏯ Introduction to the FHIR Schema Generator

You have read about OAuth2 / OpenID Connect but you don't know how to use it? Have you ever needed to implement Single Sign-On (SSO) or secure web services based on tokens? Did you have to add authentication / authorization to your web applications or services and you didn't know how to start?

What about a step by step example where you can set up an authorization server, a client and a resource server? Here you can find an example where you will configure InterSystems IRIS instances to act as each one of these OAuth2 roles.

A brief introduction

Authentication is the process of verifying that

I want to embed the DTL editor in a third party web application.

If I open up the DTL editor then the full management portal banner is displayed.

http://localhost:52773/csp/healthshare/user/EnsPortal.DTLEditor.zen?DT=Foo.NewDTL1.dtl

If I open the same DTL in studio then I get just the editor, the banner is not displayed.

The DTLEditor page has the property studioMode that controls the banner display, but its not obvious how this is set.

Q. Is there a way to control that property without extending and shimming the page?

Q. Could there be a URL parameter or header that controls that value?

Q. If I

Hello IRIS Community,

InterSystems Certification is developing a certification exam for IRIS system administrators and, if you match the exam candidate description given below, we would like you to beta test the exam. The exam will be available for beta testing on June 20-23, 2022 at InterSystems Global Summit 2022, but only for Summit registrants (visit this page to learn more about Certification at GS22) . Beta testing will open for all other interested beta testers on July 18, 2022. However, interested beta testers should sign up now by emailing certification@intersystems.com (see below for

Free certification exam attempt for all registered attendees of Global Summit 2022!

InterSystems is proud to offer free InterSystems Certification exam attempts ($150 value) to all registered attendees of InterSystems Global Summit 2022. The free exam attempt will be made available for any of the 7 live-proctored sessions during the Summit.

Hey Community,

Check out the latest video on  InterSystems Developers YouTube channel:

⏯ Drinking Our Own Champagne: InterSystems AppServices' Move from Zen Reports to InterSystems Reports

Colleagues, hello!

In this article, I will tell you how we reduced the report generation time from 28 minutes to 1 minute. Let me tell you how we achieved this.

I hope that if necessary you will be able to reproduce the same results for yourself. Useful links will be inside this post, so read to the end.

Let's start.

Report

We are reporting for a company using Adaptive Analytics and InterSystems Reports Server.