Home Products Node-RED node for InterSystems IRIS

Node-RED node for InterSystems IRIS

5
1 reviews
610
Views
2
0
Details
Releases
Reviews
Awards
Issues
Pull requests
Articles
Node-RED node for InterSystems IRIS

What's new in this version

more demos

node-red-contrib-intersystems-iris

Node-RED node for InterSystems IRIS

Install

Either use the Node-RED Menu - Manage Palette - Install, or run the following command in your Node-RED user directory - typically ~/.node-red

npm i node-red-contrib-intersystems-iris

Usage

Allows basic access to a InterSystems IRIS database.

This node uses the sql operation against the configured database.

By its very nature it allows SQL injection… so be careful out there…

The msg.topic must hold the query for the database, and the result is returned in msg.payload.

Typically the returned payload will be an array of the result rows.

It does not support paramaterized queries, yet.

msg.topic="INSERT INTO \"users\" (\"userid\", \"username\") VALUES ('36', 'some-user')"
return msg;
msg.topic="SELECT \"userid\", \"username\" FROM \"users\""
return msg;

Demo

To run own version of demo, it is possible to use docker compose. Just do

docker compose up --build -d

And after build and start, open link to Node-RED portal http://localhost:1880/

Demo flow file for manual installation is available here

SQL Flow

Production flow

Production flow

And dynamically updated Dashboard, which is avialable by link http://localhost:1880/ui/
Production dashboard

Some complex flow

Production dashboard
Production dashboard

Read more
Made with
Version
1.0.218 Feb, 2022
Category
Integration
Works with
InterSystems IRIS
First published
17 Oct, 2021