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

XDBC Gateway

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

Updated Feb 2, 2026
Search Tags:#odbc#database integration#jdbc#intersystems iris#sql gateway#xdbc
One-click install
npx skills add https://github.com/sorodriguezz/skills-objectscript --skill xdbc-gateway
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: XDBC Gateway
Source: https://github.com/sorodriguezz/skills-objectscript/tree/main/skills/xdbc-gateway
Command: npx skills add https://github.com/sorodriguezz/skills-objectscript --skill xdbc-gateway

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

This Skill provides a unified interface for connecting InterSystems IRIS to external databases via JDBC or ODBC, simplifying data access and object storage in external relational databases.

Core Features & Use Cases

  • External Data Access: Access data from third-party relational databases within InterSystems IRIS applications.
  • Object Storage: Store InterSystems IRIS objects in external relational databases.
  • Stored Procedure Integration: Create class methods that mirror external stored procedures.
  • Use Case: Seamlessly query and update data in a Microsoft SQL Server database directly from your InterSystems IRIS application using familiar SQL commands.

Quick Start

Use the XDBC Gateway skill to establish a JDBC connection to a Microsoft SQL Server database using the provided connection string.

Frequently Asked Questions about XDBC Gateway

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

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

You can connect InterSystems IRIS to external relational databases using the XDBC Gateway by establishing JDBC or ODBC protocols via named SQL Gateway definitions or JSON connection strings.

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

Yes, you can persist InterSystems IRIS objects externally by connecting to the target relational database via the XDBC Gateway using JDBC or ODBC protocols.

How do I execute stored procedures from an external database inside IRIS?▼

You can integrate external stored procedures by creating class methods in InterSystems IRIS that mirror the stored procedures using the XDBC Gateway connection.

Does the SQL Gateway support both JDBC and ODBC connection strings?▼

Yes, the SQL Gateway supports both JDBC and ODBC protocols, allowing you to establish connections using either named definitions or JSON connection strings.

What is the best way to query Microsoft SQL Server from an InterSystems IRIS application?▼

The best way to query Microsoft SQL Server from IRIS is using the XDBC Gateway to establish a JDBC or ODBC connection and execute familiar SQL commands directly.

When do I need an SQL Gateway connection for external data access?▼

You need an SQL Gateway connection when you want to access third-party relational data, persist IRIS objects externally, or integrate external stored procedures within your InterSystems IRIS applications.

Related Skills

Explore More Software Engineering Skills→
sorodriguezzsorodriguezz

Using SQL in Productions

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

Community
Intermediate
sorodriguezzsorodriguezz

Using the InterSystems SQL Gateway

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

Community
Advanced
sorodriguezzsorodriguezz

Introduction to Embedded Python

Integrate Python code and libraries within InterSystems IRIS alongside ObjectScript.

Community
Intermediate
sorodriguezzsorodriguezz

Using Java with InterSystems Software

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

Community
Intermediate