InterSystems IRIS Data Platform 2019.2  /  InterSystems Programming Tools Index

InterSystems Programming Tools Index
SQL Gateway Connections
Previous section           Next section
InterSystems: The power behind what matters   

Manage and access SQL Gateway connections programmatically (check connections, query by name, and so on).
Background Information
The SQL Gateway allows InterSystems IRIS to access external databases via both JDBC and ODBC. For a detailed description of the SQL Gateway, see Using the InterSystems SQL Gateway.
An SQL Gateway connection contains information about accessing a specific external database via JDBC or via ODBC. You generally define these connections in the Management Portal.
Available Tools
%SYSTEM.SQLGateway class
Provides an interface for managing SQL Gateway connections. This class provides methods like the following:
Availability: All namespaces.
%SQLConnection class
Stores SQL Gateway connections. This class provides the following methods:
It also provides the following class queries:
Availability: All namespaces.
The special variable $SYSTEM is bound to the %SYSTEM package. This means that instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().
See Also

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-08-22 06:48:58