Skills
.Work. You
Rest

Using the InterSystems SQL Gateway

Community

Connect external databases to InterSystems IRIS.

Software Engineering#odbc#external data#database integration#jdbc#intersystems iris#sql gateway
Authorsorodriguezz
Version1.0.0
Installs0

System Documentation

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.

Dependency Matrix

Required Modules

None required

Components

references

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: Using the InterSystems SQL Gateway
Download link: https://github.com/sorodriguezz/skills-objectscript/archive/main.zip#using-the-intersystems-sql-gateway

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.