I have already asked a question about migrating an Oracle database to Caché, and I was promptly answered. Now, I have one more question, however it is more conceptual. In general, any tool defends its benefits, and looking at Caché's, among many, there is a lot of talk about speed. The question is, if I already have a database, and at the moment, its performance is not a problem, I would like to know what else could influence the change of this database? Remembering that it is functional and without any apparent problem.

Hi,

InterSystems IRIS has long supported the obvious translation functions required to for converting to upper or lowercase to enforce case-insensitive string comparison (e.g. in ObjectScript with $zconvert) and sorting (e.g. with SQL collation functions, not to be confused with NLS collation). Customers in international contexts have at times used custom workarounds to also treat accent insensitivity or even more advanced normalization duct tape. We’re looking to address such use cases at the system and SQL level to increase convenience for this international audience, which is well represented on the Developer Community.

Hi Community,

See how IntegratedML in InterSystems IRIS can be used to make machine learning predictions directly from SQL commands:

⏯ IntegratedML in a Nutshell

Let's imagine you have to implement a method with a definition

/// Set value to %session.Data
ClassMethod setValue(params...) As %Status
{
}

How it should work

do ..setValue("key1", "val")

is equal to

set %session.Data("key1") = "val"

and 

do ..setValue("key1", "key2", "key3", "key4", "val")

is equal to 

set %session.Data("key1", "key2", "key3", "key4") = "val"

so, quite simple, any amount of arguments, while the latest one is a value, and any previous is an index, should accept at least 2 arguments.

How would you implement this method?

I have created $zf  commands to encrypt/decrypt a file using GNUpg which is working fine in Terminal but not populating output file when I call this from BPL process. Any help would be appreciated!!

PEX Java classes are not in the maven public repository, so I need to download pex jar file. Where is PEX jar file can be found to download?

Hey Developers,

See how InterSystems IRIS Adaptive Analytics can be used to aggregate and query billions of records from a virtual cube, applying machine learning and analytics to that data.

⏯ InterSystems IRIS Adaptive Analytics in Action

Hi Community,

Please welcome the new video recorded by @Evgeny.Shvarovon InterSystems Developers YouTube:

⏯ Developing InterSystems IRIS solution using GitHub Codespaces

I am trying to use IRIS Native API in .NET code I see following code snippet here https://docs.intersystems.com/irislatest/csp/docbook/DocBook.UI.Page.cl…

  IRISReference valueRef = new IRISReference(""); // set inital value to null string
  iris.ClassMethodString("%SomeClass","SomeMethod",valueRef);
  String myString = valueRef.value;               // get the method result

But IRISReference is not available as a type.

 What reference (dlls) do I need to add for that? I have InterSystems.Data.IRISClient.dll , what else do I need? what am I missing here?

I find the Data Import Wizard very handy. Has anyone thought of enabling the form in the application where it can be adapted for application user requirement?

csp/sys/exp/UtilSqlExImWizardContent.csp?Wizard=Import&$NAMESPACE=

How Can I do to receive and read an uploaded file from a HTML form or REST API formdata into a Custom EnsLib.HTTP.InboundAdapter?

I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:

If you want get a file from a multipart API or html form request use ReadMIMEMessage, see my sample.

We released a new version of ZPM (Package Manager)

New in this release:

1) Interoperability support - support for dtl, bpl, lut, esd, x12 in module.xml

Now it's allowed to refer to DTL and BPL files. ZPM stores and uses them as CLS. 

Position: Intersystems Developer / IRIS Developer (Please send me your resume to  raju@intellisofttech.

Using the Java Gateway to speed development

InterSystems IRIS includes dynamic object gateways for Java, .NET, and (now) Python.  These gateways allow your IRIS application to use libraries in these languages, removing the need to create everything from scratch in ObjectScript.

In this example, we use the iTextPdf and Apache PdfBox libraries to read a text file and produce a basic PDF from it.  These libraries are deep and rich PDF controls, so a little bit of development could produce an example application that produces far more compelling results for your needs.

Hi Community!

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

In this webinar, we will talk about the interoperability capabilities of InterSystems IRIS, will do a demo of building the basic IRIS interoperability solution, and demo how to use the PEX. Also, we’ll discuss and answer the questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, November 2 — 10:00 AM EDT

Speakers:  
🗣 @Stefan Wittmann, InterSystems Product Manager 
🗣 @Eduard Lebedyuk, InterSystems Sales Engineer
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

InterSystems is offering  a new and easy challenge as part of Global Summit 2020. As you know IRIS Data Platform 2020.4 and IRIS for Health 2020.4 are now in preview release. We are looking to improve the developer experience in migrating from earlier 2020 container release(s) of these products  to the 2020.4 preview release.
We invite you to complete a survey and get 7000 points on Global Masters🎁

Migrate from Java Business Host to PEX

With the release PEX in InterSystems IRIS 2020.1 and InterSystems IRIS for Health 2020.1, customers have a better way to build Java into productions than the Java Business Host. PEX provides a complete set of APIs for building interoperability components and is available in both Java and .NET. The Java Business Host has been deprecated and will be retired in a future release.

Advantages of PEX

• Allows developers to create any Production component in either Java or .

IRIS is an excellent option for machine learning projects with massive data operation scenarios, because the following reasons:

1. Supports the use of shards to scale the data repository, just like MongoDB.
2. Supports the creation of analytical cubes, this in association with sharding allows to have volume with performance.
3. Supports collecting data on a scheduled basis or in real time with a variety of data adapter options.
4. It allows to automate the entire deduplication process using logic in Python or ObjectScript.
5.

Hi Developers!

Here're the technology bonuses for the InterSystems Interoperability Contest that will give you extra points in the voting:

• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter Usage
• Production EXtension(PEX) Java or .NET usage
• Workflow Engine usage
• ZPM Package deployment
• Docker container usage

See the details below.

It's a wrap!    All of the focus sessions have aired now.  Of course, all of our 102 pre-recorded focus sessions are available on-demand now, so you can watch any and all of them, even if you missed the opportunity for live Q&A.

Speaking of live Q&A - we've had 6 live sessions, and these too are available for you to watch.  I wrote about this, and how your questions make us better, in a separate blog article. 

Smart Factory Starter Pack   One highlight that got a lot of attention today was the release of the InterSystems IRIS Smart Factory Starter Pack on OpenExchange.

Hi Community!

Watch a demonstration of Production Extension Framework (PEX) in InterSystems IRIS that uses a Kafka integration as an example:

⏯ PEX: Production Extension Framework Demo

Those of you who are following the FullStack competition here in the Developer Community will know that I submitted an entry named qewd-conduit.  I wanted to summarise why I think it's something worth you taking a bit of time to check out.

qewd-conduit uses the Node.js-based QEWD framework alongside IRIS to implement the back-end REST APIs for something known as the RealWorld Conduit application:

https://github.

One of the most useful features in Studio is code snippets.

Here's how to add snippets to VSCode.

Here's a generalized instructions.

1. Go to File - Preferences - User Snippets and choose objectscript.

2. Add your snippet, here's an example:

"SQL Statement": {
    "prefix": ["sql"],
    "body": ["#dim rs As %SQL.ISelectResult",
            "set rs = ##class(%SQL.Statement).%ExecDirect(,\"SELECT * FROM\")",
            "while rs.%Next() {",
            "\twrite rs.ID, !

We've just finished the second day of focus sessions - with a LOT of great content!  With parallel tracks, it's hard to keep up - but one advantage of a virtual conference is that you can watch anything you missed on-demand!

In yesterday's blog (Highlights of Day 1), I covered most of the special announcements such as InterSystems IRIS Adaptive Analytics and the FHIR Accelerator Service, so time to turn to a few broader strategic themes today.

Hi All,

I'm being asked if I can set up a AWS EC2 containerised version of IRIS and a separate AWS EC2 installation of Apache to serve IRIS web files.

Creating the Apache EC2 and containerised IRIS EC2 is the simple bit but getting them both to talk to each other does not seem quite so simple and I cannot find any documentation to describe how this can be achieved.

Has anyone else managed to achieve this?

Hi Community,

Please welcome the new video recorded by @Robert Cemper on InterSystems Developers YouTube:

⏯ ZPMshow Demo

The second week of Virtual Summit 2020 kicked off with the first day of focus sessions. We covered a LOT of great content - 38 sessions across a wide range of subjects. I thought it would be valuable to recap and review some of the bigger announcements and talking points.

 IntegratedML  Following the announcement of global availability for IntegratedML, this week highlights IntegratedML in multiple sessions.

$LIST string format and %DynamicArray and %DynamicObject classes

IRIS, and previously Cache, contain several different ways to create a sequence containing a mixture of data values.  A data sequence that has been available for many years is the $LIST string.  Another more recent data sequence is the %DynamicArray class, which along with the %DynamicObject class, is part of the IRIS support for JSON string representation.  These two sequences involve very different tradeoffs.