Certain data from IRIS in almost real time needs to join with SQL tables
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
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..
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.
The data is loaded into IRIS via JSON File (IRIS Production) and is consumed by SSRS Server via ODBC. Just checking to see if there is an alternative to this approach. Thanks
I am not sure if SSRS can handle JDBC connections.