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