SQL
InterSystems IRIS for Health™ data platform provides high-performance, full-featured SQL access. You can use SQL with InterSystems IRIS for Health at scales from queries running on a single CPU core, to parallel queries using dozens of cores, to distributed queries across a cluster of InterSystems IRIS for Health servers.
InterSystems SQL is fully integrated with InterSystems IRIS for Health object technology and also provides connectivity with ODBC and JDBC clients. Other features include automatic parallel query execution, transparently distributed queries, and support for both standard SQL queries and stored procedures.
Get Started
-
SQL Quick Start is a video that introduces InterSystems SQL and offers hands-on exercises as well.
-
InterSystems SQL Overview is an online course that gives a hands-on introduction to class queries, dynamic SQL, and embedded SQL.
Categories
-
Using InterSystems SQL provides information about using SQL with InterSystems databases.
-
InterSystems SQL Optimization Guide explores performance optimization tools in depth.
-
InterSystems SQL Reference offers detailed reference information on InterSystems SQL commands, functions, operators, and more.
-
SQL Gateway Overview describes how to enable InterSystems IRIS for Health to access external databases via both JDBC and ODBC.