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?
Followers:
Following:
Global Masters badges:
Sandeep has no Global Masters badges yet.
Power bi has data connector to IRIS.
You can also use tableau with ODBC connection and sql projections.