About This Book

The InterSystems SQL Gateway provides access from InterSystems IRIS® data platform to external databases via JDBC and ODBC. You can use various wizards to create links to tables, views, or stored procedures in external sources, allowing you to access the data in the same way you access any InterSystems IRIS object:

• Access data stored in third-party relational databases within InterSystems IRIS applications using objects and/or SQL queries.

• Store persistent InterSystems IRIS objects in external relational databases.

• Create class methods that perform the same actions as corresponding external stored procedures.

This book covers the following topics:

• Using the SQL Gateway — gives an overview of the Gateway and describes how to link to external sources.

• Connecting with the JDBC Driver — describes how to create a JDBC logical connection definition for the SQL Gateway.

• Connecting with the ODBC Driver — describes how to create an ODBC logical connection definition for the SQL Gateway.

• Using the ODBC SQL Gateway Programmatically — describes how to use the %SQLGatewayConnection class to call ODBC functions from ObjectScript.

The following documents contain related material:

• Using InterSystems SQL — describes how to use InterSystems SQL, which provides standard relational access to data stored in an InterSystems IRIS database.

• Using Java with InterSystems Software — provides an overview of all InterSystems Java technologies enabled by the InterSystems JDBC driver, and describes how to use the driver to access data sources via SQL.

• Using ODBC with InterSystems Software — describes how to connect to InterSystems IRIS from an external application via InterSystems ODBC, and how to access external ODBC data sources from InterSystems IRIS.