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