How to integrate InterSystems IRIS SQL queries with external applications like Java.
Hi all
We are looking into automating worklist report SQL queries that we run manually on InterSystems IRIS platform but we would like to have them run on a Java application.
This means we must have a way to get our java application to talk to IRIS in order for those queries to run. Please advise on how to go about this?
Regards,
Ephraim Malane
Product version: IRIS 2020.2
$ZV: `HealthShare 2020.2 [HealthShare Modules: Active Analytics:20.0.8620 + Core:20.0.8620 + Patient Index:20.0.8620] - IRIS for UNIX (Red Hat Enterprise Linux for x86-64) 2020.1 (Build 217_1_20418U) Tue Nov 17 2020 15:48:44 EST
Check possible Java access modes.
You can query with JDBC.
You can use spring boot jpa to connect cache sql projections using cache jdbc.
Below might help.
https://community.intersystems.com/post/example-using-java-springboot-hi...
Thank you for all, this really helped a lot.
I went with JDBC and managed to automate my worklist reporting.