About This Book

This book describes how an InterSystems IRIS® programmer can add SQL adapters to a production, so that the production can communicate with JDBC or ODBC-compliant databases. You should be aware of the particular limitations (syntactical or otherwise) of the database to which you are connecting, as well as the database driver that you use to do so; this book does not include such information.

This book contains the following sections:

• About the SQL Adapters

• Using the SQL Inbound Adapter

• Using the SQL Outbound Adapter

• Creating Adapter Methods for SQL

• Using Result Sets

• Using Snapshots

For a detailed outline, see the table of contents.

For more information, try the following sources:

• Best Practices for Creating Productions describes best practices for organizing and developing productions.

• Developing Productions explains how to perform the development tasks related to creating a production.

• Configuring Productions describes how to configure the settings for productions, business hosts, and adapters. It provides details on settings not discussed in this book.

• Using the InterSystems ODBC Driver describes how to use InterSystems ODBC, which enables you to connect to InterSystems IRIS from an external application via ODBC, and allows InterSystems IRIS to access external ODBC data sources.

• Using Java with the InterSystems JDBC Driver describes how to connect to InterSystems IRIS from an external application using the InterSystems JDBC driver, and how to access external JDBC data sources from InterSystems IRIS.

• Using the Java Gateway in Productions explains how to enable easy interoperation between InterSystems IRIS and Java components.