SQL
HealthShare® Health Connect provides high-performance, full-featured SQL access. You can use SQL with Health Connect at scales from queries running on a single CPU core, to parallel queries using dozens of cores, to distributed queries across a cluster of Health Connect servers.
InterSystems SQL is fully integrated with Health Connect 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 StartOpens in a new tab is a video that introduces InterSystems SQL and offers hands-on exercises as well.
-
InterSystems SQL OverviewOpens in a new tab 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 Performance Optimization explores performance optimization tools.
-
InterSystems SQL Reference offers detailed reference information on InterSystems SQL commands, functions, operators, and more.
-
SQL Gateway Overview describes how to enable Health Connect to access external databases via both JDBC and ODBC.