Need to fetch data from SQL server management studio to ensemble, using jdbc or ODBC. 

Step by step solution would be highly appreciated. 

Updated guide 👇

>> How to get InterSystems IRIS Community Edition

IRIS Community Edition Installation Process.

Hello there developers,

As a new amateur to the Developer Community, I had a few hurdles that I had to cross in order to find a way and install the IRIS for Community Edition.

The Developer Community has been very helpful in guiding me thought this process, and which has made me write this post today. 

I believe that this will be helpful for any armature on the Developer Community trying to get hands on experience with IRIS.

Steps to be followed.

Step 1

Become a member of the

InterSystems FAQ rubric

To remove InterSystems products installed on your Windows system, use Add or Remove Programs in Control Panel (in Windows 10, select Apps from Windows Settings).

Since we will be making changes to the system, you will need to log in as a user with administrator privileges.

1) Log in to the system as an administrator.

2) From the system tray, exit the launcher of the InterSystems product instance you want to uninstall (click launcher → exit).

3) Add or Remove Programs in the Control Panel (for Windows 10, select Apps from Windows Settings)

Delete <InterSystems product>

Our 3M Computer Assisted Coding system goes down on a regular basis for updates, the Applications folks like us to Disable the Business Operations when this happens and start them back up when they page the on-call person. The Business Operations have to be started in a sequence to guarantee that all the ADT being sent it processed before we start sending everything else.

Of course, I am looking for a way to automate this process, and before I go down writing a function to EnableConfigItem, then a for loop to check the ADT queue count, before enabling the other BO's, I was wondering if someone

Hello everyone, could you please advise me on how to solve this error :
ERROR #6085: Unable to write to socket with SSL/TLS configuration 'HTTPSCert', error reported 'SSL/TLS error in SSL_connect(), SSL_ERROR_SSL: protocol error, error:1408F10B:SSL routines:ssl3_get_record:wrong version number' + ERROR #6034: SMTP server connection failed during init command: <READ>GetResponse+5^%Net.SMTP.1.
my SSL config : 

The %CSP.Login class is the utility class provided by InterSystems IRIS to do custom login pages.If you want to control your IRIS application authentication UI, you must extend %CSP.Login and override some methods according to your needs.This article is going to detail those methods and what you can do with them.In addition to that, you will get an explanation of the delegated authentication mechanism provided by ZAUTHENTICATE.mac routine.

I have some code written in objectscript but need to trigger it from clinical viewer.   Someone does a search for a patient with a not found response which then triggers the code 

Hi Team,

Can you please help with this error as below :

 DB or Backend Automation on IRIS Dataplatform performed?

Anyone performed  UI Automation (visual traces) on IRIS Dataplatform?

“I have been waiting for thirty seconds for service. This is outrageous! I am leaving!”

“I am very sorry to hear that, sir. Perhaps, next time, you should make a reservation.”

If you heard that comment at your favorite restaurant, you would think the person saying it was being ridiculous. However, in the context of your API, it makes perfect sense. Just like your favorite eatery, your API has some regular patrons who, as you know, will be visiting one day or another. It would be great to be able to make a standing reservation for them as well.

It will involve a couple of IRIS fundamentals.

Introduction

Not so long ago, I came across the idea of using Python Class Definition Syntax to create IRIS classes on the InterSystems Ideas Portal. It caught my attention since integrating as many syntaxes as possible gives visibility to InterSystems’s products for programmers with experience in many languages.

The author of that idea pointed out the possibility of creating classes using Python’s syntax, in addition to the currently available ones on IRIS. This concept inspired me to write this article, exploring the possibilities of accessing the full InterSystems power employing only Python.

Hi,

how to add x-api-key to FHIR repository header using objectsctipt?

Thanks,

Prasanth

InterSystems announces its second preview, as part of the developer preview program for the 2024.1 release.  This release will include InterSystems IRIS^®,  InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect.

Highlights

Many updates and enhancements have been added in 2024.1 and there are also brand-new capabilities, such as Using vectors in ObjectScript,  Vector Search (experimental), Multi-Volume Database, the ability to use Fast Online Backup (experimental), and the introduction of Multiple Super Server Ports. Many other improvements are also in this release, such as the Flexible

Hi 

I am trying to connect to node js on iris community version  . Node js is properly installed .

I am executing the demo hello  world from github .

these are the parameters :-

    var ip = "localhost"

    var port = 51773

    var namespace = "USER"

    var username = "SuperUser"

    var password = "SYS"

when executing >node demo.js i get a connection error .

Error: connection to server denied [ERROR_FAILED_TO_CONNECT]
    at main (C:\Users\AF\demo.js:18:35)
    at Object.<anonymous> (C:\Users\AF\demo.js:30:1)
    at Module._compile (node:internal/modules/cjs/loader:1376:14)
    at

Hi Friends ,

I have a requirement to expose REST endpoint to consume JSON payload and process it with BusinessProcess invocation.

Here is the code

 // Obtain an instance of the class
          Set instance = ..%New()
          Set tSc = instance.SendRequestSync("CIESendInviteProcess",cieinviteReqObj,.pResponse)

end up with run time exception, plz help me to resolve it.

Thanks,

Prashanth

Has anyone noticed that when IRIS is forced down that the EnsLib.JavaGateway.Services do not properly shut down and release the ports? While we can write a shell script to kill the processes at the OS level, I was wondering if anyone experienced this issue.

We are working on our Mirroring setup/failover and had the team testing forcing the Primary down to make the Backup to become the Primary Server. When this happened and we failed back, IRIS could not restart the JavaGateway.Services because the ports were still in use.

I am wondering if I need to write a %ZSTOP to ensure that these processes

Hello everyone!
I need to transform a String, which is a numerical value, to an Integer.
The value gets returned in my Rest service as "testingID": "1234567", but I need it to be "testingID": 1234567

Thanks beforehand! Appreciate all the help I can get! :)

Hello,

I am trying to connect to a web socket endpoint that potentially has a number of different IP addresses for load balancing purposes. 

I have been asked whether it's possible to use a DNS name to resolve the IP address rather than statically assigning one specific IP address in the TCP Operation.

If it's not possible to resolve on a DNS name directly on the TCP operation, then I wondered whether it was possible to provide multiple IP addresses.

In the documentation, it mentions that I can provide a value like this "!192.168.1.1, 192.168.1.2, 192.168.1.3" for multiple IP addresses but that

InterSystems FAQ rubric

The $ZF(-100) command is used in the following format.

$ZF(-100, flags, command name, command arguments)

The "/shell" flag is required when running OS commands.
For example, use mkdir like this:

 // mkdir C:\temp\newdir
 Write$ZF(-100, "/shell", "mkdir", "C:\temp\newdir")

If a command has multiple arguments, enclose them in double quotes and separate them with commas, as in the example below.

 // move C:\temp\a.txt C:\temp\a2.txt
 Write$ZF(-100, "/shell", "move", "C:\temp\a.txt", "C:\ temp\a2.txt") // net use Z: \\filesrv\public /user:user password
 Write$ZF(-100, "/shel

Hi all,

I'm very new to this ecosystem so please bear with me:

I've startted learning online and have installed everything I need. I have VS code and I have most definitely installed the pack (3 packages) needed for working on it with ObjectScript. Even though this is the case I'm running into 2 problems:

1. when I type "class" I only get 4 option for auto complete. no "class with multiple inheritances" or anything of the sort. In fact, no Class at all, only ClassMethod. ClassResponse etc.

2.

InterSystems announces its third preview, as part of the developer preview program for the 2024.1 release.  This release will include InterSystems IRIS^®,  InterSystems IRIS^® for Health^TM, and HealthShare^® Health Connect.

Highlights

Many updates and enhancements have been added in 2024.1 and there are also brand-new capabilities, such as Using vectors in ObjectScript,  Vector Search (experimental), Multi-Volume Database, the ability to use Fast Online Backup (experimental), and the introduction of Multiple Super Server Ports. Many other improvements are also in this release, such as the Flexible

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's.

I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path.

I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path.

Thanks in advance.

This may be a very specific problem but might help with some general information that I wasn't able to find anywhere.

I have started to train 2 IntegratedML models using AutoML one month ago.

My first attempt was very optimistic with a class that has  26 Properties and 100.000 datasets. I wasn't expecting good results, just wanted to test it. 
(CREATE MODEL ECLASSPREDICT3 PREDICTING (eClass) FROM CRMSHOPARTIKELML)
My second attempt was more specific using the same class structure but reducing the dataset to 10.000 entries and only using certain properties.
CREATE MODEL ECLASSPREDICT4 PREDICTING

I am trying to create a program to upload blob files from IRIS to Azure Blog Storage, but with no luck.

First, I am trying the APIs, but  ##class(%Net.Cloud.Storage.Client).CreateClient() fails with the message "Cannot establish connection". Following the documentation, the parameters are like: CreateClient(, 1, credfile, , .tSC) where credfile specifies a file containing:

DefaultEndpointsProtocol=https
AccountName=aihpocsadicom
AccountKey=RealAccountKeyHere
EndpointSuffix=core.windows.net

Am I missing something?

Just in time for Valentine’s Day, we are showing you some Adaptive Analytics love!  InterSystems IRIS Adaptive Analytics version 2023.3 is now available from the InterSystems Software Distribution  page.  This release includes AtScale 2023.3 with additional tuning, API enhancements and the following new capabilities:

• Support for Qlik Sense as a qualified Business Intelligence tool in addition to the existing support for  Tableau, Microsoft PowerBI, Microsoft Excel and Looker
  
  • Note that Qlik Sense is supported in Import mode; see the AtScale documentation for additional information
• Collib

Nowadays so much noise around LLM, AI, and so on. Vector databases are kind of a part of it, and already many different realizations for the support in the world outside of IRIS. 

Why Vector?

• Similarity Search: Vectors allow for efficient similarity search, such as finding the most similar items or documents in a dataset. Traditional relational databases are designed for exact match searches, which are not suitable for tasks like image or text similarity search.
• Flexibility: Vector representations are versatile and can be derived from various data types, such as text (via embeddings like Word2Vec, BERT), images (via deep learning models), and more.
• Cross-Modal Searches: Vectors enable searching across different data modalities. For instance, given a vector representation of an image, one can search for similar images or related texts in a multimodal database.

And many other reasons.

So, for this pyhon contest, I decided to try to implement this support. And unfortunately I did not manage to finish it in time, below I'll explain why.

Hello,

I have a problem with a FHIR Interop scenario that the HTTP Header Value content-type between IRIS and client changes in case of an error (HTTP 422). If I set the status in the response to 200 OK as the last step in the service class, the return transmission works.

Within my operation class, the error code is taken from the source system and entered in the HS.FHIRServer.Interop.Response message. 

Within the CSP gateway I am also shown that the content type is 422 application/fhir+xml and is returned.

When I look at the packet in Wireshark, it is already text/html. 
A URL rewrite is not

Hi Community,

We're pleased to invite you to the upcoming webinar in Hebrew: 

👉VS Code - Beyond the Basics 👈

📅 Date & time: February 6th, 3:00 PM IDT

Does InterSystems have plans to add BLOB storage for Document databases?