#InterSystems IRIS

I will give you some additional information on my first embedded Python package.
it is written as a mix of python and ObjectScript to take the best of both worlds.

Hey Developers,

New video is already on InterSystems Developers YouTube channel:

⏯ Using the VS Code Debugger for InterSystems ObjectScript

InterSystems has been using a two-stream release cadence with InterSystems IRIS since 2018 (see the original announcement from when we started).   We provide:

• Continuous delivery (CD) releases — these releases provide access to new features quickly and are ideal for developing and deploying applications that are continuously being updated and can take immediate advantage of new features.
• Extended maintenance (EM) releases — these releases are less frequent than the continuous delivery releases but provide the increased stability of maintenance releases.

I have created a Class method to list employees that are subordinated to a certain boss. But I don´t know how to relate the data in the way it was given to me.

For Example:

• ^Employee(IdEmployee) = Name

                  ^Employee(1) = "Jessica"

                    ^Funcionario(10) = "Rose"

• ^HistEmployee(IdEmployee, Date) = Salary^Job^IdEmployeeBoss

                    ^HistEmployee(10, 64628) = "3500^Secretary^1"

So, based on this seetings, Jessica is Rose's boss. But I don't know how I can make a relation between that string and the subscript. Can someone help me?

Hi Community,

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

In this webinar, we’ll present two templates to start working with Embedded Python :

1. What is Embedded Python and Jupyter;
2. Embedded Python with Interoperability (PEX hacked to use Embedded Python).

As always, our experts will answer the questions on how to develop, build, and deploy Python solutions using InterSystems IRIS.

Date & Time: Monday, February 7 – 12:00 PM EDT

Speakers:
🗣 @Guillaume Rongier, InterSystems Sales Engineer
🗣 @Bob Kuszewski, InterSystems Product Manager
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi Community,

We got requirement to Migrate whole interfaces from prod instance (cache2017.1 ) to new instance iris2020.1.

Currently around 100+ integrations (health share and health connect) up and running in prod instance (cache2017.1 ) , we need to migrate this live server to brand new server with iris2020.1.

Could you please suggest me guidelines and best practises while doing this migration.

Please ping me any document reference for this kind of Lift and Shift Migration.

After migration done, we will use new Live (iris2020.1 )instance only.

Thanks,

Prashanth

I am having a scenario where I need to check difference between current date and a past date should be less than 31 in Routing Rule. Can anybody help me how to code that?

Hi All,

We have been using DeepSee which has been the integrated Analytic Dashboard built over Cache Cubes. It works fine but it's visual capabilities are limited and most probably is getting phased out.

If I am not wrong, Tableau is the suggested alternative to DeepSee .

Hi,

I'm a java developer,have  integration package for springboot?(maven or gradle)

Hi all - we just released the first episode of Season 2 for our Data Points podcast by Learning Services. This episode features a conversation with @Bob Kuszewski about Embedded Python. If you're a Python developer, or if you're simply interested in the functionality, check it out! For more information, head over to https://datapoints.intersystems.com.

Spring Boot is the most used Java framework to create REST API and microservices. It can be used to deploy web or executable web or desktop self-contained apps, where the application and another dependencies are packaged toghether. Springboot allows you do to a lot of functions, see:

Note: to learn about SpringBoot see official site - https://spring.

(I wasn't able to find this in the docs or the Community, so feel free to point me to a reference that I missed)

How can I determine the effective User and Group that will be used when an InterSystems IRIS process is doing file I/O on the file system for UNIX?  Bonus points if you can tell me how to do it from within InterSystems IRIS as well as from the host OS.

Thanks!

I'm trying to write a method that runs an OS command with $zf(-100,"/ASYNC") and then waits for it to finish before returning, but I can't figure out how to check if the child process (in $zchild) is still running. $System.Process.State($zchild) always returns "RUN" even once the child process is gone. Is there some better way to check this, short of running another OS-specific command and processing the output (which is just really annoying and unelegant)?

Hey Community, 

New video is already on InterSystems Developers YouTube:

⏯ Git & GitLab for Shared Development Environments

Maybe someday you will need to use Adaptive Analytics but there is little information about this, so I decided to write an article on how to start developing a dashboard on Tableau using the Atscale cube.

PC preparation

You need a driver to connect. I use Cloudera Hive. You can download the driver from the official site:
https://www.cloudera.com/downloads/connectors/hive/odbc/2-6-1.html
Registration is required, and you can do it right there for free. You also need to know your OS and bit depth in order to choose the right version for download.
Installation is simple, no explanation required.

Hi Community,

I have json equivalent persistent object in pjsonObj variable. Final JSON example below.

{
     "Document": {
                    "FileExtension": "pdf",
                    "FileContent": "JVBERi0xLjUNCiW1tbW1DQo...(very large bsae64 string)"
                }
}

Here FileContent field in json will contain converted base64 string of very large pdf(10pages). I need to submit this json as a payload to REST endpoint.

below code is working fine. 

set tSC=##class(%ZEN.Auxiliary.jsonProvider).%WriteJSONStreamFromObject(.newobj,pjsonObj,,,1,"aelqtw")
$$$LOGINFO("json"_

Hi everyone, i cant understand what is wrong in my query: 

ALTER TABLE MyNamespace.MyTable ALTER COLUMN CurrentColumnName RENAME NewColumnName

I just want to rename column name using sql.

I could not find any life example using this syntax.

SQLCODE for this query is -25:

-25 Input encountered after end of query

Quote from documentation:

• Rename the column using the syntax ALTER TABLE tablename ALTER COLUMN oldname RENAME newname. Renaming a column changes the SQL field name. It does not change the corresponding persistent class property name.

The InterSystems IRIS IntegratedML feature is used to get predictions and probabilities using the AutoML technique. The AutoML is a Machine Learning technology used to select the better Machine Learning algorithm/model to predict status, numbers and general results based in the past data (data used to train the AutoML model). You don't need a Data Scientist, because the AutoML it will test the most common Machine Learning algorithms and select the better algorithm to you, based in the data features analysed. See more here, in this article.

If your REST API need return a file to the client download, this is the source code that you could write (P.S.: extracted from the question https://community.intersystems.com/post/download-file-rest and its responses):

This article is a follow-up to the previous one on how to migrate from popular databases (like PostgreSQL and MySQL) to IRIS.
We will use the same procedures utilized to migrate from PostgreSQL. However, you will see that it is even easier since the data types in MySQL are very similar to IRIS. That is why we will not need to create transformation rules in the columns.

Get the sample data to the migration process

In GitHub it is possible to download a docker-compose project to build and run 2 databases:

• Source Database: MySQL database Docker instance with a sample database.

In this article I will explain the usage of %SQL_Diag.Result and %SQL_Diag.Message table along with all-new LOAD DATA functionality.

It is recommended to go through LOAD DATA documentation first. 

After successful operation LOAD DATA insert one record in %SQL_Diag.Result table and details are inserted in %SQL_Diag.Message table

Below is the basic command when table is already created and source file does not contain header row. 

LOAD DATA FROM FILE 'C://TEMP/mydata.txt' 
INTO MyTable

The file name must include a .txt or .csv (comma-separated values) suffix and both source and target have the same sequence of data columns.

Loading from File Source: Header

Apache Zeppelin it's a Multi-purpose notebook that allow you:

•     Data Ingestion
•     Data Discovery
•     Data Analytics
•     Data Visualization and Collaboration.

Apache Zeppelin interpreter concept allows any language/data-processing-backend to be plugged into Zeppelin. Currently Apache Zeppelin supports many interpreters such as Apache Spark, Apache Flink, Python, R, JDBC, Markdown and Shell.

It provides you a safe environment to get insigth of your data. You can take avantage of Zeppelin's higligths using both , JDBC and Spark IRIS native connectors.

Hi Community, 

New video is already on InterSystems Developers YouTube! Learn about the easy process of migrating to InterSystems IRIS:

⏯ Join Us on a Journey from Caché/Ensemble to InterSystems IRIS

I have seen the Cache Python binding documentation and would like to know if it's also possible with IRIS so I can write data and also read/get it from the DB? The cachesys folder does not contain any python libraries.

* In-Platform Agent-Based Simulation of a Connected Factory Cluster

Author: Sergey Lukyanchikov, InterSystems

1. Purpose

In this paper we prototype and explore how multiple agent-based models of robotic factories connected to other robotic factories (represented by their respective models) can be orchestrated using an all-purpose data platform – thereby simulating descriptive and predictive properties of a group of factories (a factory cluster).

Hi everyone,

Im trying configure the Caché Monitor Manager (^MONMGR) utility for send alert e-mails.
Following the steps I have doubs to configure the options in "Set Server" to send e-mails for hotmail or outlook (smtp-mail.outlook.com).
I dont know how can I configure Mail server SSLConfiguration for hotmail or outlook.
Could you give me help?
Thank you!

Mail server? mail.outlook.com (Enter '-' to reset) =>
Mail server port? 587 =>
Mail server SSLConfiguration?
Mail server UseSTARTTLS? 0 =>

How can I do to debug IRIS docker instance into VSCode?

From IRIS 2021.2 is possible write Class Methods using the Python Language. I used this new feature to detect persons and objects into images, using ImageAI (https://github.com/OlafenwaMoses/ImageAI). The ImageAI creator defines it as: "An open-source python library built to empower developers to build applications and systems with self-contained Deep Learning and Computer Vision capabilities using simple and few lines of code." In this article you will learn how to apply AI Computer Vision to detect object and persons inside images.

Hi,

What is the Python syntax I can use from a ClassMethod (developed in an IRIS using embedded Python), in order to invoke another class method,

- in the same class; and

- in another class.

I see 'self' is synonymous to use $this (..) in ObjectScript, but these are ClassMethods I am invoking, and self did not seem to work.

thanks - Steve