InterSystems HealthShare is a healthcare informatics platform for hospitals, integrated delivery networks (IDNs) and regional and national health information exchanges (HIE). HealthShare includes health information exchange, data aggregation, workflow, text analysis, and analytics technology.
We connect to MS SQL Databases using the Microsoft JDBC Driver 12.2 using the following URL
jdbc:sqlserver://<server>:<port>;database=<database name>;trustServerCertificate=true;integratedSecurity=true;authenticationScheme=NTLM;domain=osumc;authentication=NotSpecified
They want to migrate the databases to the Azure Cloud and in doing so we need the Authentication to change to go through Microsoft Entra.
Not sure there are many that connect to MS SQL to execute queries, stored procedures, etc, but our Healthsystem has many different MS SQL based databases we use within the Interoperability environment for various reasons.
With the push to moving from on-prem to the Cloud we ran into some difficulties with our SQL Gateway connections and knowing how to config them to use Microsoft Entra for Active Directory Authentication.
There are many articles out on the web, but there was not one that could give us the full answer to what we needed to do, and Microsoft wasn’t much help.
Hi, I am coming unstuck with a current mapping from HL7 to XML using the DTL editor with an XML schema (imported by XSD).
My output keeps prefixing the elements with "xsd_2" despite this not being defined in the targetnamespace within my XSD file.
Would anyone have any idea as to where this is creeping in? Any advice would be greatly appreciated.
My XSD namespace etc are setup as follows:
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
targetNamespace="http://voicetechnologies.co.uk/winvoice/importation"
xmlns="http://voicetechnologies.co.
Hi experts, please, do you know cause this errors in cconsole?
I'd like know what can I investigate.
01/16/25-18:25:40:081 (11368) 0 Job failed in StartDeepSeeAgents^%SYS.
I'm working on some code that would benefit from being able to see whether or not a project file has been saved in Studio.
I can see when I make changes, that the project name has an asterisk added to it:.png)
In searching for it, however, I haven't been able to find any methods or calls to access the property/check that controls that asterisk.
My question is whether anyone out there knows if that is accessible and if so then how can it be accessed.
I'd like to add a check in my code that enforces that the project file must be saved prior to proceeding with the intended action.
Hello everyone! This is my first post into the developer community and one that I hope is fairly simple to answer. In our environment we currently have 3 different Test environments for testing before migrating code to our Prod environment. Currently we are working on establishing a source control method using Git in house which has been a bit of a struggle. We have also had developers that had used different test and migration methods in the past which has caused some issues with keeping the different test environment in sync.
Hey Community,
Enjoy the new video on InterSystems Developers YouTube:
Hi All
I have created a SOAP Service from a tutorial, using sample code, as follows:
Class Hospital.MyService Extends EnsLib.SOAP.Service
{
/// For this business service, ADAPTER should be "" so that we use the normal SOAP processing
Parameter ADAPTER;
Parameter SERVICENAME = "MyService";
Parameter NAMESPACE = "http://www.myhospital.org";
Parameter USECLASSNAMESPACES = 1;
Method SubmitMessage(pRequest As Hospital.SoapRequest) As Hospital.SOAPResponse [ WebMethod ]
{
// Do something with pRequest
//set sc= .While working with GET request I encountered this situation where FHIR Server return a responseStatusHTTP "HTTP/1.1 200 200" instead of "HTTP/1.1 200 OK" (as highlighted in the attached screenshot).
Although the response code seems valid, these bundles have a total value of 0.
Could anyone clarify what "200 200" signifies in this context? Is there an issue with my setup, or does this indicate a specific condition related to the empty bundle search?
Thank you in advance for your help!
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.
Products Affected
I am hoping for some guidance.
I am new to creating a new chart in Trakcare for use with Clinical Viewer. My organization only has LDAP users, (we don't have the ability to use local users), that dictate what role/group a user is in, they are all the same across our Prod, Test, and Dev environments.
I need to customize a chart for our end users. BUT the how-to's all talk about creating a custom role for the new chart, which if I do this I would have to be added to this role/group which could cause issues with my ability to work in Prod and Test.
In tracking down some of our Orphaned message issues, I was wondering if setting our EnsLib.SQL.Snapshot variable equal to "" was the same as calling the .Clean() method on EnsLib.SQL.Snapshot? Are they the same?
should I be possibly using ##class(EnsLib.SQL.Snapshot).%Delete() instead?
I'm currenlty searching the developers coummnity , but thought I asked this question while I search. How can I use the task schedulrer to purge backups? Do i have to create my own class? Examples on doing this?
Hy Friends,
I have a little problem, I need to diplay the data based on input status (first time and after)
this is the data:
.png)
and this what I need to display
.png)
the notes become new because it is the first time that the data has been inputed, and it will become old if we have the data before (2nd data, 3rd data the notes will become old).
I've try to use SubQuery (with LAG Script also) but it doesn't works, because it will give a notes Old even it's a New Data
Does anyone could help me ?
Thank You
Best Regards,
Steven Henry
I'm attempting to build a fairly complicated object graph, with nested objects and collections, in order to create a FHIR bundle.
In its most basic form there is a <bundle></bundle> element that represents the root, and there can be a number of nested <entry></entry> child elements.
I'm attempting to represent this as such:
class Bundle (%RegisteredObject, %XML.Adaptor)
{
Property Entries As List Of Entry;
}The problem is when this is projected it nests each Entry object within an Entries container, which makes sense but I don't want this.
Hello,
is it possible to kill/suppress hl7 message in the DTL (data transformation).
in cloverleaf, it is common practice to check the value in message, for example pv1:7.9. if the value is certain word(assigning authority) then send the message over to destination, if it is not, kill the message
how would this be done in InterSystems ? does that need to be done in the rule instead? or can it be done in the data transformation? if it can be done in data transformation, how can it be done?
Thanks
Hi,
I'm trying to create a user with access to the HS namespaces management portal.
I'm having trouble identifying the correct resource to assign to the user. I'm testing various resources, but every time I go to the HS management section, a blank page appears, and the Home button disappears.
.png)
.png)
Does anyone know the correct resource to assign? (I've already granted Read permissions to the Namespace databases)
Thank you!
Hi!
I'm trying to set up a Clinical Viewer demo env with HealthShare 2024.2.
I've done the standard installation following the doc :
Everything works until I get to the point where I have to enable federated SSO (UCR demo - Federated SSO). Once it is activated, I can no longer access the instance through the portal, and the browser displays the following error:.png)
Checking the messages.log, I see that every time I try to enable federated SSO and access the portal, I encounter the following error:
12/24/24-10:51:55:639 (98515) 2 [Utility.
I have a query that returns around 6000 records that I need to go through and update another MS SQL Table. I would like to execute this once a day. How do you set MaxRowsToGet on a EnsLib.SQL.InboundAdapter service?
Thanks
Scott
Hello,
I was just trying to get to the bottom of a TLS config - we have an interface with a TLS config that has had 'Server certificate verification' set to 'On', however the cert file specified either did not exist or contained a cert that was expired.
Does anyone know what the behavior is for this typically? I would expect this to not allow traffic on the interface, however this has been working fine for a few years now with an invalid cert specified for 'Server certificate verification' and set to 'On'.
.png)
Hi!
Suppose I have full access to InterSystems IRIS database instance A and want to export a consistent part of the data and import it into another InterSystems IRIS instance B. Classes are equal.
What are the most general and convenient options for me?
TIA!
Hello everyone,
I want to share my experience configuring an IIS server to enable secure HTTPs access to HealthShare/HealthConnect.
After installing the “WebServerGateway” and completing the initial setup, I encountered a few issues. Specifically, when trying to log into HealthConnect using HTTPS, the logo didn’t appear, and clicking any buttons didn’t trigger any response. See screenshot below:
Below is a step-by-step guide to resolve the current issue, as well as another issue I encountered with accessing the Rule Editor.
Hi everyone,
I'm looking for a tool that can be used as a base to create an interface that allows a non-technical user to easily forward messages.
The idea is that the user can find an already sent HL7 message and forward it by modifying specific fields of the message without needing any technical knowledge.
An example would be something similar to the Ensemble search engine, but with a less technical and much more intuitive approach and that only allows changing 1 or 2 fields.
Is there a solution in the community or something that I can adapt for this purpose?
I am attempting to create a Foreign Server/Table so I can pull some information in from MS SQL server via JDBC connection, but as soon as I create the Server/Table and logout the Foreign Server disappears.
CREATE FOREIGN SERVER Epic.Clarity
FOREIGN DATA WRAPPER JDBC CONNECTION 'MS-EpicClarity'logout, then run
.png)
the documentation - Defining Foreign Tables | Using InterSystems SQL | InterSystems IRIS Data Platform 2024.3 mentions "A user that creates a foreign server must have the %MANAGE_FOREIGN_SERVER administrative privilege" but I am not finding that security setting to give to my role.
Monitor incremental changes in the database through scheduled tasks, display change trends through charts, set alarm thresholds, and write information to messages.log
Docker or ZPMMake sure you have git and Docker desktop installed.
git clone https://github.com/Sara771dev/Database-Size-Monitoring.Hi, Community!
Great news for HealthShare® customers! You can use single sign-on (SSO) to access your HealthShare apps more efficiently.
🔒Configuring Federated SSO in HealthShare (video, 11m)
Using SSO, you can access all your HealthShare apps at once, including HealthShare® Clinical Viewer and Care Community.
Please note- the resource should have expertise working in CCDA/FHIR implementation along with IRIS development experience.
IRIS for Health CCDA/FHIR IRIS developer
Hello All,
I am facing an issue where the vendor seems to be sending two structures of JSON messages, but only one of them seems to work in my code.
I need help in allowing both the JSON structures to parse into the engine.
Working Example:
{
"data":
{
"idNumbers":
[
{
"type":"322","number":"123456"
}
]
,"0":
{
"con_type":"210"
}
}
,"meta":
{
"secret_key":"","origin_url":"url.co.
Hello,
We noticed from the integrity logs that some of the namespaces in our integration engine are using large amount of space ( ~380GB ) for the global ^EnsHL7.Segment.
We have culling implemented for large globals like MessageHeader and MessageBody.
Is it a standard process to implement culling for ^EnsHL7.Segment global and any idea about what will be the impact of adding culling to this global?