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...
can it be used on older version of Cache like 2020?
Certifications & Credly badges:
Sandeep has no Certifications & Credly badges yet.
Global Masters badges:
Sandeep has no Global Masters badges yet.
Followers:
Following:
Power bi has data connector to IRIS.
You can also use tableau with ODBC connection and sql projections.