This release introduces a new capability for leveraging external data in HealthShare Health Connect. To any SQL queries you write in InterSystems IRIS, Foreign Tables present themselves as regular InterSystems tables. However, their data is not physically stored within the Health Connect server. They may be in remote files, third-party databases (on-prem or DBaaS), or a separate Health Connect server to which an ECP connection would not be practical. In other words, the data in these tables is not managed by the Health Connect instance, but it is projected to the Health Connect instance.
Health Connect 2023.1 includes support for projecting data from CSV files and JDBC data sources. The JDBC option leverages existing SQL Gateway infrastructure for managing connection details and credentials, and the syntax and capabilities for using file sources is fully aligned with the existing LOAD DATA command.
Foreign Tables are available in Health Connect 2023.1 as an Experimental Feature. This means they are not supported for production environments. However, the feature is well-tested and InterSystems believes it can add significant value to customers.
InterSystems is looking for feedback on this new capability based on customers’ use in real-world environments. Please reach out on the Developer Community or contact the Worldwide Response Center (WRC) if you would like to share your experiences or you have questions.
For more details, see Foreign Tables.