skills.rest
sorodriguezz
sorodriguezzCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill using-the-intersystems-sql-gateway
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Software Engineering Skills→
sorodriguezzsorodriguezz

XDBC Gateway

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

Community
Intermediate
sorodriguezzsorodriguezz

Using SQL in Productions

Integrate external relational data into InterSystems IRIS productions via SQL adapters.

Community
Intermediate
sorodriguezzsorodriguezz

Using Java with InterSystems Software

Integrate Java applications with InterSystems IRIS via JDBC and data access SDKs.

Community
Intermediate
sorodriguezzsorodriguezz

Using SQL

Operate InterSystems SQL within the InterSystems IRIS data platform.

Community
Intermediate