Syndicate content 0  

Hi Developers,

It's time to announce the Winners for July 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in July 2021:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia

🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥉 @Eduard Lebedyuk, Sales Engineer, InterSystems Corporation, Moscow, Russia

Learn more about the competition and our awesome winners below.

4 0
0 196

Hey everyone,

We've made a video tutorial for an easy start on InterSystems Partner Directory:

How to list a company on InterSystems Partner Directory

https://www.youtube.com/embed/WaDUc5dSHhQ
[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]

4 0
0 196

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0
0 196
Question
· Apr 18, 2019
Importing a role

What is the process in importing a role from one server to another server?

Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.

It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.

0 2
0 194

What are best practices for JSON transformation in IRIS interoperability? This is for a non-healthcare use case, so any tools we happen to have around FHIR might not be available. The motivating use case is trimming down a verbose and needlessly complex REST API response to feed to an LLM - trying to reduce token usage and maybe get better results from less noisy data.

1 10
0 185

Window functions in InterSystems IRIS let you perform powerful analytics — like running totals, rankings, and moving averages — directly in SQL.
They operate over a "window" of rows related to the current row, without collapsing results like GROUP BY.
This means you can write cleaner, faster, and more maintainable queries — no loops, no joins, no temp tables.

In this article let's understand the mechanics of window functions by addressing some common data analisys tasks.

6 0
2 195

Been testing out the Production Validator toolkit, just to see what we can/not do with it. Seems really interesting and there seem to be some use cases for it that can really streamline some upgrades (or at least parts of upgrades) but I was running into so many hurdles with the documentation. I am curious if anyone else has used it.

2 6
0 189
Question
· Dec 17, 2024
UDP Adapter not working

Hello

I am trying to work with UDP Connection/Adapter and I get this error.

ERREUR #5002: Erreur Cache: <WRITE>zSend+5^EnsLib.UDP.Common.1

Here is the method

Class TEMPLATE.BO.UDPSend Extends Ens.BusinessOperation
{

Parameter ADAPTER = "EnsLib.UDP.OutboundAdapter";

Property Adapter As EnsLib.UDP.OutboundAdapter;

5 2
0 193
Question
· Jul 3, 2024
Polybase and IRIS

Hi all, I am trying to use Polybase in SQL Server 2019 to access an external Cache/IRIS Database. I have followed the initial steps of enabling Polybase, creating a Database, DB scoped credential and then an External Data Source. These steps have not caused any issues and appear to be successful, I am using the same DSN we use for a Linked Server connection that works normally. I am running into an Error when trying to Create an External Table. The error is a generic Native Code 469 "Driver Not Capable".

0 2
0 193

Hi Community,

Let's meet at the online meetup with the winners of the Vector Search, GenAI and ML Contest. It's a great opportunity to chat with the InterSystems Experts team and our contestants.

Winners' demo included!

Date & Time: Thursday, May 23, 12 pm EDT | 6 pm CEST

https://www.youtube.com/embed/QNwFw1rE6jM?si=rK7Y1_UVdvXFzEHE
[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 195

After running many tests to kick the tires calling Python from COS (which worked fine) in any directory, I encountered problems when trying to access Python libraries like Numpy from any OTHER namespace. I saw some other posts about this but the resolution seems unclear. When I run the test program method numpytest below in %SYS it works just fine. If i run the Python method in any other namespace I get:

PITT>do ##class(test.python).numpytest()
DO ##CLASS(test.python).numpytest()
^
<OBJECT DISPATCH> *python object not found

0 4
0 191

I am able to capture two values in two separate contexts in the BPL. One through an API call and another by looking at the contents of PV1:7. These are context.Prov and context.ProvName. I am checking to see if the values contained in the contexts are the same and if yes process further and if not stop.

In the IF statement I tried the below but none worked. Can someone please tell me what I am doing wrong. The trace does show that they are the same value so that's not it.

1. context.Prov = context.ProvName

2. "context.Prov" = "context.ProvName" and

0 4
0 191

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems IRIS Cloud SQL and IntegratedML Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants.

Winners' demo included!

Date & Time: Thursday, April 27, 12 pm EDT | 6 pm CEST

https://www.youtube.com/embed/rXQtHFCYMWk
[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 195
Announcement
· Feb 16, 2023
What's new on Open Exchange

Hi Community,

Just to make sure you're up-to-date with the latest happenings on Open Exchange as there have been some updates that you might have missed, but could be really helpful for you. Take a look and see if any of them can benefit you in your work!

4 0
2 195

Hi Developers,

Enjoy watching this new video presented by @Evgeny Shvarov:

Package First Development Approach with InterSystems IRIS and ZPM

https://www.youtube.com/embed/havPyPbUj1I
[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]

4 0
0 195

Hello Developer Community!

We are looking to better understand how our users use the Documentation. If you have a few minutes, please fill out this quick survey - https://www.surveymonkey.com/r/HK7F5P7!

Feedback from real users like you in invaluable to us and helps us create better product. Your feedback can go further than the survey - we would love to interview you about your experience, just indicate in the survey that you’re open to talking to us!

0 0
0 195

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in February 2020!

New applications in February 2020

EXCEL SUDOKU by alex kosinets

Sudoku game implementation in Excel using InterSystems IRIS as a server

RESTForms2 by Henry Hamon Pereira

RESTForms2 is a framework to create the REST API for InterSystems IRIS persistent objects automatically

FirstLook-Globals by Evgeny Shvarov

Firstlook example of InterSystems Globals

IRIS Interoperability Message Viewer by Henrique Gonçalves Dias

A new approach for the Interoperability Message Viewer

iKnow by Benjamin De Boe

The iKnow Natural Language Processing technology was originally developed in Belgium and then acquired by InterSystems in 2010. In February 2020, InterSystems published the technology to open source, expanding the possible use cases for it beyond embedded use from the InterSystems IRIS Data Platform. iKnow is open to community contributions to enhance the engine, language models and interfaces for use in-text exploration, information extraction, and machine learning use cases.

0 0
0 195

Presenter: Paul Dayan
Task: Upgrade with minimal downtime
Approach: Provide examples of planning minimal-downtime upgrades from a variety of starting scenarios

When upgrading Caché, Ensemble or your application on your business-critical system, you want zero or minimum downtime. This session explores the problems and options when upgrading, and how mirroring can reduce or eliminate business disruption, with practical steps and a demonstration.

Content related to this session, including slides, video and additional learning content can be found here.

0 0
0 195