Question Scott Roth · Mar 12 SQL Inbound Service write to internal Cache Table I have the need to query an external database and write the result set/snapshot to an internal %Persistent [ DdlAllowed ] table that I built. I have built inbound SQL Services before and write them externally to replace SSIS jobs, but how would querying a database via a Service and writing the data to an internal table work? Can I just take the inbound query structure and write it to the class file of the internal table in a DTL? If so, what would be the Target? Or does this need to be done within a BPL as a Code block? #ObjectScript #SQL #HealthShare #InterSystems IRIS for Health #Health Connect #InterSystems IRIS 0 1 0 24
Question Scott Roth · Jan 28 Default value (initial expression) in HL7 Field Epic had changed some of their logic on their Incoming Radiology Results which now require an Ordering Provider even though it is supposed to account for it within the Epic Interface settings. I was wondering if we are using a custom schema if there was a way to default a value into OBR:16 if it was not valued without having to modify all the DTL's for these Results. Is there a way to set this via the schema editor or in the background so we don't have to create/update DTL's or create a custom TCP Operation Class?? #HL7 #HealthShare #InterSystems IRIS for Health #Health Connect 0 1 0 39
Question Scott Roth · Aug 23, 2024 Returning a Response from a Business Process that is not the same Message Type Request I thought I knew how to return a Response from a Business Process back to the Source Config Name, but I guess not. I am working on a Proof of Concept, that the Request Message Class would determine a "Route" within a Business Process to make a FHIR call (search, read) to our External FHIR repository, and return back the HS.FHIR.DTL.vR4.Model.Resource.xxxxxxx as a Response to the Source Config Name. #DTL #FHIR #InterSystems IRIS for Health 0 0 0 79
Question Scott Roth · Aug 1, 2024 FHIR infostructure for those connecting to External FHIR Repository As I begin our adventure into using an External FHIR Repository, I wanted to see what opinions people have about a design Idea I was working on. I want to create a way that my Team has the ability to send a Message Type, and the system knows from that Message Type which FHIR queries to execute and return the Response back to the user, sort of like a FHIR Query Hub. Does this sound reasonable? #Business Operation #Business Process (BPL) #FHIR #ObjectScript #InterSystems IRIS for Health #Health Connect 0 0 0 65
Question Scott Roth · Jul 1, 2024 Best Practice Question - Connecting to REST API's outside of the network Up until recently, I have been toying around with REST/FHIR capabilities but only internally. Now I have a request to make REST API calls outside of our Network. I am using an RSA 4096 key, because Microsoft Active Directory Services which generates the signed certificate could not handle the Elliptical Key (ECC) when I put the request in. #API #FHIR #Interoperability #REST API #Security #SSL #HealthShare #InterSystems IRIS for Health #Health Connect 0 0 0 134
Question Scott Roth · May 9, 2024 Samples-FHIRStarter Questions I am trying to create my first call to our Epic FHIR Repository from Health Connect using Samples-FHIRStarter now that I have OAuth2.0 connection tested/working with our Epic Interconnect URL. When I take a patient example from our Epic environment and test it through Data.BPL.PatientRecordCollector within the Namespace, I keep getting a 404 - File or directory not found #FHIR #GitHub #REST API #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 131
Question Scott Roth · Feb 22, 2024 Staggered Start Script based on Queue Count Our 3M Computer Assisted Coding system goes down on a regular basis for updates, the Applications folks like us to Disable the Business Operations when this happens and start them back up when they page the on-call person. The Business Operations have to be started in a sequence to guarantee that all the ADT being sent it processed before we start sending everything else. #ObjectScript #Caché #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 167
Question Scott Roth · Feb 15, 2024 EnsLib.JavaGateway Not Stopping during Force Down Has anyone noticed that when IRIS is forced down that the EnsLib.JavaGateway.Services do not properly shut down and release the ports? While we can write a shell script to kill the processes at the OS level, I was wondering if anyone experienced this issue. We are working on our Mirroring setup/failover and had the team testing forcing the Primary down to make the Backup to become the Primary Server. When this happened and we failed back, IRIS could not restart the JavaGateway.Services because the ports were still in use. #Business Service #High Availability #Java #Mirroring #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 158
Question Scott Roth · Nov 7, 2023 Pulling in Global into Settings within the Management Portal We are moving away from Delegated Authentication in which I stored a username and password for our LDAP in a GLOBAL to be called by ZAUTHENTICATE. Is there a way to pull in that GLOBAL into the LDAP Configuration within the Managment Portal instead of having to manually enter it? There seems to be an issue with Copy/Paste that the password isn't being set correctly when I use Copy/Paste. Else I just export/import the LDAP Configuration from 1 server to another and manually update the Certificate to point to the correct file. Thanks Scott #LDAP #System Administration #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 147
Question Scott Roth · Apr 20, 2023 Security Advisor - Application Error I am trying to finish build for moving to IRIS HealthShare Health Connect 2022.1 from HealthShare Health Connect 2018.1.3. I am currently using Delegated Authentication using an AD group to match up to the Role in IRIS. The Role has access to everything but the HS Resources because we don't really use the HS Resources for anything. We are mainly using IRIS for the Interoperability Engine. #System Administration #Health Connect #InterSystems IRIS #InterSystems IRIS for Health 0 0 0 166
Question Scott Roth · Mar 28, 2023 Using JDBC Gateway to call External SQL Calls - Best Practices??? I am trying to pinpoint and troubleshoot an issue we have been seeing lately. We have several SQL Outbound Adapter Operations that are seeing issues trying to connect to our MS SQL Servers using the JDBC Gateway for calling insert, select, update, and stored procedure calls. #JDBC #SQL #System Administration #Caché #Ensemble 0 0 0 284