Using the InterSystems SQL Gateway

• SQL Gateway Overview
• Accessing a Database with the SQL Gateway
• Architecture of the InterSystems SQL Gateway
• Creating SQL Gateway Connections for External Sources
• The Link Table Wizard: Linking to a Table or View
• The Link Procedure Wizard: Linking to a Stored Procedure
• Controlling SQL Gateway Connections
• Connecting the SQL Gateway via JDBC
• Defining a Logical Connection in the Management Portal
• Creating a Connection between Namespaces
• Implementation-specific JDBC Connection Options
• SQL Gateway Logging
• Connecting the SQL Gateway via ODBC
• Creating Connections for External Sources
• Using the Data Migration Wizard
• Using the SQL Gateway Programmatically
• FetchSamples Example
• Creating and Using an External Data Set
• Calling ODBC Functions Directly
• Quick Reference for %SQLGatewayConnection