Syndicate content 0  

Migrating from Oracle, MSSQL, or other purely relational database systems to a multimodel InterSystems IRIS is a strategic decision that requires careful planning and execution. While this transition offers significant benefits, including enhanced performance, scalability, and support for modern architectures, it also comes with challenges. In this article I will highlight some of the considerations connected to coding to ensure a successful migration. I will leave everything connected to an actual migration of structures and data outside the scope of this article.


First, when you're considering migrating to a different database system, you need to understand your business logic, whether it's on the side of the application (application server) or the database server. Basically, where do you have your SQL statements that you will need to potentially rewrite?

6 1
0 130
Question
· Mar 4
Message Count

Looking for a SQL query or any other method to find the Unique/distinct message counts for all productions or at least per production namespace within a given time frame. For e.g TimeCreated = January 2025 (Whole month)

I have used the following, but its not restricting the numbers based on the TimeCreated filter. Every time a new message is processed by system, its added to the total. I am running the query in today's date

Select Sum(MsgCount)

From

(Select DISTINCT TargetConfigName, count(DISTINCT SessionID) as MsgCount

FROM ENS.MessageHeader

1 12
0 138

We have an ObjectScript application that runs in Cache' and IRIS. Our typical installation involves a .zip file containing several files necessary for the installation and operation of the application. Steps are: expand the .zip file to a folder that will not be used by the application. Do ^%RI for the installation routines in the production namespace. Do the Installation routine. We have a customer that is trying to do a silent installation. He does not want to have to respond to any prompts on the installation.

0 3
0 147
Question
· May 9, 2024
Samples-FHIRStarter Questions

I am trying to create my first call to our Epic FHIR Repository from Health Connect using Samples-FHIRStarter now that I have OAuth2.0 connection tested/working with our Epic Interconnect URL.

When I take a patient example from our Epic environment and test it through Data.BPL.PatientRecordCollector within the Namespace, I keep getting a 404 - File or directory not found

0 0
0 150

Hey Community,

Watch this video to get an introduction to the components of an HL7 V2 production in InterSystems products, which works as an integration engine to connect healthcare systems:

Introduction to HL7 V2 Productions

https://www.youtube.com/embed/nT9z9bYx7wo
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 150

Hello,

I begin to work with VSCode and all is ok but i have just one problem with ObjectscriptQuality plugin. I have no feedback in the problem tab using the objectScriptQuality plugin.

I only have feedback from InterSystems Language Server plugin. Where could the problem come from?

My goal is to use objectscriptQyality with the basic rules at first

I work with iris 22.3

1 0
1 150

Hi Developers,

Thank you for spending another great year with us on Global Masters. We hope you enjoy the program!

This is the moment you can share your thoughts about Global Masters. What do you like about it? What you'd like to change?

Time to make your wishes for 2023, because this program is FOR you💫

We will build a roadmap for 2023 based on your answers, and we will continue working hard to make it the best developer gamification program!

➡️ Global Masters Survey 2022 (5 min, 10 questions)

2 1
0 130

Get the latest releases and news from Learning Services with the June newsletter, hot off the presses! This month, read about:

  • Easier copying and linking in InterSystems documentation
  • New videos and podcast episodes
  • Courses updated with InterSystems IRIS for Health info
  • A survey about your cloud usage

....and, as always, much more!

Read more and subscribe to get Learning Services news once a month in your inbox.

0 0
0 150

We have top stories on the right side of the main page.

How CP understands what to put there?

Are there most viewed posts?

Or most commented?

0 0
0 150
Article
· Apr 1 1m read
How to get server/instance info

Hi all,

As part of the development an API to know what is the instance of IRIS is connected, I've found some methods to know information about the server that can help you.

Get the server name: $SYSTEM.INetInfo.LocalHostName()

Get the server IP: $SYSTEM.INetInfo.HostNameToAddr($SYSTEM.INetInfo.LocalHostName())

Get the instance name: $PIECE($SYSTEM,":",2)

2 2
0 109
Question
· Aug 22, 2024
Access to current line text

Is there a general way to set a variable XYZ equal to the text of the code line being executed now? Debugger or production. For example, for a code below if code is currently assigning a to 1, XYZ would be equal "S a=1". The same question about a variable containing current routine name.

S a=1

0 2
0 147

I'm trying to complete Inferno Service Base URL test for FHIR endpoint and I thought it wanted host.com/fhir/r4/.well-known/smart-configuration but I get header error below. Am I using the wrong Service Base URL List or am I missing something? I'm running 2021.2 HealthShare

ERROR <HSFHIRErr>InvalidAcceptSpec: No valid Accept data found (Accept header or _format parameter)
0 2
0 147

Hi,

I'm making a request to an API that works perfectly with Postman, you can see it here:

The URL is https://testcds.esriguide.org/v2/session/3189981 where the last part is the ID's session I want to get back.

When I try to make the same request in IRIS I always get a "Bad request" error.

I'm creating the request which all the information needed (or at least that I know):

1 2
0 147

Hi all,

Some days ago, I've seen a youtuber talking about how to create a neural network (sorry, is in spanish)

https://www.youtube.com/embed/iX_on3VxZzk
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 4
0 145

Anyone here know if the Implementation Partner program is still open, and if so, is there anyone we can contact to get more details? I've tried reaching out via the form on the website, I've called and left a message, and then I called and talked to someone a few weeks ago who said they would "forward my info over", but we still haven't heard back from anyone. We just want to get more info on what it entails, but can't seem to get in touch with anybody to talk about it.

1 1
0 148

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

How to Migrate a Mirror Configuration to Apache - Linux Unix

https://www.youtube.com/embed/Yqd-o1_uljc
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 149

Hi Community,

Watch this video to see how to configure production component settings in InterSystems products to process HL7 V2 files:

Configuring a Production to Consume HL7 V2 Messages

https://www.youtube.com/embed/F01bUO9Hsa0
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 149

Hi,

I'm having a few issues with keeping Ubuntu happy and stable, and it seems to be something at the OS level rather than within IRIS itself. My thought is to simply pare back the stuff that Ubuntu LTS runs by default, which will free up system resources (which really shouldn't be a problem, but it might help) and reduce the amount that can go wrong.

Are there any guides as to what can be safely disabled at boot time, or are required to be enabled?

0 1
0 148