Hi Community!

Watch a demonstration of Production Extension Framework (PEX) in InterSystems IRIS that uses a Kafka integration as an example:

⏯ PEX: Production Extension Framework Demo

Those of you who are following the FullStack competition here in the Developer Community will know that I submitted an entry named qewd-conduit.  I wanted to summarise why I think it's something worth you taking a bit of time to check out.

qewd-conduit uses the Node.js-based QEWD framework alongside IRIS to implement the back-end REST APIs for something known as the RealWorld Conduit application:

https://github.

One of the most useful features in Studio is code snippets.

Here's how to add snippets to VSCode.

Here's a generalized instructions.

1. Go to File - Preferences - User Snippets and choose objectscript.

2. Add your snippet, here's an example:

"SQL Statement": {
    "prefix": ["sql"],
    "body": ["#dim rs As %SQL.ISelectResult",
            "set rs = ##class(%SQL.Statement).%ExecDirect(,\"SELECT * FROM\")",
            "while rs.%Next() {",
            "\twrite rs.ID, !

Get all the info you need about Experience Labs, Personal Training, free certification exams, and more! 

Check out this month's Learning News newsletter, and subscribe to receive the newsletter in your inbox each month.

We've just finished the second day of focus sessions - with a LOT of great content!  With parallel tracks, it's hard to keep up - but one advantage of a virtual conference is that you can watch anything you missed on-demand!

In yesterday's blog (Highlights of Day 1), I covered most of the special announcements such as InterSystems IRIS Adaptive Analytics and the FHIR Accelerator Service, so time to turn to a few broader strategic themes today.

Hi All,

I'm being asked if I can set up a AWS EC2 containerised version of IRIS and a separate AWS EC2 installation of Apache to serve IRIS web files.

Creating the Apache EC2 and containerised IRIS EC2 is the simple bit but getting them both to talk to each other does not seem quite so simple and I cannot find any documentation to describe how this can be achieved.

Has anyone else managed to achieve this?

I am trying to configure IRIS using python. The first task I wanted to do it change the journal directory. I cannot figure out the right way to work with the Config.Journal class with python. I can get the text to query the current setting.

returnValue = dbnative.classMethodValue("Config.Journal","GetList")
print(returnValue )

But I don't see a straightforward way to parse the $List returned by GetList() I was hoping there was an easier way.

How do I

1. Query configuration parameters?

2. Set configuration parameters?

Using python?

Hello Everyone,

We are working on growing the InterSystems Certification program, and would like to gather some input from the community.

Please participate in this brief 6-minute survey to share your thoughts with us regarding the new certification exams we have planned and other program improvements that we are considering.

https://www.surveymonkey.com/r/2ZVHNPS
 

Thanks for your help!

Hi,

We are wondering how to create translation profile for HL7 to SDA in "HEALTH SHARE". can you please help us with the class definition containing the mapping for that(so that we can import directly and understand the mapping).

Thanks,

Sam

Hi Community,

Please welcome the new video recorded by @Robert Cemper on InterSystems Developers YouTube:

⏯ ZPMshow Demo

The second week of Virtual Summit 2020 kicked off with the first day of focus sessions. We covered a LOT of great content - 38 sessions across a wide range of subjects. I thought it would be valuable to recap and review some of the bigger announcements and talking points.

 IntegratedML  Following the announcement of global availability for IntegratedML, this week highlights IntegratedML in multiple sessions.

$LIST string format and %DynamicArray and %DynamicObject classes

IRIS, and previously Cache, contain several different ways to create a sequence containing a mixture of data values.  A data sequence that has been available for many years is the $LIST string.  Another more recent data sequence is the %DynamicArray class, which along with the %DynamicObject class, is part of the IRIS support for JSON string representation.  These two sequences involve very different tradeoffs.

Newbie Warning...

I have a DTL which accepts HL7 2.3:ORU_R01 And Transforms to Custom Request Target

the target request contains  an array of a custom class named OBXobj with some %string properties which  Extends (%RegisteredObject, %XML.Adaptor)

in the DTL i have a for each loop which should copy OBX segments to the the request.

the DTL test tools works and builds a XML with the OBX info.

when running the Production i get NULL in the Object.

see attached images

1. Test

2. Message sent.

3. Transformation

Whats my problem?

Thanks!

Hi Developers,

If you are planning to attend the Focus Sessions of InterSystems Virtual Summit 2020, please do not miss the session dedicated to InterSystems Developer Community and Open Exchange!

⚡️ "Developer Ecosystem: Developer Community forum and Open Exchange applications gallery" session ⚡️

Speakers: 
🗣 @Anastasia Dyubaylo, Community Manager, InterSystems 
🗣 @Evgeny Shvarov, Startups and Community Manager, InterSystems 

What awaits you?

Hey Community,

We're pleased to invite you all to the Virtual Summit 2020 session dedicated to InterSystems online programming contests, best winning projects, and their developers! Please join:

⚡️ "Best applications of InterSystems programming contest series: Best IntegratedML, FHIR, REST API, Native API, ObjectScript solutions" session ⚡️

Please check the details below.

Now that 1.0 has shipped and is featuring in various sessions at Virtual Summit 2020 it seems like a good time to offer some guidance on how to report problems.

InterSystems ObjectScript for VS Code consists of three collaborating VS Code extensions. For ease of installation and management there's a fourth entity, the InterSystems ObjectScript Extension Pack. It's a great way to get started with minimum clicks, and handy to have even if you have already installed the other extensions.

This modular architecture also means there are three different GitHub repositories where issues can be created.

Hi Community,

At this year's Virtual Summit, we have 100+ Live Focus Sessions on Best Practices, New Technology & Roadmaps. 

Also, you have a great opportunity to submit your questions for Live Q&A Sessions with InterSystems Product Managers on October 27-29, 2020!

To join Live Q&A: 

Hey, 

I have a value in epoch time in which I need convert in order to be able to lookup a table that has dates in YYYY-MM-DD HH:MM:SS format

I thought the below would work but it is not.

select COUNT ('Arrival Time') FROM dbo.table where 'Arrival Time' < DATEADD(ms, CONVERT(int,LEFT(1603173432000, 20)), '1970-01-01 00:00:00')

The first full release of our iKnow open-source NLP library is now available on GitHub and PyPI! 

The iKnow engine has been available as an InterSystems embedded technology for almost 10 years and the core engine was published to open source earlier this year. Now, in the slipstream of Virtual Summit 2020, we're glad to announce the availability of v1.0, which adds all-Python access to the core engine, documentation and samples on the language model contents and a Jupyter demo notebook to get you started.

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.