#InterSystems IRIS

Hi,

I recently needed to setup an SSL/TLS configuration in IRIS that supported mutual authentication (where the server IRIS is establish a connection to is verified, and, where IRIS is in turn verified by the remote host).  After a bit of research and getting it done, I thought it worthwhile to just go over the process I went through in order to potential help others, and save you some time .

I had in hand, Certificate and Private key for my IRIS instance, that was initiating the connection, and needed to ensure that this was setup correctly.

Hi folks!

Is there any templating engine for ObjectScript similar to Jinja?
Or is there any way to use csp's built-in tools to do this?

Ideally, I want to input the template and data into the function and get the ready to use html in the output.

Hello, are there any alternative choices for creating forms with a different tool and then integrating them with Intersystems? I want to use Angular to construct forms and integrate the code with Intersystems. Is there anyone out there who might have an idea?

Pouring The Coffee: Creating and scheduling a task

Don't you wish a fresh, hot cup of coffee could be waiting for you right when you get into the office? Let's automate that!

Cache and IRIS come with a built-in Task Manager, which should have a familiar feel to those used to using the Windows task scheduler or using cron on Linux. Your user account will need access to the %Admin_Task resource to use it, and you can access it in the management portal under System Operation -> Task Manager. When first installed, there are roughly 20 types of task that you can schedule.

Running HealthConnect 2021.1 on RedHat Linux 8.4.

I've configured IRIS/HealthConnect with an external web server to support TLS encryption. It's installed on the same server as IRIS, but is a different instance and version of Apache httpd. That all works as expected.

I would also like to keep the "private" web server available, but I'm having an issue with using the fully-qualified domain name in the URL vs. just the hostname itself.

If I use http://servername:52773/csp/sys/UtilHome.csp to log on, all is well.

If I use http://servername.domain.name.tld:52773/csp/sys/UtilHome.

November 19, 2021 - Advisory: Apache Web Server provided with InterSystems kits – Vulnerability reports

InterSystems kits include an Apache web server, which provides a convenient way for customers to interact with the Caché/IRIS Management Portal without needing to install an external web server; however, this web server should never be used for production instances, and customers must install a web server that fits their specific needs and security/risk requirements.

Recent tests have noted some security issues with the currently included Apache web server.

I want to switch between different DSNs in business operations to query different servers, but the DO ..Adapter.DSNSet("DSNName") code will report a 15-second connection timeout error when switching DSNs. What should I do?

Hey Community, 

New video is already waiting on InterSystems Developers YouTube: 

⏯ Nora, A Virtual Assistant for Clinicians: Innovation with Microsoft Teams & Northwell Health 

At the recent virtual conference I saw the demonstration on being able to run Python within ObjectScript and run ObjectScript within Python thanks to a feature called Language Bridge.  Is this available now? If so, am I able to install it?  I am currently running HealthShare 2020.1.  I have a little bit of experience using Irisnative with Python but was intrigued with the more seamless-looking features offered by the Language Bridge.

Thanks for any insight.

Marlin Mixon

I'd like to bring your attention to my two Virtual Summit sessions, even though they're not HALF as cool as Embedded Python.

Git & GitLab for Shared Development Environments details the newly-released git-source-control package (see also on the Open Exchange) which provides a new best-of-breed solution for server-side IRIS/Git integration, especially for shared remote development environments. (I need to write up a post about this package specifically and plan to do so soon.

I have just created a new Global Master Topic, "IRIS Cheatsheets". IRIS has introduced a lot of new functionality, especially in scripting languages, FHIR R4 support, enhanced Interoperability Tools, and IRIS Analytics. Having spent 35 years working on Windows-based PC's and Laptops, I have surprisingly little knowledge of Linux, Docker and Git. Furthermore, I have written almost every application and Interface in ObjectScript with splatterings of SQL, .Net, and Java Gateways and the most basic knowledge of WinSCP, Putty, SSH. All that changed when I received my first Raspberry Pi.

Hi All,

I'm having a strange issue where doing a .setValue on a ZEN datacombo is updating it with the value as-is, not the corresponding display value. Eg, if I connected it to query that returns two columns: ID,Name, and do a setValue(ID), I would expect the text in the datacombo to update showing Name. Instead it updates show ID, which I only want to use internally.

However, if I click on the dropdown, showing all the valid Names, select one, it works fine, showing Name (with the ID retrievable by getValue() as normal).

In my previous articles I demonstrated the steps to connect, retrieve and save data to Caché from Appeon PowerBuilder by using ODBC.
In this article I will demonstrated how to Delete data from Caché with Appeon PowerBuilder (https://www.appeon.com/products/powerbuilder) by using ODBC 

I am using Company.cls from Samples-Data (https://github.com/intersystems/Samples-Data/tree/master/cls/Sample) 

So Let's start:
 

Step 1 : First of all we need to establish a connection (https://community.intersystems.

Hi Developers!

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

• Basic Authentication usage - 2
• Bearer/JWT Authentication usage - 3
• OAuth 2.0 usage - 5
• Authorization components usage - 2
• Auditing usage - 2
• Data Encryption usage - 2
• Docker container usage - 2 
• ZPM Package deployment - 2
• Online Demo - 2
• Code Quality pass - 1
• Article on Developer Community - 2
• Video on YouTube - 3

See the details below.

Working in support, I usually get asked how many days I should keep journals. Should it be two days or after two backups? More? Less? Why two?

The correct answer (for most of the environments) is that you should keep the journals since the last validated Backup. I.e., until you don't check if a Backup is valid (restoring the file and checking with the Integrity utility), you can't be sure there is a good copy of your data and can't purge the journals safely.

For example, imagine you need to restore your system after a hardware failure that corrupted some databases.

Hi Community,

We are pleased to invite all the developers to the upcoming InterSystems Security Contest Kick-off Webinar! The topic of this webinar is dedicated to the Security contest.

We’ll discuss the aspects of Security Model implementation in InterSystems IRIS, the requirements, and what do we expect from participants of the Security contest. Also, we’ll answer all the questions related to the contest!

Date & Time: Monday, November 15 — 12:00 AM EDT

Speakers:  
🗣 @Andreas Dieckow, Principal Product Manager at InterSystems Corporation
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

InterSystems technologies are renowned for their high performing databases, which support the systems and operations of many organisations. However a key ingredient to this success is the quality and maintainability of their code. 

The quality of code can impact everything from speed and ease of fixing bugs and making enhancements, to the overall performance of your organization and your ability to get ahead in the marketplace. 

By ensuring your code is maintainable, you can reduce approximately 75% of the systems life cycle costs*. This is why, at George James Software, the solutions we build are always straightforward and written in high quality code - because we know that this solid foundation can positively impact the rest of your organization. 

With a maintainable system you're able to reduce your overall maintenance as any issues that occur are significantly faster to identify and fix. This means you're free to allocate that time and budget to enhancements, enabling you to get the most value out of your applications and ultimately better support your organization. 

Keep an eye out for our next few posts about what a maintainable system looks like and the tools that can help you keep your code maintainable, in order to help you to reduce those maintenance costs.  

Hi Guys

I'm rather new to HealthConnect, and I've been doing a lot of work with the browser based SQL portal and don't particularly like it. Is there an alternative application that I can use, something like SQL Express or VScode with a plugin?

Andy

I'm trying to send a POST request to my REST API and I'm getting this error and most likely due the lack of experience, I have no idea how to fix this issue:  

"error": "ERROR #9406: Unexpected format for value of field, AlertText, using class base mapping",

            "id": "JSONImportError",

            "params": [

                "AlertText",

                "class base"

            ]

Am I missing something from my string definition?

Defined below as:

Class User.RESTComponents Extends (%Persistent, %JSON.

Hey Community, 

The new video is worth watching on InterSystems Developers YouTube:

⏯ Data Warehousing with InterSystems 

The TOGAF is the The Open Group Architecture Framework. It provides an approach for planning, design, implement, deploy and govern your EA (Enterprise Architecture) projects.

The TOGAF has a concept called Building Block. It is any element that can be used, reused a executed to deliver value and new functions to the business.

In the picture above, I present to you the main IRIS building blocks to create fantastic apps.

To learn more about TOGAF and building blocks, see https://www.opengroup.org/togaf.

I'm in a tricky situation where a new required property is being added to a class, along with an index on it. The existing data has nulls, so the index build fails. I can't run a query to update the rows where there are nulls, because it tries to use the index, which hasn't been built yet.

I realize that a valid workaround would be to remove the index, add the property, run the query to do the update, then re-add the index, but this feels overly messy (and doesn't fit well with my logic for incremental deployment).

Hey Developers, 

We invite you to take part in the European Healthcare Hackathon 2021 which will take place on November 19-21 2021. Participation is free, the deadline for applications to the ON-LINE track is prolonged until 15 NOV.

We will have an InterSystems challenge there: "Innovate with FHIR". Prize fund in InterSystems track:

🥇1st place: 1500 EUR
🥈2nd place: 1000 EUR
🥉3rd place: 500 EUR
And we prepared prizes for ALL participants of our challenge!
Read the details about our challenge under the pic :) Are you in? Let us know in the poll below!

Any suggestion that can make programming with Studio easier and smarter is welcome.

Hi folks!

Could you please share your experience on how do you create REST API with InterSystems IRIS that uses bearer authentication?

How do you generate tokens? How do you maintain it (how much time tokens exist?).

Thanks in advance!

Ladies and gentlemen!

Is there a way (some secret call? ) to turn on a debug mode for a particular IRIS web app?

The reason is to log debug information in REST-API dispatch methods if the app is in debug mode.

Of course, I could use "a global", but if there is any standard way?

Hello,

We are connecting to our client's Intersys database with python3.8 on our Ubuntu 20.04.2 LTS, we are having trouble gettin the intersys.pythonbind module to work.

We are able to install the intersystems_irispython-3.2.0-py3-none-any.whl but, when we try to run the code we always get:

Traceback (most recent call last):

  File "./get_well_life.py", line 4, in <module>

    import intersys.pythonbind

ModuleNotFoundError: No module named 'intersys'

Please could you tell us what may be going wrong?

Please also feel free to ask for any additional infomation.

Thanks and regards!

Hi folks!

Consider you are logged in to a REST API in InterSystems IRIS with user A.

What is the way to log out in a browser?

E.g. to login with another user B?

Hi Community,

We're pleased to invite you to the online meetup with the winners of the InterSystems Interoperability contest!

Date & Time: Friday, October 29, 2021 – 12:00 EDT

What awaits you at this virtual meetup? 

• Our winners' bios.
• Short demos on their applications.
• An open discussion about technologies being used. Q&A. Plans for the next contests.