#InterSystems IRIS

Hey Developers,

The InterSystems FHIR Accelerator contest is over. And now it's time to announce the winners! 

Are you excited?

A storm of applause goes to these developers and their applications:

I'm probably missing something really basic here -

• I spun up a copy of the Iris community edition AMI.  
• Added Objectscript extension to vscode
• Added objectscript extension pack to vscode
• Added server manager to vscode
• Connected to iris AWS instance using PuTTY
• Changed password
• in vscode, I used server tool to add the server

It seems to connect OK; I can see the %SYS and USER namespaces.  I clicked the "edit code in namespace" button and created a bit of hello world code.  However, when I try to save it, I get "failed to save file 'filename.mac' on the server."
I can connect via a b

Is there a way to add/substract from a pivot variable?

I have this MDX:

SELECT
  NON EMPTY [DateOfSale].[Actual].[YearSold].&[$variable.Year] ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HOLEFOODS]

And with pivot variable Year equal to, say, 2016 it works:

Now I want to add previous year  first with one pivot variable and one explicit reference. It also works:

SELECT
  NON EMPTY
  {
    [DateOfSale].[Actual].[YearSold].&[$variable.Year],
    [DateOfSale].[Actual].[YearSold].&[2015]
  } ON 0,
  NON EMPTY [Product].[P1].[Product Name].Members ON 1
FROM [HO

In this article, I will show how you can easily containerize  .Net/Java Gateways.

For our example, we will develop an Integration with Apache Kafka.

And to interoperate with Java/.Net code we will use PEX .

Architecture

Our solution will run completely in docker and look like this:

Java Gateway

First of all, let's develop Java Operation to send messages into Kafka. The code can be written in your IDE of choice and it can look like this.

In short:

• To develop new PEX Business Operation we need to implement  abstract com.intersystems.enslib.pex.BusinessOperation class
• Public

Episode 19 of Data Points features a conversation with Benjamin De Boe about the 2021.1 release of InterSystems IRIS! The conversation covers new improvements in analytics, business intelligence, machine learning, development gateways, FHIR capability, and more.

This time I want to talk about something not specific to InterSystems IRIS, but that I think is important if you want to work with Docker and your server at work is a PC or laptop with Windows 10 Pro or Enterprise.

As you likely know, containers technology comes basically from Linux world and, nowadays, is on Linux hosts were it shows maximum potential. Those who use Windows on a normal basis see that both, Microsoft and Docker, have done important efforts during these last years that allow us to run containers based on Linux images on our Windows system in a really easy way... but it's something not supported for production systems and, this is the big problem, is not reliable if we want to keep persistent data outside of containers, in the host system,... mostly due to the big differences between Windows and Linux file systems. In the end, Docker for Windows itself uses a small linux virtual machine (MobiLinux) to run the containers... it does it transparently for the windows user... and it works perfectly well if, as I said, you don't require that your databases survive longer than the container...

Well,...let's get to the point,... the point is that many times, to avoid issues and simplify, we need a full Linux system and, if our server is based on Windows, the only way of having it is through a virtual machine. At least till WSL2 in Windows is released, but that will be another story and sure it'll take a bit of time to become robust enough.

In this article, I'll tell you, step by step, how to install an environment where you'll be able to work, if you need it, with Docker containers on an Ubuntu system in your Windows server. Let's go...

Hi guys,

How can we remove a business host from a running production?

I've read and tested how to add it to a production, while when I try to remove it from the production with the following codes:

Set tSC = $$$OK
    Set prodName = "CDRDemo.DemoProduction"
    Set confName = "TEST1"
    Set className = "Demo.LISClient.Operation.PatientOperation"
    #Dim prodConf As Ens.Config.Production = ##class(Ens.Config.Production).%OpenId(prodName)
    Set itemId = ""
    &SQL(Select ID into :itemId from Ens_Config.Item
        where Production=:prodName
        and ClassName=:classNa

Hello,

We have a need to track Database changes over time - down to the SQL level of granularity if possible. Such as: User xyz runs routine ^abc and we get something similar to a changelog that tells us: table A had this value updated, insert, update etc....

Is that possible using IRIS level tools (Audit Log, Journal File, etc...) , is there a way to convert the global sets and kills from the journals into SQL level changes?

I also found a third-party java-based tool named Liquibase , but it seems more oriented to tracking schema and table based changes or pre-defined definitions.

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Getting Started with IntegratedML

Hi community, 

I am in the process of building a React Native Application for a restaurant. 

I am not quite sure if we can use IRIS as the main database for this and if there is a possibility I am not quite sure how to do it. 

If there is a possibility could some one help me out with it please? 

Or do you think using AWS is a better choice?  

Please let me know your ideas and guidelines in the comments or please feel free to reach out to me directly. 

Hoping to hear soon. 

Regards.

All source code to the article is available at: https://github.com/antonum/ha-iris-k8s 

In the previous article, we discussed how to set up IRIS on k8s cluster with high availability, based on the distributed storage, instead of traditional mirroring. As an example, that article used the Azure AKS cluster. In this one, we'll continue to explore highly available configurations on k8s. This time, based on Amazon EKS (AWS managed Kubernetes service) and would include an option for doing database backup and restore, based on Kubernetes Snapshot.

Installation

Let's get right to business. Fir

when i connect to DB via DBeaver , it always report Connection refused, i tried both Cache and IRIS but same error, I have already download intersystems-jdbc-3.2.0.jar as IRIS Driver.

And meanwhile SqlDBx tool is able to connect via internal Intersystems Cache Driver.

Hi Developers,

Watch the execution of a speed test for a heavy-ingestion use case on InterSystems IRIS:

⏯ InterSystems IRIS Speed Test: High-Volume Ingestion

Hi all,

I'm looking for a user-friendly way to make a method library available in DTL, and by user-friendly I mean via '..MyMethod()' or '$$$MyMacro()' rather than  '##class(MyPackage.MyClassName).MyMethod()'.

Does anybody know of a way to add a second superclass or a set of macros to a DTL ... or some other trick?

Cheers,

Otto

Hi colleagues!

Often when we collaborate to someone's repo in GitHub we do the following cycle:

Fork-Clone-Change-Commit-Push-Pull-Request-Merge to the original repo.

This is all great and works fine!

And if we want to make a second collaboration right after the merge you need to perform "Fetch upstream" to your forked repo first to "ingest" your own Pull-request in the original repo.

Geeky git-professionals do it with ease but this was always a headache for me so I usually simply deleted the fork and created a new one.

And today I figured that Github added a new UI feature that I can easily fetch-upstream for my fork with the original one and make it up to date and capable for pull-requests.

Here is where the button is:

This is a relief! )

Wanted to share this relief and productivity tip with you!

Bring more collaborations to Github repos!

And speaking of PR - I just made a PR with docker to Google Cloud Run deployment for the FHIRaaS demo made by @Anton Umnikov for the current FHIR Contest! Looking for more of your contributions!

Hello,

I'm quite new at InterSystems. I have a business process that's pointing two different business operations, but one of them I don't want it to point to.

I went through the FileSystem settings, data transformations, classes, and code to see what it could be, but I don't see why its connecting to this second operation. 

What other inner-system mechanics would I need to consider? What have might I have missed? 

Hello community, 

I am in the process of building a Health Care Application named MediCloud and I was so excited to see that IRIS is one of a great choice that I can make for a database system. 

But, I am developing my system with ASP.NET Core Version 2.1. I did see that there is a way we could use .NET with IRIS using PEX (such a useful tip), is there a possibility I could do it ASP.NET Core as well.   

Or is it just limited to .Net for the time being? 

Cheers. 

Hello all, 

I am in a bit of a situation where I could get your help please. 

I want to get certified with IRIS, but I also do see that there is an availability named Cache. 

Are they both the same or different? if different please explain it to me as how? 

Also what is the difference between IRIS, IRIS for Health, Deep Sea? Please explain to me.

Also what do you think I should get my self certified with? 

Please leave your comments below. 

Cheers. 

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Cloud Backup Strategies

for debugging purposes of complex applications.

I have run into two annoyances when using VS Code for server-side editing of Objectscript and was wondering if anyone knows of any solutions or workarounds.

1. In .mac routine files, class names that aren't fully qualified (e.g. ##class(example) instead of ##class(Package.example)) fail to be understood, so the class will have a red squiggly underneath it and a problem that reads

"Class 'example' does not exist. InterSystems Language Server".

In an old routine full of unqualified class names, it just fills the problems tab and drowns out the actual issues. Of course, one solution would

I cannot convert the R4 version of the JSON file through the built-in dtl, and convert it to SDA, I hope to get an answer, thank you very much

Hi Developers!  Let me share with you some exercises from a workshop about developing interoperability components in Java using PEX (Production EXtension).

You will find slides and step by step exercises about:

• Understanding simple PEX components coded in Java.
• Making some changes on them.

All built using containers, so you don't need to build a local Java environment.

You can reach the repository here: https://openexchange.intersystems.com/package/workshop-pex

It's a challenge when you need, as a software architect, design a corporate architecture to meet the current business requirements, you need achieve level 5. With InterSystems IRIS.
it's possible. With 1 product you get SQL + NoSQL + ESB + BI + Open Analytics + Real time virtual cubes + NLP + AutoML + ML (with Python) and Advanced cloud + Sharding support.

With Oracle, for example, you need Oracle DB + Oracle NoSQL + Oracle BI + Oracle SOA Suite + Some Oracle add-ons like Oracle R, Partitioning and RAC and some Oracle cloud products to NLP and AI features. For IBM we have a similar scenario.

Hello,

I am trying to use the ./irisstart command in Red Hat, but it returns an error "Invalid registry ownership". The same error appears when i try ./irisstop and ./irisforce

Has anyone seen these before?

Hey I am very new to Intersystems Objectscript and I am trying to find a way of extract 4 digit numbers from a stream.

I have a stream full of results 

2334

3434

5543

4334

And I am trying to remove each 4 digit grouping from the stream.

I have tried the following for loop 

for i=1:1:$length(result) {

set curr = $extract(result, i)

write !, curr

set count(curr) = $get(count(curr)) + 1

}

Unfortunately the loop extracts one digit.

Does anyone have any suggestions on how to solve this ?

 I'm trying to set up VS Code for ObjectScript using the instructions found here. I've got both Cache 2018.1.2.309.0 and IRIS 2020.1.0.215.0. When I try to connect to either one of them the connection fails, and I get a notification in the bottom right corner that says "Unexpected token < in JSON at position 0". I've checked the JSON settings file that VS Code uses, and they're fine and formatted properly. All of the settings I've entered are correct. I suspect that there's a response coming back from the server that VS Code is expecting to be JSON, but isn't. It pops up any time I click on an

At the heart of IRIS and Cache is a very interesting database architecture that we, at M/Gateway Developments, refer to as "Global Storage".  If you ever wanted to know more about the fundamentals and capabilities of this underlying database, you might want to read a major analysis we've put together:

https://github.com/robtweed/global_storage

Amongst other things you'll discover that:

- Global Storage provides the underpinnings of a full multi-model database, something we refer to as "Universal NoSQL", though, as you already know from IRIS and Cache, it also supports relational too.

- Glo

Hello,

I was wondering if InterSystems has support for the following standards built into IRIS or Health Connect / Ensemble:

1.        Healthcare FHIR(Fast Healthcare Interoperability Resource) Protocol

2.        Enterprise Resource Planning OAGIS (Open Applications Group Integration Specification) Protocol / Supply Chain Management GS1-EPCIS (Electronic Product Code Information Services)

3.        Education, Certification, Credentials FERPA CEDS (Common Education Data Standards) Protocol

4.        Open Banking PSD2 /SWIFT (Payments Services Directive/Society for Worldwide Interbank Finan

What is Data Fabric?

“It is a set of hardware infrastructure, software, tools and resources to implement, administer, manage and execute data operations in the company, including, acquisition, transformation, storage, distribution, integration, replication, availability, security, protection , disaster recovery, presentation, analysis, preservation, retention, backup, recovery, archiving, recall, deletion, monitoring and capacity planning, across all data storage platforms and enabling application use to meet the company's data needs company". (Alan McSweeney)

The Data Fabric is a new way