Question
· Jul 3
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 90
InterSystems Developer Community is a community of 19,538 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Hi Community!

We're super excited to invite you to the LinkedIn Live event dedicated to online learning!

🌐 Two Decades of Innovation in Learning and Development 🌐

📅 Thursday, May 30, 10 am ET | 4 pm CEST

🗣 Presenters:

https://www.youtube.com/embed/5iVApYu7YjM?si=Ae5NBCHdWSxhWewn
[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 1
0 72

Hi

I have a question about terminal, when I run a class from it that contains an error I get a report of error as I would expect, and then an apparently random three letter code is appended to the namespace name in the prompt, as shown below.

GMMHTIE>do ##class(temp.Nothing).What()

w !, tParisAnswer
^
<UNDEFINED>zWhat+23^temp.Nothing.1 *tParisAnswer
GMMHTIE 2d1>

Then, when I try to enter a command I get an error

0 4
0 88

It is probably somewhere in the doc. So hard to search. Hope InterSystems going to AI on their community/support data.

How to see a meaningful value in management portal - sql explorer. For instance
Class MySetting Extends %Persistent{
Property Name As %String;

Class MyObj Extends %Persistent{
Property Setting As MySetting;

0 1
0 91

I am attempting to make a FHIR call against the Epic Repository through Intersystems. I have setup a Service client per Create FHIR REST Client | InterSystems Developer Community | Business

but I have set it up using OAuth and HTTPS.

I have verified that the OAuth works by executing it manually via a Terminal to verify I get a response. Of course, when I do it is writing to the ISCLOG

0 4
0 87

Hey Community,

Play the new video on InterSystems Developers YouTube:

⏯ Building a FHIR Facade @ Global Summit 2023

https://www.youtube.com/embed/RWyfFWRThxU
[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
0 91

Hi Team,

I am trying to use the inbuilt class: EnsLib.HL7.Service.FileService to pass through an HL7 ADT message as a part of an HL7 to FHIR transformation. We have a client requirement, where we are receiving an NTE segment as a part of the ADT message. I am trying to map the NTE segment to an OBX Segment. I need to implement a counter for OBX segment whenever a NTE segment is found and map the NTE fields to the new OBX segment

How do I implement the counter for OBX?

Thanks

Santosh

0 1
0 90

I am exporting data from Cache using the SQL export wizard. This is on a docker image of Cache hosted on a Linux server.

I select my database, schema, and table, make sure that all columns are being exported, check other settings, and then finish the export.

All server settings look correct and permissions are rwe on the directory. I have tried various directories, including a system level directory. I tried creating the file before I do the export in case there was an issue with creating the files, and I also made sure the created files had rwe permisisons.

0 0
0 91

Hey Community,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in January 2024:

New Videos
№ Video Views
1 InterSystems FHIR and Digital Health Interoperability Contest 18933
2 Working with InterSystems IRIS Cloud SQL 2266
3 Accuracy of AI tools: requirements - human factor #shorts 133
4 OAuth 2,0 Fundamentals 125
5 Accuracy of AI tools: use-cases #shorts #ai #artificialintelligence #aitools 114
6 Ensuring patient safety when integrating AI tools to the workflow, #shorts 114
7 Accuracy of AI tools: validation #shorts 80
8 North West London Integrated Care System Go Live with Health Connect Cloud 65
9 Data Fabric Demystified - Patterns and Examples 64
10 Capturing High-Volume High-Frequency Clinical Data to Leverage in HealthShare Unified Care Record 61
11 Kick-off Webinar for FHIR and Digital Health Interoperability Contest 38
12 Accuracy of AI tools: requirements #shorts 31
13 Introduction to HL7 V2 Productions 29
14 InterSystems Terminal Aliases and How To Have It In Docker Environment 22
15 Health Harbour 19
16 Clinovera ISC contest 19
17 IRIS WHIZ HL7v2 Setup and Tutorial 13

0 0
0 91

There are a lot of great community articles regarding "vector search on IRIS", and samples in OpenExchange. Everytime I see these, I'm so excited to know that so many developers already try vectors on IRIS!

But if you've not tried "Vector Search on IRIS" yet, please give me one minute 😄 I create one IRIS class - and with only one IRIS class you can see how you put vector data in your IRIS database and how you compare these in your application.

Open Exchange app
3 0
2 89

I'm trying to use the EnsLib.SQL.Operation.GenericOperation component in a production to read a column from a Redshift table that is set up as VARCHAR(65535) and am getting the following error.

An error was received : ERROR #5023: Remote Gateway Error: JDBC Gateway getClob(0,1) errorRemote JDBC error: Cannot convert the column of type VARCHAR to requested type long..

1 5
0 84

I receive response from Business Operation(HTTP GET) as below :

<response>
<message_code>202</message_code>
<message_string>Success/message_string>
</response>

I am not able to read the "message_code" as response.message_code ?
is it because of underscore ?
Is there a way to read it ?

0 4
0 85

Could any one tell me, how the index works in cache db, Consider for example, I have a table called "Employee" and the fields as "EMPID, EMPNAME, EMPAGE" and I am having index for EMPID as IDX_EMPID and trying to get the record using the following query as

SELECT * FROM EMPLOYEE WHERE EMPID="005"

and the table data be like

EMPID EMPNAME EMPAGE

001 ABC 20

002 AAA 21

003 ABB 23

004 BBB 20

005 BDF 24

006 EEE 22

0 2
0 87

I use a swagger file and ##class(%REST.API).CreateApplication to create the rest api.

There is an interesting post: https://community.intersystems.com/post/download-file-rest-api-operation, but it is code, not a swagger configuration. disp.cls returns always a header content : application/json that of course fails as I am not always returning a json

I can not figure out what to put in swagger. Some examples I tried:

0 2
0 87