This post is intended to guide you through the new JSON capabilities that we introduced in Caché 2016.1. JSON has emerged to a serialization format used in many places. The web started it, but nowadays it is utilized everywhere. We've got plenty to cover, so let's get started.

Hi guys,

I have a customer trying to extract data from Hive. I've tried to use Data migration to migrate a table into IRIS with JDBC driver. But the migration task always fails as below

Then I tried to create a link table, the task fails too with the following error:

I've tried several ID combinations such as rowkey+userid, userid + datatime, the results are all errors caused by stream property. 

The source table are composed of only Hive string fields.I wonder how may I migrate Hive tables into IRIS. Thanks.

Caché  2018.1.1 and Ensemble 2018.1.1 maintenance releases are now available!   

Full product installation kits can be downloaded from the WRC Software Distribution site.

For information about the corrections in this release, refer to the release notes.

This release is supported on the same platforms as Caché and Ensemble 2018.1.  You can see details in this Supported Platforms document.

I created the Process to extract the required data from ADT message to a Dynamic Object. I wanted to send the JSON stream to EnsLib.File.PassthroughOperation operation and generate a file with the content of JSON stream.

Here are the codes for Process:

set oMetadata = ... /// metadata is from ADT message which is dynamic object

set jsonRequest = ##class(%ZEN.Auxiliary.jsonProvider).%ObjectToJSON(oMetadata)
set tSC = ..SendRequestAsync(..JSONOperation,jsonRequest,0,,..MetadataContext)  /// send the jsonRequest to operation

Hi Team,

              I am interesting to learn InterSystems IRIS data platform. How to I download and install the InterSystems IRIS instance and sandbox. So Please give the instruction for how to I use it.

Thanks & Regards,

Ponnumani G.

Hi Community!

New video is already on InterSystems Developers YouTube:

API Design for REST

I connected from InterSystems Cache to devices connected via RS232 (commonly known as COM-port).

Can the same be done with devices connected via RS422/RS485 interfaces?

Hello,

I am using a French version of Ensemble, so the terminologies will not be properly translated.

What does "_BusinessDuplex:????.?????????" mean in the connector names for the queue?

There are situations where we want to provide immediate feed back to inbound Web Service that a particular business operation is not running (status <> "running").  We don't even want to queue up the message.  We just want the webservice to respond with an error stating the business operation is down.

Hi,

Is there any COS command could kill all the globals given the namespace?

Thanks.

I am just curious if someone has used this service to send Alert emails through AWS / Ensemble

I have verified 2 email ids - One to send. One to receive

Have also configured an access key for the email smtp server and added the credential to ensemble

but I get this error

ERROR #6033: Error response to SMTP MAIL FROM: 530 Authentication required.

email-smtp.us-east-1.amazonaws.com

25

So my first opinion is the authentication is not happening via the credentials settings. It needs to be passed in a different way

If anyone has done it before. Do let me know

It's Ok I figured it out.

Hi Community!

New Badges're already on Global Masters Advocacy Hub! 

We're happy to announce that this year we again introduced three annual badges on Global Masters Advocacy Hub to let you remember how much you contributed to Developer Community in 2018. Here they are:

✔ DC Best-Selling Author 2018
✔ DC Expert 2018
✔ DC Opinion Leader 2018

Let's take a closer look at the DC Wall of Fame 2018 and greet everyone with big applause! 

Hi everybody,

I am looking for a way to detimerine if a certain namespace is ensemble enabled. I´ve seen such a solution somewhere in the past but can´t find it anymore. Is there a simplistic api around for that?

My second question is in context of log some information to the console log file with a certain error level. Also, I´ve seen this in the past and can´t find it agian. I guess there was some kind of simple api to use for this.

Thank you for your help.

best regards,

sebastian

Is there a public bug tracker?  It would be nice to be able to search for existing issues before posting or get the status of an issue.  I feel like I'm cluttering the forums.

Can someone tell me if intersystems-ru/deepsee-sysmon-dashboards is developed for a specific version of Ensemble? Looks like it could be useful to my group but we aren't upgrading till later this year and we are on 2015.2.2.

Thanks

Scott

We are currently using Ensemble on AIX. We are on 2015.2.2. If I install Field Test on a windows desktop, is it possible that I can import the Cache.dat from my AIX server, so I can do some Proof of Concept development?

Thanks

Scott

Is there any good documentation/tutorials on creating gateways in both directions between FHIR and Hl7v2 (for Health Connect)?

the scenarios I'm most interested in

1. Client application sends a FHIR demographic query to Health Connect - and the interface has to convert this to Hl7v2 QBP^Q11 message to the PAS.

2. Health connect sends a PDF document (from a file or HL7v2 interface) to an EPR over FHIR.

Thanks

Stephen

UPDATE

We are using Health Connect  15.03 - Cache for Windows (x86-64) 2017.2.1 (Build 801U) Wed Dec 6 2017 09:07:51 EST [HealthShare Modules:Core:15.03.9901 + Linkage Engine:15.03.9901]

Hi Community!

It's time to announce the best articles on InterSystems Data Platforms you published in 2018!

And here are three best articles for the year (criteria is the number of views):

First place: K-Means clustering of the Iris Dataset, by Niyaz Khafizov  1564

Second place: Continuous Delivery of your InterSystems solution using GitLab - Part I: Git, by Eduard Lebedyuk  1206

Third place: Replacing ZEN - Part 1 - Introduction, by Peter Cooper  933

Congrats to authors!

And what are the best articles by InterSystems Data Platforms?

See below

Hello,

I have some beginner questions as I am working through the InterSystems Cache learning path:

- Where I work, we us Cache, but we often learning about and train on MUMPS.  No one really talks about or mentions MUMPS here, but my understanding is that ObjectScript is basically MUMPS plus whatever new things InterSystems put on top of it.  Is that a fair assessment?

- The training online often refers to IRIS.  We don't use IRIS, but we use globals to store data.  I suppose I'm just confused on the difference between Cache, Zen, IRIS and other products as they all seem to do similar things.  

Has anyone called any outside Javascript code from inside their class files? I asked a long time ago if there was a way to manipulate an image within Cache Object Script, and since Cache doesn't have any image libraries its not really possible. However I have found Javascript to resize an image and wonder how hard it would be to mesh the two together.

Can anyone share any examples?

Thanks

Scott

Hi Community!

Want to share with you what do we in a new December release on Developer Community!

In short, we have three new features:

• Groups combined with tags as Group tags,
• Social media sharing enhancements,
• enhancements for moderation.

See the details below.

Hi -

I'm wondering if anyone has coded up a means to create an extension for a %Persistent class from a base class to a sub-class without making a ton of assumptions about the Global structure. I'm trying to create a new "extension" record that would have the same ID as the Base Class 

Class BaseRecord Extends %Persistent

and

Class SubRecord Extends BaseRecord

where I would have an instance of a "BaseRecord" and I want to turn it into a "SubRecord" instance and have all of the existing references to the BaseRecord survive.

Hi,

Is it possible to implement Drag and Drop with the TablePane component?

The following post outlines an architectural design of intermediate complexity for DeepSee. As in the previous example, this implementation includes separate databases for storing the DeepSee cache, DeepSee implementation and settings. This post introduces two new databases: the first to store the globals needed for synchronization, the second to store fact tables and indices.

Hi Everyone!

As you know Advent of Code 2018 is in full swing! Till the 25th of December 2018 each day 2 programming problems to sharpen your programming skills! 

And now we're ready to present great prizes for Members of InterSystems Global Masters Advocate Hub!

There's a new and exciting enhancement to QEWD that has just been released - it's an additional layer of abstraction known as QEWD-Up.  QEWD-Up hides away all the mechanics of QEWD itself, allowing you to focus on just your REST APIs and the code that implements them.

Additionally, and importantly, QEWD-Up simplifies the maintenance of your REST APIs, allowing you (and others) to quickly and easily understand their life-cycle and implementation.

QEWD-Up supports both monolithic application designs and MicroService-based architectures where APIs are broken down by, for example, functional role.

Example: I have a list of tags that I have to find, and a string with these and other tags separated by commas. How to find the desired tags in the string optimally?

Hi Community!

This is a digest of the Developer Community postings in December 2018.

Most viewed

Win Advent of Code 2018 and Get a Ticket to InterSystems Global Summit 2019!  504

Review InterSystems IRIS or Caché and get two $25 Visa Cards!  163

How are stars counted? How InterSystems Caché eXTreme is used in Gaia  158

How to Create Namespace Programmatically in Terminal  153

Calling Javascript within Cache Object Script  136

cache basics  130

QEWD-Up: A New, Fast-track way to create REST APIs  125

Just for Fun. John Conway's Game of Life  114

Atelier 1.3 Update Released  109

How to get files from FTP Server  108

Source control with a shared development instance  85

AnalyzeThis ? Quick start into InterSystems BI  73

Adding Java to a IRIS Docker image  69

Some tips for beginners about using Terminal scripts  55

Get a list of Ensemble Lookup Tables and Schema documents in the current namespace  49

Issues on Mixed Mirrors of IRIS vs. Caché  43

Hi Community!

On behalf of Developer Community and Global Masters team, I wish you a Happy New Year 2019!

2018 was another great year for InterSystems Developer Community - thanks to you!

Here are a few highlights:

This little guide would help you start running Ensemble REST services in no time.