IRIS is an excellent option for machine learning projects with massive data operation scenarios, because the following reasons:

1. Supports the use of shards to scale the data repository, just like MongoDB.
2. Supports the creation of analytical cubes, this in association with sharding allows to have volume with performance.
3. Supports collecting data on a scheduled basis or in real time with a variety of data adapter options.
4. It allows to automate the entire deduplication process using logic in Python or ObjectScript.
5. Allows you to orchestrate and automate the flow of data to the reposi

Class Queries in InterSystems IRIS (and Cache, Ensemble, HealthShare) is a useful tool that separates SQL queries from Object Script code. Basically, it works like this: suppose that you want to use the same SQL query with different arguments in several different places.In this case you can avoid code duplication by declaring the query body as a class query and then calling this query by name. This approach is also convenient for custom queries, in which the task of obtaining the next row is defined by a developer. Sounds interesting? Then read on!

Hi Developers!

Here're the technology bonuses for the InterSystems Interoperability Contest that will give you extra points in the voting:

• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter Usage
• Production EXtension(PEX) Java or .NET usage
• Workflow Engine usage
• ZPM Package deployment
• Docker container usage

See the details below.

Hi,

         Can anyone please recommend an editor for cache database. I am looking for free version.

I am using winsql free version but data is missing while extracting or copying data from winsql.

Thanks

Jude

It's a wrap!    All of the focus sessions have aired now.  Of course, all of our 102 pre-recorded focus sessions are available on-demand now, so you can watch any and all of them, even if you missed the opportunity for live Q&A.

Speaking of live Q&A - we've had 6 live sessions, and these too are available for you to watch.  I wrote about this, and how your questions make us better, in a separate blog article. 

Smart Factory Starter Pack   One highlight that got a lot of attention today was the release of the InterSystems IRIS Smart Factory Starter Pack on OpenExchange.  Our partner ITVis

Hello,

I have a csp that occasionally will show Timeout error.

I am looking at the SQL Statements tab of the SQL Explorer:

The Average time is around 1.4, what would cause the CSP page to timeout if the query average time is 1.4 while the CSPGateway Server Response Timeout and Queued Request Timeout are default to 60 seconds? Does sql query from CSP that causes web pages to timeout get logged into SQL Statements ?

Thanks

Hi All,

Can you please guide me on how to restore the .cbk file from the 2015 Cache version into the 2017 version or any other versions of Cache or IRIS software? I have a new instance on my server. It's an entirely new server. I have a .cbk backup file.  I want to restore the backup file into a new namespace which one I will create on my new server.  When I am trying on ^DBREST utility, I am getting "This is not a Cache Backup File" this error. 

Please advise on this. It's a bit urgent.

Thanks,

Arun Kumar. 

Hey Developers,

We remind you about a great opportunity to make a live conversation with InterSystems Product Managers Team on Live Q&A Sessions at Virtual Summit 2020! 

🗓 TODAY at 12:40 PM EDT at https://intersystems.6connex.com/event/virtual-summit/en-us/contents/43…

And now we've added more options to make it even easier for you to ask questions upfront:

✅ Submit your questions in the comments to this post

✅ Submit your question to our Discord Channel: discord.gg/WqVjtD

✅ Submit your questions to VS2020questions@InterSystems.com

✅ Send your question personally to @Anastasia Dyubaylo or @Evgeny Shvarov in Direct Messages on the community

✅ Submit your question to Q&A Chat on the conference platform during the session 

Note: We will pass all your questions to the PM team, and you'll receive answers during the Live Q&A Sessions.

I've been impressed at the quality of the questions at our live Q&A sessions!  

These sessions were meant as a way for you to ask anything you want (I call this playing "stump the chumps").

They're all recorded and available for review later; here're the links:

• Live Q&A session 1 - 26 Oct 11:40PM EST 
• Live Q&A session 2 - 27 Oct 12:40PM EST 
• Live Q&A session 3 - 27 Oct 11:40PM EST  
• Live Q&A session 4 - 28 Oct 12:40PM EST  
• Live Q&A session 5 - 28 Oct 11:40PM EST 

It's not too late to join the last one live! 

• Live Q&A session 6 - 29 Oct 12:40PM EST 

Your questions are re

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.com/gothinkster/realworld

This is a very cool initiative as it provides a platform for lots of different people to implement technically different solutions for both the back- and fr

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, !",
            "}"]
}

In here:

• prefix - what you need to type for the snippet to appear
• body - snippet body

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 subscribeto 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.

Operations and System Management:   We're seeing more and more customers running in the cloud, as well as people that are employing modern deployment

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. Today Thomas Dyar spoke with Joe Cofone, a business analyst for Population Health initiatives at Baystate Health, about how InterSystems and Baystate have set up a "machine learning sandb

$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.

$LIST String Format

$LIST format was invented some time ago when memory address spaces were small and when disk drive

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 creat

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. The technology continues to be available as part of IRIS for embedded use under the name

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.