Skip to main content

This is documentation for Caché and Ensemble. See the InterSystems IRIS version of this content.Opens in a new tab

Please read this important announcement about the future of Caché and Ensemble maintenanceOpens in a new tab. Contact your account team to migrate to InterSystems IRIS.

SQL Gateway Connections

Manage and access SQL Gateway connections programmatically (check connections, query by name, and so on).

Background Information

The SQL Gateway allows Caché to access external databases via both JDBC and ODBC. For a detailed description of the SQL Gateway, see the chapter “Using the Caché SQL Gateway” in Using Caché SQL.

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.SQLGatewayOpens in a new tab class

Provides an interface for managing SQL Gateway connections. This class provides methods like the following:

  • DropConnection()

  • GetJDBCConnection()

  • GetODBCConnection()

  • SetAutoCommit()

  • Test()

  • And others

Availability: All namespaces.

%SQLConnectionOpens in a new tab class

Stores SQL Gateway connections. This class provides the following methods:

  • ConnExists()

  • setEncode()

It also provides the following class queries:

  • ByConnection()

  • ByName()

Availability: All namespaces.

Reminder

The special variable $SYSTEM is bound to the %SYSTEM package. This means that (for ObjectScript) instead of ##class(%SYSTEM.class).method(), you can use $SYSTEM.class.method().

See Also

SSHNext section
Previous sectionSQL
FeedbackOpens in a new tab