SQL
InterSystems Supply Chain Orchestrator™ provides high-performance, full-featured SQL access. You can use SQL with Supply Chain Orchestrator at scales from queries running on a single CPU core, to parallel queries using dozens of cores, to distributed queries across a cluster of Supply Chain Orchestrator servers.
InterSystems SQL is fully integrated with Supply Chain Orchestrator 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
-
Try a hands-on exerciseOpens in a new tab on running fast SQL queries in InterSystems IRIS.
-
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 Supply Chain Orchestrator to access external databases via both JDBC and ODBC.