📘 Full Docker Installation Guide:

IrisWebClient

The Rich GUI web application for the InterSystems IRIS database

A modern web client built with Delphi + uniGUI and connected to InterSystems IRIS via ODBC. The application demonstrates full CRUD operations, referential property handling, and IRIS-native filtering using implicit JOINs.

Features

• Multiplatform Deployment — Windows and Linux supported
  • Linux: Standalone ELF executable, Apache module
  • Windows: Service, Standalone EXE, ISAPI
• Full CRUD (Create, Read, Update, Delete) for IRIS persistent classes
• Insert/Update of Referential Properties
  • Person → Spouse
  • Employee → Company
• IRIS Implicit JOIN Filtering
  • Filter by nested referential fields
  • Examples:
    • Person.Spouse.Name
    • Employee.Company.Name
    • Address.City
• Rich web UI built with uniGUI
• ODBC connectivity for SQL access to IRIS
• Zero‑installation browser client

Quick Start

How to Test

If you want to test the app without installing anything:

https://demo.irisclient.org

Login: demo
Password: demo

IrisWebClient – Docker Installation Guide

ODBC Installation Guide

Architecture Overview

• Frontend: uniGUI (Delphi) https://unigui.com/
• Backend: InterSystems IRIS https://www.intersystems.com/
• Connectivity: IRIS ODBC driver, used over standard FireDAC data access library in Delphi
• Data Model: Person, Employee, Company, Address (with referential relationships)
  ObjectScript-Native-API-demo

CRUD Demonstration

The application implements full CRUD for all major entities:

Referential Property Handling

The application demonstrates how to:

• Insert and update objects with references.
• Display referential fields in grids.
• Resolve nested properties (e.g., Person.Spouse.Name).
• Maintain referential integrity through UI controls.

Filtering with IRIS Implicit JOIN

IRIS automatically resolves referential properties in SQL queries. This application shows how to filter by nested properties without writing explicit JOINs.

SELECT * FROM ONAPI.Person WHERE Spouse->Name LIKE 'A%'

Installation on Windows host

• Install IRIS
• Load sample classes to IRIS
  use ObjectScript-Native-API-demo
  

  git clone https://github.com/r-cemper/ObjectScript-Native-API.git

  load classes

  
    USER>do $system.OBJ.LoadDir("...\ObjectScript-Native-API\src\ONAPI","ck")
    

  Run the database installation. This is an interactive process; you will be asked how many Persons, Employees, and Companies to create.
  

  USER>do ##class(ONAPI.demo).Run()

• Configure ODBC DSN
  Create a 'User DSN' for InterSystems IRIS ODBC driver
• Build the uniGUI IrisWebClient.exe application in Delphi
  Delphi 12 CE was used to create this aplication, but the application should build with no problems on any modern Delphi version since uniGUI is only third-party dependency,
  but indeed the breakthrough technology.
• Update connection.ini with ODBC connection parameters and make sure the file is located in the same directory as IrisWebClient.exe

    DataSource=...
    User_Name=...
    Password=...
    ODBCDriver=InterSystems IRIS ODBC35
    Database=...
    DriverID=ODBC

• Make sure login.html is located in the same directory as IrisWebClient.exe.
• Run IrisWebClient.exe and navigate your browser to the default address and port:
  http://localhost:8077

Screenshots

Main Dashboard

Use implicit JOIN to select referential fields.

SELECT *, Spouse->Name AS SpouseName FROM ONAPI.Person

This works perfectly fine with FireDAC over IRIS ODBC.

IRIS ODBC does accept object‑projection syntax (->) when the SQL is passed through FireDAC unchanged

Assigning referential properties

Select a Person, click button in SpouseName column, select a Spouse, click 'OK' to confirm assignment

Implementation using ODBC layer as FireDAC dataset. Assign referetial field with reference ID and do Post.

 
    FTargetDataSet.Edit;
    FTargetDataSet['Spouse'] := qryPersonDict['ID'];
    FTargetDataSet.Post;

Searchable Lookup Combobox

Assign Employee->Company by selecting a company in the searchable lookup combobox.

Lookup persistent fields in Delphi provide a true No‑Code solution. Simply configure the Lookup properties in the Object Inspector.

Filtering using referential properties

Use 'Filter' button to call Filter dialog and add add filtering criteria

Calendar widget in the Grid

License

MIT LICENSE