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?

Is there anyone who has experience in translating HL7 2.4 ADT messages (MLLP) to JSON format? We are going to push ADT messages to Salesforce. However, salesforce does not support MLLP. All advice on this is welcome. Thanks a lot!

🏆 Create an innovative service for Krasnaya Polyana IT cluster participants and locals! 🏆

Steford group together with the Polyana IT community with the support of InterSystems Corporation invite you to join Polyana App 2020 Hackathon!

If you are suddenly now in Krasnaya Polyana, Sochi, Russia and want to share your ideas, your IT & business energy, come, participate, suggest and cheer for the teams on December 12-13 at the Steford coworking space. Or participate online!

Create the most helpful service for local IT infrastructure, business, and citizens and get the first prize of $1,400 and the opportunity to participate in the InterSystems track of MIT Grand Hack 2021! 

More details in English can be found here.

➡️ Visit the official landing page in Russian.

Hey Developers,

Please welcome the new video by @sween on InterSystems Developers YouTube:

⏯ InterSystems IRIS Native Python API in AWS Lambda

QEWD is assumed by most people to only integrate with IRIS (or Cache) via a connection through IRIS's high-performance C interface.  This requires QEWD (and its Node.js environment) to be installed and configured on the same machine as IRIS.

I'm frequently asked if QEWD can run on a separate server (or servers), and access IRIS (or Cache) over a network connection.  The answer is yes it can, but the information on how to set it up in this way has been admittedly a bit tricky to discover.

A permanent job opportunity has arisen for a Caché/Ensemble /Iris developer with at least 3 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance,  healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

I am fairly new to using VSCode. I have used VSCode to create some files on our Test Server, now I need to move them to Production.

Looking through the VSCode extension documentation, maybe I missed it but how to I migrate code from one workspace to another. In Studio I was use to exporting the code into an XML and just being able to import it on the Production server version of Studio.

Thanks

Scott

Hi Community,

Please welcome the new video on InterSystems Developers YouTube:

⏯ The Freedom of Visualization Choice: InterSystems BI

Hello, 

I am attempting to setup a DICOM Routing to Storage Production using Ensemble 2017.1. I have followed the Routing to Storage production given in Ensemble Demo Namespace. I have created association with appropriate “Presentation Context” for inbound and outbound PACS system.  I am attempting send a Computed Radiography Image from one PACS to another via Ensemble but its failing when sending the image to the receiving PACS with following error :

 ERROR <Ens>ErrException: <READ>zAcceptPDU+4^EnsLib.DICOM.Adapter.TCP.1 -- logged as '-' number - @' Use .

Hi All, I am a Data Architect and am trying a method of deploying alter statements onto Cache DB.

My Data Modeling tool generates alters as this.. So question is if the Cache has a way to rename table? If so what is it?

ALTER TABLE <SchemaName>.GROUP_TYPE_NODES RENAME TO GROUP_TYPE_10082019140110000
;

This is giving error.

SQL Error [25] [37000]: [SQLCODE: <-25>:<Input encountered after end of query>]
[Location: <Prepare>]
[%msg: < Input (IDENTIFIER) encountered after end of query^ALTER TABLE xxx.GROUP_TYPE_NODES RENAME>]
 

Probably a simple question, but where do I find the list of Translate Tables?  The documentation wasn't clear.

Thank you,

I like to be able to call an "autohotkey" executable message box from within a running Cache routine executing as a jobbed routine. The autohotkey executable displays a small pop-up window with a message and an "OK" button .. and will time out in 10 seconds if the user does not press the OK button.

Although $ZF(-1,cmd) executes (where "cmd" contains a simple batch command e.g. @c:\autohotkey\warning.

Hello community,

Our organization is looking to expand our Coding Standards to be more in alignment with best practices.

I was wondering if the there are developers here that would not mind sharing any existing documents. Our scope would be this document be applicable to new hires learning Cache all the way up the chain.

Thanks in advance,

-SH

Hi-

I have a need to store a password in an object property of a User object.   

What would be best practice for data type assigned to the "Password" property and securing that password against prying eyes, both just browsing the global as well as via SQL?  Better yet, how can I prevent a specific property from being projected to SQL?

Thanks

Hello All, 

I connected the Cache from Power BI using ODBC connection. And I can able to view the tables but I could't able to view the data records. getting some error when I shoot on the table name. I couldn't trace what I'm missing. Please help me.

Error Message: "Value cannot be null. Parameter name: exceptionType"

Thanks,

Vikram