IRIS
InterSystems IRIS is a complete data platform that combines a high-performance multi-model database with built-in interoperability, analytics, and AI capabilities.
ClickPipes supports IRIS as both a source and target database, helping you quickly build data pipelines for healthcare, financial services, and other mission-critical applications. This article provides a comprehensive guide on how to add IRIS to ClickPipes.
Supported Versions and Architectures
| Category | Description |
|---|---|
| Version | InterSystems IRIS 2020.x and above |
| Architecture | Supports both standalone and high-availability 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 |
Precautions
For optimal performance when using IRIS as a source database, ensure that the user account has appropriate permissions to access the tables and views you intend to synchronize.
When using IRIS as a target database, ClickPipes automatically handles data type mapping from various source databases to IRIS data types.
For incremental synchronization (CDC), the source IRIS database must have journaling enabled.
Source Config
- Connection Settings
- Connection name: Fill in a unique name that has business significance.
- Connection type: Select whether IRIS will be used as a Source, Target, or both.
- Host: Fill in the IRIS server connection address.
- Port: Fill in the service port for IRIS, default is 1972.
- Username, Password: Fill in the IRIS database username and password.
- database, schema: Specify the IRIS namespace to connect to.
Common Use Cases
Healthcare Data Integration: Synchronize patient data from IRIS to analytical databases for reporting and research.
Financial Services: Replicate transaction data from legacy systems to IRIS for real-time processing and analytics.
Real-time Analytics: Stream data from operational databases to IRIS for immediate analysis and decision support.
Data Warehousing: Use IRIS as a source to populate data warehouses with operational data for business intelligence.