Using the InterSystems SQL Gateway

Connect external relational databases to InterSystems IRIS via JDBC and ODBC.

Updated Feb 2, 2026

Search Tags:#odbc #external data #database integration #jdbc #intersystems iris #sql gateway

Ready to run

npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-the-intersystems-sql-gateway

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: Using the InterSystems SQL Gateway
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/using-the-intersystems-sql-gateway
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-the-intersystems-sql-gateway

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill simplifies the process of accessing and integrating data from external relational databases (like Oracle, SQL Server, etc.) directly within your InterSystems IRIS applications, eliminating the need for complex data migration or separate data silos.

Core Features & Use Cases

Data Access: Query and manipulate data from external databases as if it were native InterSystems IRIS data.
Object Persistence: Store InterSystems IRIS objects in external relational databases.
Wizard-driven Linking: Utilize wizards to easily link tables, views, and stored procedures from external sources.
Use Case: Integrate customer data residing in an external Oracle database into your InterSystems IRIS-based CRM application without moving the data.

Quick Start

Use the InterSystems SQL Gateway skill to create a JDBC connection named 'MyOracleConnection' to an Oracle database using the provided driver and URL.

Frequently Asked Questions about Using the InterSystems SQL Gateway

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I connect an external database to InterSystems IRIS?▼

You connect an external database to InterSystems IRIS by configuring a JDBC or ODBC connection through the SQL Gateway, enabling direct querying and manipulation of external relational data within IRIS applications.

Can I store InterSystems IRIS objects in an external relational database?▼

Yes, you can persist InterSystems IRIS objects in an external relational database using the SQL Gateway, eliminating the need for complex data migration while maintaining seamless object storage.

How do I link external tables and stored procedures to InterSystems IRIS?▼

You link external tables, views, and stored procedures to InterSystems IRIS by using guided wizards provided by the SQL Gateway, which simplifies mapping external schema elements for direct access.

Does the InterSystems SQL Gateway support both JDBC and ODBC protocols?▼

Yes, the InterSystems SQL Gateway supports both JDBC and ODBC protocols, allowing you to integrate diverse external relational databases like Oracle and SQL Server directly with your IRIS environment.

How do I troubleshoot SQL Gateway connection issues with external databases?▼

You troubleshoot SQL Gateway connection issues by utilizing programmatic control features and logging capabilities, which help identify and resolve integration failures between InterSystems IRIS and external databases.