About This Book

This book describes how to use the InterSystems ODBC driver, which enables you to connect to InterSystems databases from external applications via ODBC, and allows InterSystems products to access external ODBC data sources.

This book covers the following topics:

• Getting Started: ODBC Connections to InterSystems Databases — provides an overview of the InterSystems ODBC driver.

• Defining an ODBC Data Source on Windows — describes how to use InterSystems IRIS as a ODBC data source on Windows.

• Defining an ODBC Data Source on UNIX® — describes how to use InterSystems IRIS as a ODBC data source on UNIX®.

• ODBC Installation and Validation on UNIX® Systems — describes tools to test and validate ODBC installations, and provides instructions for stand-alone installation and custom iODBC installation.

• ODBC Support for Python and Node.js — describes support for Python and Node.js open source interfaces to ODBC.

• Logging and Environment Variables — describes some tools you can use to perform troubleshooting.

For more information, try the following sources:

• Using the InterSystems Managed Provider for .NET — describes how use the InterSystems implementation of the ADO.NET Managed Provider for relational data access and the Entity Framework for object access.

• The book Using Java with InterSystems Software includes information on JDBC connectivity to InterSystems IRIS from external data sources (the JDBC equivalent of what is described in this manual).

• The book Using the InterSystems SQL Gateway provides an overview of how the SQL Gateway works with both ODBC and JDBC.