How to integrate InterSystems IRIS SQL queries with external applications like Java.

Question

Question

Ephraim Malane · Dec 23, 2021

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

Discussion (3)1

Log in or sign up to continue

Eduard Lebedyuk · Dec 23, 2021

Check possible Java access modes.

You can query with JDBC.

0 0

Sandeep Sandeep · Dec 23, 2021

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...

0 0

score 0 · Answer 1 · 2021-12-28T01:45:00-05:00

Ephraim Malane · Dec 28, 2021

Thank you for all, this really helped a lot.

I went with JDBC and managed to automate my worklist reporting.

0 0