go to post Guilherme Koerber · Jul 12, 2022 Hi Oliver, There is a possibility that you create a table in IRIS that connects to an external table. I've done tests with the ODBC format, it works well I believe JDBC too. In this case, I recommend using a JDBC connection to communicate the IRIS database with Java. SQL Gateway via JDBC: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BSQ...How to use the table wizard: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=BSQ...
go to post Guilherme Koerber · Jun 27, 2022 Hi Nicki! Is your idea to mirror the Ensemble tables with Iris? If yes, you can do that with the table linking wizard. https://docs.intersystems.com/ens201815/csp/docbook/DocBook.UI.Page.cls?... I did this procedure a few times with ODBC, it's very useful.