Syndicate content 0  
 
All time

Hi Community!

Here is a digest of the Developer Community postings in January 2019.

Most viewed

VSCode extension for InterSystems ObjectScript update 319

Free IRIS Community Edition in AWS 265

InterSystems IRIS 2019.1 preview 203

Seeking field testers for an upcoming VSCode extension from George James Software 185

How to start development 173

Caché and Ensemble 2018.1.1 available 162

n00b questions 145

Save the Date — InterSystems Benelux Symposium 2019 145

IRIS Quarterly Container only releases and Studio 141

Collaboration with Git in Atelier 140

The One Query Performance Trick You NEED to Know? Tune Table! 132

Explore Text Data with InterSystems iKnow Entity Browser 126

Should you trust Codd or your objects? 112

SQL Performance Resources 106

Perforce Example of Shared Development with Atelier 105

Top 5 takeaways from 2018 95

On a csp page, when you return %Boolean from a cache script into a javascript script, you're getting a string, not a boolean 89

Iterate over dynamic object 52

Using PMML models in your Business Processes 51

0 0
0 175
Question
· Jul 3, 2024
Polybase and IRIS

Hi all, I am trying to use Polybase in SQL Server 2019 to access an external Cache/IRIS Database. I have followed the initial steps of enabling Polybase, creating a Database, DB scoped credential and then an External Data Source. These steps have not caused any issues and appear to be successful, I am using the same DSN we use for a Linked Server connection that works normally. I am running into an Error when trying to Create an External Table. The error is a generic Native Code 469 "Driver Not Capable".

0 2
0 172

Get your hands on our technology with On-Demand Experience Labs available now through November 6th. Each lab is paired with an office hour session scheduled for this week. Learn more about how you can get hands-on with our technology.

Join the office hours to get answers your questions about the labs, talk about how the technology fits into your environment, and discuss implementation. Sign up for the Office Hours/On-Demand Experience Labs today. The labs have gotten great reviews so far!

0 0
0 174

Hi Developers:

There's lots of news in this month's Developments newsletter for customers and partners. InterSystems made the Gartner Leaders Quadrant and ranked high in other analyst reports. There have been several major product releases. And the recent "AI Robotization (Python, R, Interoperability) for InterSystems IRIS"(Anton Umnikov, Eduard Lebedyuk, and Sergey Lukyanchikov) is now available on demand.

You can download the latest issue from our landing page.

0 0
0 174

Hi Community!

Here is a digest of the Developer Community postings in March 2019.

Most viewed

CachéQuality for VSCode now available 364

Studio debugger since 2018.1.1 149

Job Opportunity - Relocate from Europe to UK 137

InterSystems IRIS version 2019.1 released 127

Tar compress tool in ObjectScript 125

A Tutorial On WebSockets 122

Embedded SQL vs ObjectScript SQL. What do you prefer and why? 121

A Deep Learning Demo Kit with Python3 Binding to HealthShare (Part I) 118

Side Effects of Quit and Return Commands with $Increment, or "I.E.Repin. Unexpected..." 117

String to date 116

Behind the scene of isc-tar project 100

Using Docker with your InterSystems IRIS development repository 99

Global Data converted to CSV file 87

CSP: Dynamically Generated Table 79

Behind the scene of isc-tar project and story about Continuous Integration using Github Actions 66

Run A Deep Learning Demo with Python3 Binding to HealthShare (Part II) 62

Most voted

InterSystems Partnertag Österreich 2019 7

Adopted Bitmaps example now on Open Exchange 7

ObjectScript error handling snippets 7

Tar compress tool in ObjectScript 6

InterSystems DACH Symposium 2019 6

Synchronize Data with DSTIME 6

A Tutorial On WebSockets 4

CachéQuality for VSCode now available 3

A Deep Learning Demo Kit with Python3 Binding to HealthShare (Part I) 3

InterSystems IRIS version 2019.1 released 3

Most commented

CachéQuality for VSCode now available 36

HL7 message import to sql server 16

Studio debugger since 2018.1.1 12

Rule to validate SQL syntaxis 12

No 'Access-Control-Allow-Origin' header issue with Cors 11

Cache docker image 9

Creating multiple Record Map Records from a single HL7 message 8

Quick way to check if an SSL/TLS configuration name is valid? 7

Sending Messages on the Top of Queue 7

Ensemble to Spring Boot Java app using RabbitMQ 6

Top 10 Authors to Follow by Views

Dmitry Maslennikov, Posts, 291

Zhong Li, Posts, 180

Lily Taub, Posts, 122

Alexey Maslov, Posts, 117

Evgeny Shvarov, Posts, 99

Ponnumani Gurusamy, Posts, 87

Robert Cemper, Posts, 85

Gevorg Arutunyan, Posts, 79

Pravin Barton, Posts, 61

Stuart Byrne, Posts, 40

Top 10 Experts to Follow

Eduard Lebedyuk, Answers, +8

Aviel Klausner, Answers, +7

Alexander Koblov, Answers, +4

Kyle Baxter, Answers, +4

Vitaliy Serdtsev, Answers, +4

Jeffrey Drumm, Answers, +4

David Van De Griek, Answers, +3

Stephen Canzano, Answers, +3

Dmitry Maslennikov, Answers, +2

Robert Cemper, Answers, +2

0 0
0 174

From the previous article, we identified some issues when working with JSON in SQL.

IRIS offers a dedicated feature for handling JSON documents, called DocDB.

InterSystems IRIS® data platform DocDB is a facility for storing and retrieving database data. It is compatible with, but separate from, traditional SQL table and field (class and property) data storage and retrieval. It is based on JSON (JavaScript Object Notation) which provides support for web-based data exchange. InterSystems IRIS provides support for developing DocDB databases and applications in REST and in ObjectScript, as well as providing SQL support for creating or querying DocDB data.

By its nature, InterSystems IRIS Document Database is a schema-less data structure. That means that each document has its own structure, which may differ from other documents in the same database. This has several benefits when compared with SQL, which requires a pre-defined data structure.

The word “document” is used here as a specific industry-wide technical term, as a dynamic data storage structure. “Document”, as used in DocDB, should not be confused with a text document, or with documentation.

Let's explore how DocDB can help store JSON in the database and integrate it into projects that rely solely on xDBC protocols.

18 1
1 153

Hi Community,

Watch this video to see how HL7® FHIR® Implementation Guides allow you to restrict or extend APIs, resources, and terminologies:

⏯ What are HL7 FHIR Implementation Guides

https://www.youtube.com/embed/E9oRde9fHGE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
1 173

I am able to capture two values in two separate contexts in the BPL. One through an API call and another by looking at the contents of PV1:7. These are context.Prov and context.ProvName. I am checking to see if the values contained in the contexts are the same and if yes process further and if not stop.

In the IF statement I tried the below but none worked. Can someone please tell me what I am doing wrong. The trace does show that they are the same value so that's not it.

1. context.Prov = context.ProvName

2. "context.Prov" = "context.ProvName" and

0 4
0 169
Article
· Mar 21, 2022 2m read
Reviews on Open Exchange - March 2022

If one of your packages on OEX receives a review you get notified by OEX only own YOUR package.
The rating reflects the experience of the reviewer with the status found at the time of review.
It is kind of a snapshot and might have changed meanwhile.
So if you did a major change and expect a changed review just let me know.
Reviews by other members of the community are marked by * in the last column

2 0
0 173

Hi Community,

New video is already on InterSystems Developers YouTube:

⏯ Fast & Efficient Provisioning & Testing with InterSystems Cloud Manager

https://www.youtube.com/embed/psux9D5PqGs
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 173