Article Evgeniy Potapov · Dec 19, 2023 6m read

Basics of using ANALYZER: Effective data management and analysis in the InterSystems IRIS Data Platform

In today's digital age, effective data management and accurate information analysis are becoming essential for successful enterprise operations. InterSystems IRIS Data Platform offers two critical tools, ARCHITECT and ANALYZER, developed to deliver convenient data management.

ANALYZER is a powerful tool available within the InterSystems IRIS platform to provide extensive data analysis and visualization capabilities. This tool allows users to create summary tables and charts to analyze data. It also lets you perform detailed studies and analyses based on available data.

#InterSystems IRIS
2
1 519
Article Megumi Kakechi · Jan 4, 2024 1m read

What to do when a large amount of memory is used while processing relationships

InterSystems FAQ rubric

If a relationship is set and there is a large number of n in a 1:n ratio, a large amount of memory may be consumed due to sequential processing of the relationship.

After referencing a many-sided object in a program and internally swizzling it, simply releasing the variable containing the OREF (deleting it, setting another value, etc.) will not free the many-sided object and the relationship object. This is the cause.

#Caché #Ensemble #InterSystems IRIS #InterSystems IRIS for Health #Tips & Tricks
0
0 342
Article Brendan Bannon · Dec 27, 2016 8m read

The Art of Mapping Globals to Classes (4 of 3)

The Art of Mapping Globals to Classes (4 of 3)

The forth in the trilogy, anyone a Hitchhikers Guide to the Galaxy fan?

If you are looking to breathe new life into an old MUMPS application follow these steps to map your globals to classes and expose all that beautiful data to Objects and SQL.

If the above does not sound familiar to you please start at the beginning with the following:

The Art of Mapping Globals to Classes (1 of 3)

The Art of Mapping Globals to Classes (2 of 3)

The Art of Mapping Globals to Classes (3 of 3)

#Caché #Globals #Mapping #Object Data Model #SQL
7
0 2331
Question Enrico Parisi · Dec 28, 2023

git-source-control and CSP applications

I'm testing git-source-control and I have  problem with a CSP application.

I was able to configure in settings a CSP application that use the path /csp/myapp, that worked.

I have another application /slg and I'm unable to add it to Git.
I created the mapping as "/CSP/" - "/slg" - "csp/slg/", then in Studio when I right click on the CSP folder in the Namespace Work Area, select Git -> Add:

porting new version of .slg to E:\git\iris-prod

No mapping with a matching coverage found for file E:/git/iris-prod
No mapping with a matching path found for file E:/git/iris-prod
#InterSystems IRIS #Source Control
2
0 325
Question Yone Moreno · Jan 3, 2024

Troubleshooting SOAP Header Processing Issue Between HealthShare Environments: Seeking Assistance and Insights

First of all, thanks for your help, and time reading this question.

Why, when we send a SOAP message from SoapUI to a SOAP service in a HealthShare environment called 'ESBCHUIMI,' it recognizes the 'Credenciales' header, which has 'usuario' and 'password' as properties. This class is a %SOAP.Header.

However, when we load the WSDL using the SOAP wizard from this SOAP Service to another HealthShare environment called ESBSSCC and send it from SoapUI to ESBSSCC, when it is being forwarded from ESBSSCC to ESBCHUIMI, the ESBCHUIMI's service outputs:

#HealthShare #Code Snippet #SOAP
5
0 275
Question Mark Scicluna · Jan 3, 2024

CSP variable interaction with JSP

I wish to retrieve data from a cache table and then chart the results using javascript/chart.js.  I have had numerous iterations of the code attempting to do this (none of which worked) and my latest iteration is shown below.  

<html>
<head>
   <title>Cache Server Page</title>


   <!-- Include the Chart.js library -->
   <script src="chart.umd.min.js"></script>
   
<csp:SQLQUERY NAME='resultSet' P1='A'>
select Value, StatsDate from Stats 
</csp:SQLQUERY>


<script LANGUAGE="JavaScript">
// Initialize arrays to store data
var xValues = [];
var yValues = [];
</script>

<csp:WHILE CONDITION="resultSet.Next()">     

#Ensemble #InterSystems IRIS #CSP #JavaScript
8
0 396
Question Jayesh Gupta · Jan 3, 2024

Unable to connect to IRIS container through DBeaver via JDBC driver

So I am running IRIS 2023.3 via a Docker container on Windows 11 and when I go to System Administration > Connectivity > SQL Gateway Connections, I am able to connect to the iris container via jdbc. However, when I go to JBeaver and try connecting to IRIS via JDBC I am unable to do so. I know that this is a local laptop issue because when someone else runs it on t  heir mac it works fine. 

 

#InterSystems IRIS
3
0 306
Announcement Pravin Barton · Nov 2, 2021

Introducing the Evaluation Service for Community Edition Downloads

Hello everybody! We’re happy to announce a new way to download Community Edition kits of InterSystems IRIS and IRIS for Health. The Community Edition is a no-cost developer edition that makes it easy to start developing solutions with IRIS. You can now download these kits through the Evaluation service: evaluation.intersystems.com.

If you already have an InterSystems single sign-on account (for example, to post here on the Developer Community), you can log in with those credentials. If you're new to InterSystems, please follow the link from the login page to register for a new account.

#InterSystems IRIS #InterSystems IRIS for Health
3
3 1736
Question Cyril Grosjean · Jan 2, 2024

Access to a RecordMap with SQLAlchemy

Hi,

I'm trying to access to my datas stored in a RecordMap from SQLAlchemy, and I need to access to any tables already created before using SQLAlchemy.

Here is some part of my code :

TestBase:

classTestBase(DeclarativeBase):
    CreatedAt: Mapped[int] = mapped_column(TIMESTAMP, default=func.now())
    UpdatedAt: Mapped[int] = mapped_column(TIMESTAMP, default=func.now(), onupdate=func.current_timestamp())

 

Engine creation and entities binding :

#InterSystems IRIS for Health #VSCode #Embedded Python #SQL #Ubuntu
0
0 170
Question Ashok Kumar T · Dec 19, 2023

Grafana connectivity to local IRIS

Hello Community,

How to properly connect and run the Grafana with my local IRIS community instance  in Windows machine. I had executed Mr. @Dmitry Maslennikov contianerzied environment from this POST  and it's working pretty. However the Plugin is not yet posted in the Grafana plugin datasource. What is the roadmap to do setup and establish connection same in my local environment . I have read some additional community post for reference 
 

Regards,

Ashok

#InterSystems IRIS #InterSystems IRIS for Health #System Alerting and Monitoring (SAM) #System Administration
1
0 308
Article Brendan Bannon · Dec 27, 2016 8m read

The Art of Mapping Globals to Classes (5 of 3)

Mapping Examples

Clearly if you have a fourth article in the trilogy you need to go for the money grab and write the fifth, so here it is!

Note:  Many years ago Dan Shusman told me that mapping globals is an art form.  There is no right or wrong way of doing it.  The way you interpret the data leads you to the type of mapping you do.  As always there is more than one way to get to a final answer.  As you look through my samples you will see there are some examples that map the same type of data in different ways.

#Caché #Mapping #Object Data Model #SQL
15
1 2767
Article Jose Ruperez · Oct 11, 2016 4m read

How to execute terminal commands from a webpage

Now, let’s say you can’t access the terminal or simply you just rather execute it from a web interface. In this article, I will show you how to execute terminal commands from a simple web page.

For example, in the image below you see how we execute $zv on a webpage:

This is mostly possible due to the XECUTE command in Caché ObjectSCript. This command takes a string as a parameter and tries to execute it. This is the command used from the webpage, to execute what is being passed from the left navigation menu.

#Caché #Beginner #Code Snippet #Frontend #ObjectScript #Terminal #Tips & Tricks
7
0 32720
Question Yone Moreno · Dec 19, 2023

Transitioning from %?????????? to %SerialObject: Data Purge and Global Usage Concerns

Good morning,

First of all thanks for your help and time.

We find ourselves at a crossroads in our development journey, and we're reaching out to the community for insights and guidance regarding a critical aspect of our data management strategy.

Our current challenge revolves around the persistence of data in Globals, specifically when it comes to purging. The issue at hand is that, despite purging, data stored in Globals under the current %Persistent classes remains intact. To address this, we are contemplating a shift from %Persistent to %SerialObject for each relevant class.

#InterSystems IRIS #Databases #Data Model #Globals #Object Data Model
3
0 389
Article Mihoko Iijima · Dec 28, 2023 1m read

Recompilation of routines after version upgrade

InterSystems FAQ rubric

There is no need to recompile the routines after the version upgrade, but since the version update overwrites %SYS, user-created INT and OBJ format routines (*.INT,*.OBJ) in %SYS will be deleted. Therefore, you need to be careful. 

MAC, INT and OBJ routines with the following names are not deleted.

%Z*.INT, %z*.INT, Z*.INT,z*.INT
%Z*.OBJ, %z*.OBJ, Z*.OBJ,z*.OBJ

Please note that classes/CSPs need to be compiled after upgrading.

However, if you are upgrading to a maintenance release, no compilation is required. For details, please refer to the document below.

#Caché #Ensemble #HealthShare #InterSystems IRIS #InterSystems IRIS for Health #System Administration #Tips & Tricks
0
1 256
Question Norman W. Freeman · Dec 20, 2023

How to decode the binary data produced by in the event log ?

I am using the event logger from CSP gateway with level "v9r" enabled, in order to dump the raw content of some HTTP requests.

I would like to decode the body response data, when it's in binary form. AFAIK the event logger will convert characters outside the 32-127 range (EBCDIC) to the "\xff" notation (where ff is a hexadecimal value). Here is an example :

Content What is written in the log Remark
helloworld helloworld  
hello £ world hello \xc2\xa3 world £ is C2A3 in Unicode
hello \xc2\xa3 world hello \xc2\xa3 world same as line above !
#InterSystems IRIS #Web Gateway
4
0 1356
Question Rob Ellis · Dec 27, 2023

Code Quality Checks: Javascript

Is it possible to get a code quality stamp of approval on the Open Exchange with an application written in Javascript?
My Iris Whiz application is a browser extension written in Javascript and I wonder if having the code quality stamp missing from my application page will put people off from using it.
 

#Open Exchange #JavaScript
2
0 226
Question Enrico Parisi · Dec 27, 2023

Operating system command execution and Windows Console

I just realized that operating system command execution does not work on Windows console if the IRIS service is started using a different user than Local System account (the default).

I always change the user configured in the IRIS service and I believe this is a standard good practice, particularly in "real" environments (be it production, stage, test or development) that are part of Windows Active Directory Domain.

#InterSystems IRIS #Terminal
1
1 331
Article Heloisa Paiva · Sep 22, 2022 4m read

Python and IRIS in practice - with examples!

Here you'll find a simple program that uses Python in an IRIS environment and another simple program that uses ObjectScript in a Python environment. Also, I'd like to share a few of the troubles I went trough while learning to implement this.

Python in IRIS environment

Let's say, for example, you're in an IRIS environment and you want to solve a problem that you find easy, or more efficient with Python.

You can simply change the environment: create your method as any other, and in the end of it's name and specifications, you add [ Language = python ]:

#InterSystems IRIS #Best Practices #Innovatium #Python
9
5 2404