Does anyone have insight into how the Stream Global Compression works in 2022? I'm particularly interested in the XDSb repository on the Edges. As I understand it anything new will be compressed. Is there a compression method that is used that can be utilized by other code? How are the retrievals aware that the contents are compressed in order to de-compress them? 

InterSystems is pleased to announce that the extended maintenance release of InterSystems IRIS, InterSystems IRIS for Health, and HealthShare Health Connect 2021.1.3 is now available. This release provides a few selected features and bug fixes for the previous 2021.1.x releases.

You can find additional information about what has changed on these pages:

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

Please share your feedback through the Developer Community so we can build a better product together.

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems Security Development Lifecycle @ Global Summit 2022

Hi

We are just looking to migrate to IRIS under windows and as the IRIS databases are 8k just wondered if anyone has configured windows with a block size for the database drive other than the default 4k.

Any thoughts ?

cheers

Gary

Community webinars are back!

And we're thrilled to invite you to the webinar of George James Software, partners of InterSystems:

👉 "Demo of Deltanji: source control tailored for InterSystems IRIS" 👈

Join this webinar to learn how the Deltanji source control can seamlessly integrate into your development lifecycle and see a demonstration.

🗓️ Date & Time: Thursday, February 23, 4 pm GMT | 5 pm CET | 11 am ET

Hi all!

I'm sharing a tool for data ingestion that we have used in some projects.

DataPipe is an interoperability framework for data ingestion in InterSystems IRIS in a flexible way. It allows you to receive data from external sources, normalize and validate the information and finally perform whatever operation you need with your data.

Model

In first place, you need to define a model. A model is simply a class that extends from DataPipe.

The following code snippet uses GZIP to compress/decompress a file. Choose a file by specifying a file path in the "filename" variable.

Class objectscript.GZIP Extends %RegisteredObject
{
	classmethod test() {
		//Export Global(s) uncompressed
		set filename="C:\Temp\myglobal.xml"
		do $System.OBJ.Export("^oddEXTR.gbl",filename)
		//Open exported Globals
		set uncompressed = ##class(%FileBinaryStream).%New()
		set uncompressed.Filename=filename
		Set compressed = "C:\temp\mycomglobal.

Setting the Scene

Suppose you have the following 2 persistent classes that are both JSON-enabled (i.e. extends %JSON.Adaptor or %pkg.isc.rest.model.adaptor)

Class Test.Employee Extends (%Persistent, %pkg.isc.rest.model.adaptor) { 
  Parameter RESOURCENAME = "employee";
  Parameter firstName As %String;
  Parameter lastName As %String; 
  Relationship projects As Test.Project [ Cardinality = many, Inverse = employee) ];
}

Class Test.Project Extends (%Persistent, %pkg.isc.rest.model.

Hello,

Could someone help me with a solution, for example "dump" to IRIS.DAT, I mention that it is difficult to manipulate a file of ~ 200 GB. I would be interested in generating an IRIS.DAT file containing the "schema" without any information.

Thanks !

Good Morning All!

We would like to add our custom reporting with the IRIS database which is running on IDX at client server. Would need a technical documents which allow us to review the tables and its definitions. I tried to install ODBC but it not showing the schema of all tables.

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-World CI/CD: Keep Calm & Build On @ Global Summit 2022

Hi is there a simple way to export everything related to a production and import in another instance?

For example exporting a production saving db, ns, mapping, webapp related, resources, roles and so on

I am trying to pull down the webgateway from containers.intersystems.com and I am receiving the following errors... Please advise

[roth16@int-lxiris-vd02 tls-ssl-webgateway]$ docker pull containers.intersystems.com/intersystems/webgateway:2021.1.0.215.0
Emulate Docker CLI using podman. Create /etc/containers/nodocker to quiet msg.
Trying to pull containers.intersystems.com/intersystems/webgateway:2021.1.0.215.0...
Error: initializing source docker://containers.intersystems.com/intersystems/webgateway:2021.1.0.215.0: reading manifest 2021.1.0.215.0 in containers.

Hi all,

I am trying to understand how to work with Analytics but I get the message "Analytics is not enabled in the USER namespace"

How can I enable that for my namespace?

I am currently using iris-community:2023.1.0.185.0.

Thanks in advance!

Hello!

We have an integration that reads a file from labresults and needs to be transformed into another file format.

The transformation and incoming file correlate against a schema. In that schema there is a type declared as %xsd.double.
As these values ​​are labresults, we are not allowed to change the expression of the value in any way. For example, 1.0 must not become 1. And 2 must not be written as 2.0. As well as 0.3 must not be written as .3 and so on.
I am not allowed to change the type in the schema to %String. I am not allowed to change anything in the schema at all.

Why I've decided to write this

Once again I had a challenge that costed me some time and a lot of testing to reach the best solution. And now that I've managed to solve it, I'd like to share a little bit of my knowledge.
 

What happened?

In a namespace there were a lot of similar classes, so to make them simpler there were a superclass with comon properties. Also, there are relationships between them. I had to export one of them to JSON, but I couldn't change the superclasses, or I would break down the flow of many other integrations.

 InterSystems announces its second developer preview, as part of the developer preview program for the 2023.1 release. Many updates and enhancements have been added in 2023.1 and there are also brand-new capabilities, such as production-ready support for Columnar Storage, ability to use Bulk FHIR, and support to MacOS 13 Ventura. Some of these features or improvements may not be available in this current developer preview.

Future preview releases are expected to be updated biweekly and we will add features as they are ready.

Hey Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Real-Life Experiences Migrating a Caché Application Portfolio to InterSystems IRIS @ Global Summit 2022

Such most popular nowadays CI platforms as GitHub and Gitlab, offers the ability to run any docker image as a service, mostly useful for integration tests.

Any ideas on how this can be solved?

I need to use it with some Unicode text, in Docker image. And get this error. And documentation says nothing about it.

USER>do $zf(-100, "/SHELL", "echo", "test")
test

USER>do $zf(-100, "/SHELL", "echo", "test тест")

DO $ZF(-100, "/SHELL", "echo", "test тест")
^
<TRANSLATE>

I know that it works in some Linux environments without Docker, but no idea where is the difference. 

Morning all,

I got access to the new Bing this morning and thought I would try out some things on it. Below are a series of screenshots of what I searched and the results.
Please share your experiences here too.

     Searching for help with arrays:

  A search for a Python related topic:

Has anyone had experience using IRIS as an SFTP endpoint.  We want to use SFTP to receive files from a bank.

Dear community members!

A very common problem of our users is to use an external database as data source in an IRIS production. As many of you already know, we have two ways to connect directly to an external database, the first one is using an ODBC connection, the second is using JDBC.

In our example we are going to create a connection using JDBC, and we are going to build a simple Docker's project, in this way you will be able to modify the example as you wish.

The code is available from this URL: https://github.com/intersystems-ib/workshop-sql-jgw

In our docker-compose.

is it possible to export a specific data lookup table (Ens_Util.LookupTable) directly into Recordmap or Request message class or just a list of strings for me to loop through them?

Trying to find an optimal solution for a high volume interface.

I have a compactJWE that I want to decrypt using a key. I read the key from a .pem file and create a JWK with "RSA-OAEP" algorithm. I have the code below in a routine (.mac) file.

decryptJWE
    #include %msql
    s file = ##class(%Stream.FileBinary).%New()
    s file.Filename = "mycert.pem"
    s rsaKey = file.Read($$$MaxLocalLength)
    zw rsaKey
    s compactJWE = "en.cry.pted.jwe"
    s jwk = ##class(%Net.JSON.JWK).%New()
    s jwkStatus = jwk.Create("RSA-OAEP", rsaKey , .privJWK, .pubJWK)
    zw jwkStatus

    s jwks = ##class(%Net.JSON.JWKS).%New()
    s jwksStatus = jwks.

Hi

I am upgrading our application from dotNet Framework to dotNet Core.

Prior to the upgrade I was able to connect to both my Cache & IRIS instances using the IRIS ADO.NET driver.

However, in dotNet Core, whilst I can connect to IRIS, I get the following error connecting to Cache.

InterSystems IRIS Provider is not compatible with Cache xDBC server
 

I am using the IRIS  driver from the Windows (x86-64) 2022.1 distribution (the one in dev\dotnet\bin\net5.0).

The cache version is Cache for Windows (x86-64) 2018.1.2

Thanks

Hi Team,

Here we have requirement to send json data from on-premises iris to business service in cloud iris namespace. we have firewalls opened.

Could you please suggest any other ways with out using WEB Service (soap or rest) solution?

Thanks,

Prashanth

So I have a base string that I want to sign using RSA-SHA256. I have a .p12 file and passphrase to get the RSA Private key using NodeJS (pem.readPkcs12 library), which I don't know how to do that in intersystems as well. (would appreciate if you can include a solution for that too)
The main problem here is I am trying to sign a string and print the result to terminal, using the code below in a routine (.mac file).

Hi,

I'd like to try out irissqlcli.

My  server, that has IRIS installed on it, is SUSE (SUSE Linux Enterprise Server 15 SP1).

How do install this product from GitHub? Detailed instructions would be great!

It would be best if I can download the software from GitHub and then get pip to install from that downloaded file repo.

With InterSystems IRIS 2022.2, we introduced Columnar Storage as a new option for persisting your IRIS SQL tables that can boost your analytical queries by an order of magnitude. The capability is marked as experimental in 2022.2 and 2022.3, but will "graduate" to a fully supported production capability in the upcoming 2023.1 release. 

The product documentation and this introductory video, already describe the differences between row storage, still the default on IRIS and used throughout our customer base, and columnar table storage and provide high-level guidance on choosing the appropriate storage layout for your use case. In this article, we'll elaborate on this subject and share some recommendations based on industry-practice modelling principles, internal testing, and feedback from Early Access Program participants.