#InterSystems IRIS

Like hardware hosts, virtual hosts in public and private clouds can develop resource bottlenecks as workloads increase. If you are using and managing InterSystems IRIS instances deployed in public or private clouds, you may have encountered a situation in which addressing performance or other issues requires increasing the capacity of an instance's host (that is, vertically scaling).

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ Visual Studio Code for ObjectScript

According to IDC, more than 80% of information it is NoSQL, especially text into documents. When the digital services or applications not process all this information, the business lose. To face this challenge, it is possible use OCR technology. OCR uses machine learning and/or trained image patterns to transform image pixels into text. This is important, because many documents are scanned into images inside PDF, or many documents contains images with text inside. So OCR are an important step to get all possible data from a document.

Someone have experiences interconecting NonStop SQLMP with Iris ?

I need if possible some references or tips, actually connected with JDBC driver to interconnect and take many assorted problems, like :

Some queries, not to much, have null fetch, works fine but have no content to fetch, and i'm sure select sentence is not the problem.

Hi Community,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ InterSystems API Manager: Gummy Bear Factories

Hello,

I have a quick question regarding TSTART, however not certain if there is an answer.

If I am inside the transaction and I loose connection - I always assumed that transaction would TROLLBACK, however it does not.

Is there anything special I need to set up with my TSTART, in order for this transaction to safely rollback?

*********

As example: Let's say I am inside the TSTART and setting up / altering some data and my VPN connection got disconnected.  I kind of expect all the data to be rolled back.  

Thank you,

Alex

An interesting thing about data is that we can always discover something new.

And with this concept in mind, we create a new page to show a little bit inside the world of ZPM!

Hey Developers,

This week is a voting week for the InterSystems Developer Tools programming contest! So, it's time to give your vote to the best solutions built with InterSystems IRIS.

🔥 You decide: VOTING IS HERE 🔥

How to vote and what's new?

In addition to IntelliJ IDEA, it's now possible to configure SublimeText3 to be able to compile code there too. And what you will need is just the language server I did.

Hi Community,

See how the new embedded Python feature enables you to write user-defined SQL functions and stored procedures in Python:

⏯ Embedding Python in SQL: Write Your Stored Procedures in Python

Let me introduce the support of InterSystems IRIS in IntelliJ IDEA. This plugin adds Syntax Highlighting support for ObjectScript, and auto import and compile on the server after saving a changed file. It uses LanguageServer written in Rust, where was added an ability to import and compile code.

Is it possible execute create table from management portal?

I tried this:

CREATE TABLE SQLUser.Teste(ID INT NOT NULL,  coluna1 VARCHAR(255),  coluna2 VARCHAR(255),  coluna3 VARCHAR(255),  coluna4 VARCHAR(255)CONSTRAINT TestePK PRIMARY KEY (ID))

Error message:

Hi Everyone,

In the previous article, we combine ZPM with Config-API to load a configuration on module loading\install.
It could be useful for small applications, but for a large application, it's not convenient.

Hi Developers!

We had a set of technology bonuses for the InterSystems IRIS Developer Tools contest.

And here is how projects collected it:

Announcing gj :: locate.  A simple extension for VS Code that will help you get to the source of your errors.

In VS Code, using either the Serenji extension or the basic InterSystems objectscript extension, this small add-on will open the appropriate class or routine and position you at the exact line where an error occurred.

No more tedious counting of lines to find <UNDEFINED>zCredit+206^Ledger.Invoice.1.  Instead, with gj :: locate you can get there with just a couple of clicks.

This 20 second video tells it all:

Download now and enjoy getting to the source of your errors.

Hello developers! I present to you the project of editors in terminal mode. The full-screen editor of routines, arrays and text files in terminal mode can be useful to you when debugging your project in docker or when your web interface is unavailable or limited for some reason. Although this project is self-sufficient, I decided to make it as an addition to the ‘zapm’ module for the convenience of calling editor commands.

If your instance does not have a ZPM, then you can install the zapm-editor module in one line:

I want to convert the image to base64.

I have only a remote image URL.

please suggest the solution with allow cors origin.

gj :: connect is a demonstration extension that shows how to extend the Intersystems Server Manager to perform custom actions.

It makes use of the context menu contribution points to add both in-line and right click menu options.

It also demonstrates how to create a new top level folder in your workspace corresponding to the server and namespace selected in Server Manager.

Features

You may think it isn’t too difficult to get from label+offset^routine to the actual source line responsible for the error.  For an expert it isn't that hard... most of the time.  But there are enough oddities and special rules that even an expert can get it wrong, whilst spending a lot of time trying to get there.

gj :: locate is the latest tool from George James Software – it debugs any error, class or routine by converting the location of an error in compiled .int code to the corresponding location in your source, and then taking you right there.

Image this scenario…

Hey Developers,

You asked - we did it! We're glad to announce the next competition for InterSystems Developers! Please welcome: 

🏆 InterSystems Programming Contest: Developer Tools 🏆

Submit an application that helps to develop faster, contribute more qualitative code, helps in testing, deployment, support, or monitoring of your solution with InterSystems IRIS.

Duration: March 29 - April 25, 2021

Total prize: $8,500 

Greetings all,

Need to connect your VSCode to an InterSystems Server?

Heard of this option?

Hi Developers,

In the previous article, we describe how to use config-api to configure IRIS.

Now, let's try to combine the library with the ZPM client.
The goal is to load a configuration document during zpm install at the configure phase.

For this exercise, a template repository is available here (this is based on objectscript-docker-template ).

We attempt to :

• Create a database MYAPPDATA.
• Set Globals mapping for dc.PackageSample.*.
• Add a user named SQLUserRO with read-only SQL role access.
• Add an SSL Configuration named SSLAppDefault.
• Create a REST application /rest/myapp.

Some changes in IRIS configuration require a restart of IRIS.
This is no big issue as long as I have access to the server command line with sufficient privileges.
In a container, this is not always given.
Stopping IRIS from the terminal/session prompt is no problem.
But the restart after is.  

Note1: container start-stop is no option as it might be removed by option --rm in docker run
Note2: the target is linux (manly in docker).  Windows is excluded

GitHub

When you have more than ten thousand users in your database, it becomes time-consuming and inconvenient to assign group access rights through the standard IRIS interface. In this artilce I want to introduce you an application to automate this process.

I’ll show you how to assign and change the role lists for the users, selecting them by context, and I will also show you how to expand this application’s functionality. you know how to apply your work as an administrator and developer to the new features of the well-proven apptools software complex. With the addition of an adminLTE template, you can now quickly and easily create interface interactions for any entity and many functional modules. The goal while developing this toolkit is to write as little JavaScript as possible as well as transfer and implement all the dynamics as much as possible in the ObjectScript.

Hi Developers,

Please welcome the new video specially recorded for Developer Tools programming contest: 

⏯ Deploying InterSystems IRIS docker solutions to GKE cloud in 5 minutes

Hi folks!

Often while debugging you want to know the values of all the parameters.

Using VSCode Debugger is not an option.

What do you use to know what parameters came to the method?

My hope if you have a "magic" macro that will store all the variables with their names into a global?

And share your approaches, please?

We released a new version of ZPM (Package Manager)

New in ZPM 0.2.14 release:

• Publishing timeout
• Embedded vars usage in module parameters
• Package installation from Github repo
• Transaction support for install, load and publish.

See the details below.

Episode 17 of Data Points features a roundtable conversation with Carmen Logue, Benjamin De Boe, and Thomas Dyar about the Analytics & AI area of the InterSystems technology stack. Learn from these product experts about the various technologies and partnerships that exist within the Analytics & AI space at InterSystems, how some customers use these tools, and what might be coming in the future.

Hi,

We need to implement Oauth2 Code Flow + PKCE. Any experience with InterSystems OAuth2 Server on this would be welcome.
What parameters did you setup on OAuth 2 server configuration page  to make it work?

Thanks!

We are looking at moving from Cache to IRIS, if we do this we will want to use Intersystems Reports.  We have a lot of Crystal Reports to convert.  is there a conversion tool or best practice for doing the conversion