All time
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 195
InterSystems Developer Community is a community of 25,609 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

Hi Community,

Watch this video to learn about the Monitoring and Alerting Capabilities of InterSystems IRIS.

🗣 Presenter: @Mark Bolinsky, Principal Technology Architect, InterSystems

This demo was prepared for one of our past online developer roundtables. We encourage you to ask your specific questions about this topic in the comments section, and we will invite our experts to answer them!

https://www.youtube.com/embed/h3HeYWlpQhU
[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]

Useful Links:

3 0
1 197
Article
· Feb 2, 2024 2m read
Fhir-HepatitisC-Predict application

Hi Community

This document mainly enriches the content of the previous article and introduces the use of the application.

Perhaps you have already read the previous article, but I still want to say,
After completing the initialization operation (including model creation and training), the Fhir HepatitisC Predict application then predicts HepatitisC

1 0
0 197

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 193

Hi Developers,

It's time to announce the Winners for July 2021! Please welcome our awesome Global Masters Heroes!

The storm of applause goes to these developers and their great contribution to DC in July 2021:

🥇 @Muhammad Waseem, HIS Team Lead, International Medical Center, Jeddah, Saudi Arabia

🥈 @Robert Cemper, ex Senior Sales Engineer from InterSystems, Austria

🥉 @Eduard Lebedyuk, Sales Engineer, InterSystems Corporation, Moscow, Russia

Learn more about the competition and our awesome winners below.

4 0
0 197

Hey everyone,

We've made a video tutorial for an easy start on InterSystems Partner Directory:

How to list a company on InterSystems Partner Directory

https://www.youtube.com/embed/WaDUc5dSHhQ
[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]

4 0
0 197

When I'm asked questions about SQL, I like Intersystems staff at the WRC, generally ask about the Query Plan. My feeling is that even before you run a query you should examine the results of Show Plan to confirm that the code is going to give me the results in the manner I would expect. If I expect it to leverage an index and I see that it is not then I go back and look at what I might have done incorrectly and try to re-write the query to get the index behavior I'm looking for. To that end, there's a poll below to ask you if think moving the Show Plan button as the first button would be

0 0
0 197
  1. I like the Application Error Log functionality a lot. However, it becomes time consuming to inspect it date by date and directory by directory on a multidirectory server. Ideally, I would use an existing error class to write a custom error report by date, selected namespaces, etc. Does such a system class actually exist? Not that I found. The detail level on the screenshot below is enough.
0 10
0 186

InterSystems has corrected a defect that causes invalid database and journal records to be introduced when using a specific $LIST syntax. The likelihood of encountering this defect is very low but the operational impacts can be significant.

3 0
0 196

Intersystems provides External language server connections for various languages which,
from a development perspective, is great as I can keep my application code separate but still interact with the IRIS kernel.

It becomes more complex though if you are using Interoperability etc where you might end up with some code in IRIS and some code in another language.

What would be great is having an IRIS to IRIS language server where the application code and stay IRIS based but separate from the database?

0 5
0 191

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems IRIS Cloud SQL and IntegratedML Contest – a great opportunity to have a discussion with the InterSystems Experts team as well as our contestants.

Winners' demo included!

Date & Time: Thursday, April 27, 12 pm EDT | 6 pm CEST

https://www.youtube.com/embed/rXQtHFCYMWk
[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]

1 0
0 196
Question
· Apr 17, 2023
Find a specific column in a dataCombo

Hello,

I've the below datacombo definition and when selecting an item from it and make this call:

var component=zen("Component").getProperty("value");

I would get the ID (first column) which is what I'm looking for

0 0
0 196

Hello,

Thank you for reading this question, and thank you for your time and replies.

I was wondering which ways, tools, mechanisms, or vias would you recommend to teach to kids, teens, adults, being your sons / daughters or not; your passion or likelihood for programming and computers?

I know there are some programming free games like the following ones:

https://seshoumara.itch.io/the-stack-machine

1 1
1 195

Hey Developers,

Learn about new features in the InterSystems HealthShare Health Insight 2020.1 and 2020.2 releases and plans for future releases:

New & Next: Deliver actionable intelligence with HealthShare Health Insight

https://www.youtube.com/embed/m2vxVxR-tQc
[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 196

Hi Developers,

Enjoy watching this new video presented by @Evgeny Shvarov:

Package First Development Approach with InterSystems IRIS and ZPM

https://www.youtube.com/embed/havPyPbUj1I
[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]

4 0
0 196

Hi Developers!

This is the digest of new solutions and applications submitted to InterSystems OpenExchange in February 2020!

New applications in February 2020

EXCEL SUDOKU by alex kosinets

Sudoku game implementation in Excel using InterSystems IRIS as a server

RESTForms2 by Henry Hamon Pereira

RESTForms2 is a framework to create the REST API for InterSystems IRIS persistent objects automatically

FirstLook-Globals by Evgeny Shvarov

Firstlook example of InterSystems Globals

IRIS Interoperability Message Viewer by Henrique Gonçalves Dias

A new approach for the Interoperability Message Viewer

iKnow by Benjamin De Boe

The iKnow Natural Language Processing technology was originally developed in Belgium and then acquired by InterSystems in 2010. In February 2020, InterSystems published the technology to open source, expanding the possible use cases for it beyond embedded use from the InterSystems IRIS Data Platform. iKnow is open to community contributions to enhance the engine, language models and interfaces for use in-text exploration, information extraction, and machine learning use cases.

0 0
0 196
Question
· Apr 18, 2019
Importing a role

What is the process in importing a role from one server to another server?

Let's say Server A is our main server that we maintain all of our resources / roles / users. We would like to get these over to Server B, Server C, Server D, etc.

It looks like when we import, there are tables and resources left in the destination servers that are not in the source server. It looks like whatever was in the destination server that was not part of the source server was not deleted from the import.

0 2
0 194

Presenter: Paul Dayan
Task: Upgrade with minimal downtime
Approach: Provide examples of planning minimal-downtime upgrades from a variety of starting scenarios

When upgrading Caché, Ensemble or your application on your business-critical system, you want zero or minimum downtime. This session explores the problems and options when upgrading, and how mirroring can reduce or eliminate business disruption, with practical steps and a demonstration.

Content related to this session, including slides, video and additional learning content can be found here.

0 0
0 196

Dynamic Entities (objects and arrays) in IRIS are incredibly useful in situations where you are having to transform JSON data into an Object Model for storage to the database, such as in REST API endpoints hosted within IRIS. This is because these dynamic objects and arrays can easily serve as a point of conversion from one data structure to the other.

Dynamic Objects

Dynamic Objects are very similar to the standard ObjectScript object model you get when you create a new instance of a class object, but with some key differences:

4 1
3 175

Hi, I am unsure how to remove this restriction; when I am performing dynamic SQL using ##class(%SQL.Statement).%ExecDirectNoPriv(, .query, args...)

It works fine, but the moment I add specific properties from the persistent class I am performing the select on into the WHERE clause, I get: ERROR #5540: SQLCODE: -99 Message: User UnknownUser is not privileged for the operation. Despite using %ExecDirectNoPriv, I've tried with prepared statement as well, exact same situation.

0 5
0 190