Power bi has data connector to IRIS.
You can also use tableau with ODBC connection and sql projections.
- Log in to post comments
Power bi has data connector to IRIS.
You can also use tableau with ODBC connection and sql projections.
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-h…
can it be used on older version of Cache like 2020?
You can start with below links..
https://learning.intersystems.com/course/view.php?id=681&ssoPass=1
https://learning.intersystems.com/course/view.php?id=1237
You can search for react project with axios call. Then you can implement those rest end point calls in cache.
You can use React UI framework. React framework needs some endpoint which can serve data thru rest apis. You can write rest (json ) api in the cache which will feed the data to calls made from React framework.
I worked with tableau using ODBC connection. Other solution we tried with tableau is web data connector. Where you will publish the data using html.