Presenter: Anton Umnikov
Task: Identify your slowest SQL queries and tune them for better performance
Approach: Use InterSystems’ query profiling and analysis tools. Discuss how system configuration can affect performance
 

This session will show you how you identify the weakest link in your application SQL and introduce you to the fine art of tuning those queries. To do this we will take a look at InterSystems query profiling and analysis tools, as well as how system configuration can impact SQL performance.

Problem: Obscurity on how our SQL engine works

Content related to this session, including slides, video and additional learning content can be found here.

Hello,

In Atelier IDE, there is option to import source from XML, how to do this from VS Code?

Thanks

Today we are pleased to publish a new extension pack for Visual Studio Code. This pack provides a convenient way to install and manage a set of extensions which together make VS Code a great tool for ObjectScript developers.

I'm attempting to extract some very large messages from Interoperability/Ensemble, and I'm just not getting something right ...

The closest I've come to getting something useful is this:

ClassMethod GetHL7Msg(pId As %String) As %Stream.TmpCharacter [ SqlName = GetMsg, SqlProc ]
{
    Set tHl7 = ##class(EnsLib.HL7.Message).%OpenId(pId,,.tSC)
    Throw:$$$ISERR(tSC) .GetErr(-400, "HL7 Message with ID "_pId_" Not Found.")
    Set tMsg = ##class(%Stream.TmpCharacter).%New()
    Set tSC = tHl7.OutputToLibraryStream(.

Hi

We have multiple edge production namespaces and want to run query to get errors/alerts from Ens_Util.Log table across namespaces. is it possible?

Hi guys!!

Anyone of you, someday needed to convert a parsed XML (With %XML.TextReader), to a DynamicObject on caché? If anyone can help me, I'm grateful.

Propose sequence and logic in IRIS

• to convert HL7 V2 message to FHIR/CDA * to convert JSON/XML to FHIR/CDA * to convert HL7 SIU message to FHIR/CDA.

Hey Developers,

We have great news for all Portuguese-speaking users of our community!

We're pleased to announce the official start of the InterSystems Developer Community in Portuguese! 🎉

I don't know execute witch one? 

1. I liked the transactional analytic DBMS and Advanced Analytics segmentation concept.
2. The 1.0 version IRIS plug-in to VSCode is amazing. The partnership between community and InterSystems was very positive to it. However a low code option would do very well for IRIS in the near future.
3. The Dynamic Gateways/Native API positions IRIS as the most advanced data platform for the main open languages in the market, but it is necessary use the public package managers from these languages, specially maven public repository.

Prometheus is one of the monitoring systems adapted for collecting time series data.

Its installation and initial configuration are relatively easy. The system has a built-in graphic subsystem called PromDash for visualizing data, but developers recommend using a free third-party product called Grafana. Prometheus can monitor a lot of things (hardware, containers, various DBMS's), but in this article, I would like to take a look at the monitoring of a Caché instance (to be exact, it will be an Ensemble instance, but the metrics will be from Caché). If you are interested – read along.

Keywords: COVID-19, Medical Imaging, Deep Learning, PACS Viewer, and HealthShare.

Purpose

We are all gripped by this unprecedented Covid-19 pandemic. While supporting our customers in battlefields by any means, we also observed various fighting fronts against Covid-19 by leveraging today's AI powers. 

Last year I briefly touched a deep learning demo environment.

Caché  2018.1.4 and Ensemble 2018.1.4 maintenance releases are now available.   

Full product installation kits can be downloaded from the WRC Software Distribution site.

This is a maintenance release with many updates across a wide variety of areas.

For information about the corrections in this release, refer to the Release Changes list and the  Release Notes and Upgrade Checklist.  The documentation for Caché and Ensemble includes these as well as the Supported Platforms document, the Class Reference, and a full set of guides, references, tutorials, and articles.

Hey Developers,

Don't miss the new exciting promo video from our Brazilian developers on InterSystems Developers YouTube:

🍿 Promo video + Screencast for No Project Mess By IRIS

Hi 

Has anyone used Health Connect/Ensemble to receive results directly from POCT devices (Glucose monitors etc)?

I've been looking for information on the POCT01-A  protocol, and as far as I can tell it is a HL7v3 XML schema, I should be able to get results from these devices, though I expect I need a webserver endpoint. (though I can't find any reference in the Health Connect documentation)

Does anyone have any knowledge of this?

KR

Stephen

EDIT:  from the silence I'm wondering if this in normally handed off to specialist middleware?

Hi, I am new to IRIS and We are planning to setup a CI pipeline on AWS VM deploying the iris data platform container. I am trying to find out which folders needs to be inside the source control and where (exact folder) the updated code needs to be pulled in the container. I would be much obliged if anyone cant point the CI CD related documentation.

Thanks,
Raj

Hi Community:

How did Credit Suisse, the VA, and UC Davis advance their digital strategies during the pandemic? Find out on Day 2 of our first-ever InterSystems Virtual Summit. Plus, you’ll hear from our heads of Client Services, Healthcare, and Data Platforms on the ways we’ve adapted, innovated, and built new solutions to help you weather any storm ahead. 

To join us: 

1. Register or log in on the conference platform. You'll land in a virtual lobby. 

2. Click the Keynotes button to enter the virtual auditorium.

3. Then click Day 2 (If you missed the Day 1 keynotes, click Day 1 for replay.

Hi Developers and Interface Engineers!

I'd like to share with you how you can help your organization today obtain a better understanding of key message processing metrics (i.e. average message processing times, number of inbound messages, number of outbound messages, etc.)! Given the embedded IRIS database powering integration, you already have all the data you need -- you just need to put the data to use and present them in a user-friendly format!

This year's Virtual Summit has more content around Analytics and AI than ever before. We've made this quick video to guide you through the program and put things into context with respect to InterSystems overall strategy for Data & Analytics.

Hey Developers, 

Are you joining us for the InterSystems Virtual Summit 2020? 

⚡️ THE REGISTRATION IS NOW OPEN ⚡️

There will be something for everyone at Virtual Summit, whether you’re a tech-savvy executive, a technical manager, a developer or a systems integrator. And this year all sessions are free to attend!

The general theme of the summit is Interaction & Information. And what awaits you at the Summit?

Hi,

I am stuck with simple logic. I have a below string 

set a="<Name>ABC</Name><RollNo>45</RollNo><Name>XYZ</Name><RollNo>66</RollNo><Name>xyz</Name><RollNo>89</RollNo>"

I need logic to replace the values of roll no with "***". Is there any single command which can help in this scanerio.

I need to store this value in database after replace.

Thanks

In this article, we'll talk about an application that I use every day when monitoring applications and integration solutions on the InterSystems IRIS platform and finding errors when they occur.

While looking for a solution for logging object changes in InterSystems IRIS, Ensemble, and Caché DBMS, I came across a great article about logging with macros Inspired by the idea, I forked the project the paper had described and adapted it to some specific needs. The resulting solution is implemented as a panel subclass, %CSP.Util.

Hello every one, 

I am a rookie and i am willing to gain some experience on IRIS for Health by doing some development. 

I went through the website and found only an online development environment. 

But I want to take it a step further ahead bu downloading the software for my own and trying something new. 

But, unfortunately I did not find a link to download the IRIS for Health.

I would be pleased if there is any one who has the link to help me out with it. 

Hoping to hear soon. 

Regards. 

Stay Blessed. 

Stay Safe. God Bless. 

Hi Community!

We're pleased to invite you to the Online meetup with the winners of the InterSystems Full Stack contest!

Date & Time: Friday, October 16, 2020 – 11:00 EDT

What awaits you at this virtual Meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used, bonuses, questions. Plans for the next contests.

Good day! Is there an opportunity to debug the ISCAgent behaviour (in Linux)? ISCAgent uses /etc/iscagent/iscagent.conf as configuration file, but in docs I've found a description only for two parameters (port number and interface - http://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY=GHA_mirror#GHA_mirror_set_agent). Other parameters I can see by running /usr/local/etc/cachesys/ISCAgentCtrl status:

application_server.interface_address=*
application_server.port=2188
daemonized=yes
mirroring=on
pid=41850
running=yes
version=2015.2.0.664.

Hi Community, 

You may know that you get rewarded with points on Global Masters for each your application published on Open Exchange. Recently we introduced bonus points for ZPM applications. So now, you get extra 400 points for each ZPM application! Points are automatically adjusted. 
Check out points & available rewards on Global Masters - and see you there today!

Hello!

First of all, let me state that I am no senior InterSystems expert. 

In my organization, we have a HealthShare Health Connect setup where each namespace has one code database and one data database, which are both actively mirrored. We have two nodes in the mirror.

We had a controlled failover last night to make sure that the backup node works as intended, which it didn't. It turned out that we had only deployed code onto the primary node in several namespaces causing errors with missing classes after the failover.

Hello there community, 

I am pleased to say that i have started building a product and I have chosen InterSystems technology to be used in it. 

But I have a confusion with regard to it. 

I actually have to come to a conclusion to whether to use CACHE or IRIS. 

I will be using a lot of data and also integrating it along with Python for DEEP and Machine Learning. 

Also I do not have an idea of how to get the licensed version of either of that. 

I would like to get hold of this and also would like to try out the free version of either Data Bases before moving on to large scale production.

Hello there friends, 

I am new to DC and I need to advance up my self. 

I see that we get awarded with badges and so on through that process. 

But i do not exactly get the idea of it. 

I see that we have a challenge of becoming the insightful commenter and so on. 

I would like some one to help me out with it so that i could get to the next level. 

Regards. 

Hello there Community, 

I am so pumped and curious about this platform. 

The more I search about it, the more deeper it goes just as the maze. 

I followed the following link  https://community.intersystems.com/post/global-masters-advocate-hub-sta… and  it took me to a page where i learnt more on what Global Masters is and also more about the Advocate Hub. 

But then I came across an very confusing this named as the Global Masters Gamification Platform. 

I was denied permission when i tried to access it. (Screen Shot has been attached.