Question Joshua Wigley · Jun 9

What is the best approach to insert data to an external SQL database?

Hey All!

I wanted to reach out and get some advice on the best way to interact with a external SQL database, as I'm finding the documentation quite confusing to follow. I'm new to using SQL within InterSystem, and I want to make sure I'm following the best practices.

In essence, what I am trying to achieve, is extracting certain values from a HL7 message and then insert those message field values into an external database. The ODBC, DSN and Credentials details are all setup and working correctly.

#Health Connect #InterSystems IRIS #Business Operation #HL7 #SQL
5
0 96
Question Joshua Wigley · Jul 3, 2024

Why does the Rule Editor display a sad face?

Hello,

I have a slight issue that's causing me some inconvenience when using the rule editor within Microsoft Edge (Version 126.0.2592.81).

Whenever I try to load up any ruleset, the ruleset displays an unhappy face like this:

This has only recently started, when opening up the rule editor in another browser e.g. Chrome, the problem disappears.

I've tried to remedy the situation by resetting Edge, Updating Edge Version, Clearing Cache/Cookies etc. but nothing seems to fix it.

#InterSystems IRIS #InterSystems IRIS for Health #Business Rules
5
1 413
Question Joshua Wigley · Feb 15, 2024

Can a TCP Operation use a DNS name in the IP address field?

Hello,

I am trying to connect to a web socket endpoint that potentially has a number of different IP addresses for load balancing purposes. 

I have been asked whether it's possible to use a DNS name to resolve the IP address rather than statically assigning one specific IP address in the TCP Operation.

If it's not possible to resolve on a DNS name directly on the TCP operation, then I wondered whether it was possible to provide multiple IP addresses.

In the documentation, it mentions that I can provide a value like this "!192.168.1.1, 192.168.1.2, 192.168.1.

#Health Connect #InterSystems IRIS
2
0 241