Certain data from IRIS in almost real time needs to join with SQL tables

Question

Question

vj irisuser · Jul 3

We have a requirement where in certain data from IRIS in almost real time has to join with SQL tables and we are trying to avoid linked servers.

Is there a way to achieve this without having to go through ODBC?

Product version: IRIS 2023.1

$ZV: IRIS for Windows (x86-64) 2023.1.1 (Build 380U) Fri Jul 7 2023 23:43:12 EDT

Discussion (2)2

Log in or sign up to continue

score 0 · Answer 1 · 2024-07-03T02:50:24-04:00

Pls be more precise:
- where do your data come from and how?
- where do you expect to store them ?
- what do you mean by "linked servers" ?
NO ODBC: in general in IRIS almost every table can be accessed also as object..

score 1 · Answer 2 · 2024-07-03T07:48:07-04:00

Robert is correct, more detail is needed. However, as an example, we take HL7 messages and using specific structure classes to match stored procedures, we send calls to an EnsLib.SQL.OutboundAdapter using JDBC to update, insert, and query MS SQL.