InterSystems IRIS
InterSystems IRIS is a next-generation data platform that seamlessly blends high-performance multi-model database capabilities with native interoperability, advanced analytics, and embedded AI functionality.
Supported Versions and Architectures
- Versions: InterSystems IRIS 2020.x and later
- Architectures: Standalone and high-availability cluster configurations
Supported Data Types
| Category | Data Types |
|---|---|
| String Types | %String, %Text, %VarString |
| Numeric Types | %Integer, %BigInt, %SmallInt, %TinyInt, %Numeric, %Decimal, %Float, %Double |
| Date & Time Types | %Date, %Time, %TimeStamp, %DateTime |
| Boolean Type | %Boolean |
| Binary Types | %Binary, %BLOB |
| Special Types | %Status, %OID, %GUID |
Quick Setup Guide
1. Database Connection
Connect to IRIS using standard database credentials:
- Host: IRIS server address
- Port: Default 1972 (SuperServer port)
- Namespace: Target IRIS namespace
- Credentials: Database username and password
2. Enable Journaling (for CDC)
For incremental synchronization, ensure journaling is enabled on source tables.
3. Permission Requirements
Grant appropriate read/write permissions based on your use case:
- Source: SELECT permissions on target tables and views
- Target: INSERT, UPDATE, DELETE permissions as needed
Industry Applications
- Healthcare: Patient data integration, clinical analytics, and regulatory compliance
- Financial Services: Real-time transaction processing and risk analytics
- Manufacturing: IoT data ingestion and operational intelligence
- Government: Citizen services integration and data governance
Limitations
- Journaling dependency: Incremental sync requires journaling to be enabled
- Namespace isolation: Each connection targets a single IRIS namespace
- Data type mapping: Automatic mapping may require validation for complex types