I compiled some data about past InterSystems DC constest.

About this article:

In InterSystems IRIS, the default form of access to the management portal is HTTP, which means that if the client is in the office and the server is in the cloud, many clients probably desire to encrypt their traffic in some way.

Thus, we would like to show you some ways to encrypt your traffic to and from the IRIS management portal (or various REST services) running on AWS.

This article uses the IRIS built-in apache server for access. It should not be used for benchmarking purposes or as a method of access from production environments applications.

Caché running on Windows Server includes a built in telnet service.  Unfortunately though telnet is a plain text protocol, which generates a security violation from our network security scanner.  Is there a way to replace telnet with SSH to connect to a Caché system running on Windows 2012 R2?

Web Crawling is a technique used to extract root and related content (HTML, Videos, Images, etc.) from websites to your local disk. This is allows you apply NLP to analyze the content and get important insights. This article detail how to do web crawling and NLP.

To do web crawling you can choose a tool in Java or Python. In my case I'm using Crawler4J. (https://github.com/yasserg/crawler4j).

Crawler4j is an open source web crawler for Java which provides a simple interface for crawling the Web. Using it, you can setup a multi-threaded web crawler in few minutes.

Hi fellows,

I'm glad in annouce that now I'm certified:

https://www.youracclaim.com/badges/30f9d00f-82a3-45ab-a879-b83a7053f00d…

Hi community, I used website-analyzer - an app that uses InterSystems NLP and Crawler4J to extract all website content and do NLP on it. I limited to 200 pages and discovered this:

Top 10 Concepts - business and content topics in the InterSystems site:

Other frequency concepts, see the focus in the iris speed, scale and data value:

Top 10 Concept Dominance - business relations in the InterSystems site.

If I have table of 60 fields is there a way to add values to columns dynamically ?

Fields are like this Field1, Field2, Field3...Field60 and I am reading data from flat files. I tried below code but it didn’t work

For i=2:1:$LENGTH(line) {

set SourceTable.Field_i = $PIECE(line, "|", i)
 

Hi Developers!

Our Developer Community is growing - so great that it's now available in English, Spanish, Portuguese, Japanese and Chinese languages. And it's important to announce that no matter on which DC language version you publish posts and comments - they all are counted on Global Masters Advocate Hub! 

Let's see the number of points you get  on Global Masters for your contribution: 

Hi Community,

Enjoy watching the next video by @sween on InterSystems Developers YouTube:

⏯ Putting a match to FHIR with Postman Newman

Hi,

Do you have a guide or tutorial with recommendations to configure IRIS to a production environment? The better strategies, recommended disk, memory and processing settings, etc?

Hey Developers!

We're pleased to invite you all to the next competition of creating open-source solutions using InterSystems IRIS! Please join:

🏆 InterSystems Analytics Contest 🏆

Duration: December 7 - 27, 2020

I am trying to send email via smtp.gmail.com.

• I am using an object of %Net.SMTP to do so.
• I am giving it an object of class %Net.Authenticator to provide credentials to the gmail server.
• I am not encoding the user name or password.
• I have set the UseSTARTTLS property to 1
• I have set the SSLConfiguration property to “API”
• Since I am using TLS, I have set the port to be 587
• I am using an object of %Net.MailMessage for the message
• I am passing it to the Send method of the %Net.SMTP object to send the msg.
• I get the following error: ERROR #6033: Error response to SMTP MAIL FROM: 530 5.7.

Hi folks!

Do we have an embedded REST API in IRIS which accepts arbitrary SQL and returns data in JSON?

Or if anyone did something like this?

The idea is to have something like MDX2JSON but SQL2JSON.

Thanks!

Hi fellows,

I'm glad to share with you my new certification:

https://www.youracclaim.com/badges/3aa7dd58-9f94-417e-92de-2d62c6c477bb…

Hey Developers, 

Want to share with you our special session from InterSystems Virtual Summit 2020:

🔥 Developer Ecosystem Services: Developer Community and Open Exchange 🔥

I have a case where I need to look up the NPI provider against an External MS SQL database to retrieve our Provider Identifier to send to a downstream system. In the past I would use a Business Process (BPL) to connect to the outside MS SQL via JDBC and get that information for me. But I was thinking instead of creating a BPL process to do this, would it be better just to link to the outside MS SQL database table to retrieve the information in a SQL statement within a DTL?

So it is better to link to an outside database via a Linked Table wizard?

Languages like Java and C++ allows to develop a multi-threaded program with two or more parts that can run concurrently and each part can handle a different task at the same time making optimal use of the available resources specially when your computer has multiple CPUs. Is it possible In ObjectScript? If yes, Where I can get a good sample or application?

Hi Developers,

You asked for it – we did it!

We are introducing a new voting engine and algorithm to InterSytems Contests which you can try with the current contest – starting next Monday!

Hello Newman

So given the STAR method on how to introduce Newman with this effort, here it goes.

Hi everyone, 

I'm creating something to test the Analytics capabilities. 

I have a table with 100k records. Consulting the data using ^%G or SELECT, everything is working fine. 

But, when I create a Cube using this same class as Source, the Build results in only 1 fact.

I would like to know if anyone else faces the same situation before and have some guidance. 

Some details:

Class diashenrique.olist.data.order Extends %Persistent
{

Property customerID As diashenrique.olist.data.

Hello,

We are working with a vendor who only accepts JSON as payload. We are currently still on Cache/HealthShare, not IRIS. Since we have to send Continuity of Care Documents, this raises issues with Long Strings (some CCDs can be quite large and in addition to that, they have to be b64-encoded which increases their size even more).

My question is: if we were to go on IRIS and use %JSON.Adapter, storing the encoded Stream in an object's Stream property, would calling %JSONExport() on this object produce the desired JSON? Or would we have to call %JSONExportToStream()?

We are trying to make a document query from an HIE iti-43 on healthshare platform

the full SOAP message is follows

<?xml version="1.0" encoding="UTF-8"?>
<soap:Envelope xmlns:soap="http://www.w3.org/2003/05/soap-envelope" xmlns:wsa="http://www.w3.

Review InterSystems for a $25 Visa gift card! Plus, want to see what was popular this year in Learning Services? Check out the most-viewed videos, courses, certification exams, and more! It's all in December's Learning Services newsletter.

Subscribe to receive future newsletters in your inbox.

Hello community,

I need to know what permissions or resources, apart from read for the tables, a user would need to view the catalog via ODBC? The ODBC user can run queries sucessfully but cannot get the catalog from the DB via ODBC. Whereas a a user with %All can fetch the catalog.

Any help would be much appreciated.

Regards,

Juergen

Hi

I've had a play with the Docker image for IRIS Community Edition, but was disappointed to find that it seems to lack any of the HL7 v2 features that I'm familiar with in Ensemble/HealthShare. Is there another image with these features enabled (IRIS for Health Community Edition perhaps?) or is there any plan to make such a Docker image available?

Hi

I have a medical device (Nipro Surdial Dialysis ) which sends XML messages by TCP.

I would like to insert some of the info into a SQL SERVER table.

Is there some sort of TCP Inbound Adapter for XML ? 

Thanks

Hello,

I'm testing IRIS 2020.4 Preview with preview key.

I've access to the management portal but I can't connect with Studio.

This is my docker-command : docker run --name my-iris --detach --publish 9091:51773 --publish 9092:52773 --volume C:\Docker\iris_external:/external –-volume C:\Docker\iris_durable:/durable –-env ISC_DATA_DIRECTORY=/durable/irissys containers.intersystems.com/intersystems/iris:2020.4.0.524.0 --key /external/iris.key --password-file /external/password.txt

I notice that Caché Direct is disabled by the license.

Can someone help me out ?

Anyone know if it's possible using cache objectscript (or something else maybe) to reference an object property using a variable? For example:

s obj={}

s obj.prop1="hello"

s var="prop1"

w obj.var    <== which would result in a reference to obj.prop1 and write out "hello"

We are trying to convert some of our SQL Service Integration Service jobs from Visual Studio to Ensemble. If we execute a Stored Procedure within SQL Server Management Studio it is returning approx 12,000 rows. However when Ensemble executes the same Stored Procedure it is only returning 250 rows.

Is there a limitation to EnsLib.SQL.Snapshot?

This is how we are calling the Stored procedure

Method uspInterfaceEnsSelectPER355MC(pRequest As osuwmc.SSIS.DataStructures.InputPER355MC, Output pResponse As EnsLib.SQL.Snapshot) As %Status
{
Set SPQuery = "{ ?= call dbo.

Is IRIS DTL, Adapter, Production or ObjectScript class have a function to transform an arbitrary XML to JSON?