Node-RED Oracle Cloud Nodes

This project provides a set of custom Node-RED nodes that integrate the Oracle Database, Advanced Queues (AQ), Oracle Fusion Cloud SCM, OCI services, and the OCI IoT Platform.

What's Included

• db-nodes

  • Database connection (with Test Database Connection)
  • SQL execution (Editor or msg.sql)
  • AQ enqueue / dequeue (configurable dequeue mode, continuous retry/reconnect controls)
  • Transactional processing (begin / end transaction with commit or rollback)

• fusion-scm-nodes

  • General transaction node (fusion-request)
  • General lookup node (scm-lookup), including normalized complete Fusion GET URLs, subinventory, on-hand quantity, recipe/batch, and manufacturing child-resource lookups
  • smart operations transformer
  • smart operations event (submit operational events)
  • Manufacturing work order create/update
  • manage manufacturing work order details: operations, components, resources, serials, and progress
  • manufacturing production transaction: operation, material/ingredient, and output product reporting
  • Maintenance work order create/update
  • manage maintenance work order details: operations, materials, resources, and cost transactions
  • create installed base asset, create meter reading
  • Inventory transactions (misc/account-alias receipt/issue, subinventory transfer)
  • delete scm record
  • Lookup nodes (asset, meter reading, organization)

• oci-nodes

  • OCI authentication config (Config File, Instance Principal, Resource Principal, API Key)
  • OCI Notifications (email, Slack, PagerDuty, webhook, SMS, OCI Functions)
  • OCI Object Storage (upload and download objects)
  • OCI Logging (putLogs to OCI Custom Logs)
  • OCI Log Analytics (upload log events to Log Analytics)
  • ORDS Config, ORDS Request, and ORDS Poll (OAuth-backed ORDS access with IoT Data API shortcuts)
  • IoT Device config (MQTT connection to OCI IoT Platform)
  • IoT Telemetry (publish device telemetry)
  • IoT Subscribe (subscribe to OCI IoT MQTT topics)
  • IoT Send Command (send commands to devices via OCI REST API)
  • IoT Get Content (read digital twin instance content via OCI REST API)
  • IoT Update Relationship (update digital twin relationship content via OCI REST API)

Detailed node-level documentation is available in Node Reference.

Quick Start

Description	Resource
Detailed installation	Guide
Setup Oracle AQ (queue + subscriber using SQL)	Guide
Import examples into Node-RED	Guide
Best practices	Guide
Node reference	Guide

Installation

1. Clone the Repository

Navigate to your Node-RED user directory (~/.node-red) and clone using one of the following methods:

HTTPS

git clone https://github.com/oracle-samples/node-red-nodes.git

SSH

git clone git@github.com:oracle-samples/node-red-nodes.git

GitHub CLI

gh repo clone oracle-samples/node-red-nodes

2. Install Dependencies

Prerequisites

• Node-RED v3.0+
• Node.js v18+
• npm
• Oracle Instant Client 23c (required only when DB Driver Mode is Thick)

Required Node-RED Dependencies

These libraries must be installed inside your Node-RED user directory (~/.node-red):

cd ~/.node-red
npm install oracledb@^7.0.1          # DB nodes
npm install axios@1.17.0              # SCM nodes
npm install https-proxy-agent@^7.0.6 # SCM nodes (proxy support)
npm install oci-sdk@2.137.0          # OCI nodes (Notifications, Logging, Log Analytics, IoT control-plane nodes)
npm install mqtt@5.15.2              # IoT nodes (Telemetry, Command)

ORDS request/poll nodes use Node.js v18+ built-in HTTP APIs and do not require an additional npm package.

Install Oracle Instant Client (23c)

sudo dnf install oracle-instantclient-release-el8
sudo dnf install oracle-instantclient-basic
sudo dnf install oracle-instantclient-sqlplus

NOTE: Oracle Linux typically installs Instant Client into /usr/lib/oracle/23/client64/lib by default.

If your DB flows use Driver Mode = Thin, Oracle Instant Client is not required.

oracledb is a native module: keep Node.js build/runtime versions aligned and run npm rebuild oracledb after Node.js upgrades.

Local Install Note (Palette Manager Upload)

For local/offline installs via the Node-RED editor, you must generate an npm-packed tarball yourself with npm pack. GitHub source/release tarballs are not directly uploadable in Palette Manager because they do not use the expected npm archive layout (package/package.json).

See Detailed installation: Install from Local .tgz in Palette Manager.

Documentation

You can find the online documentation for the Oracle Internet of Things Platform at docs.cloud.oracle.com.

Examples

The repository includes three importable Node-RED examples:

• Oracle Database SQL, enqueue, dequeue, and transaction flows
• Enqueue → Dequeue → Create Meter Reading → If Not Found, create installed base asset
• OCI IoT telemetry, MQTT subscription, command delivery, and threshold notification

Examples can be imported directly into the Node-RED editor. See Import Examples Guide.

Contributing

This project welcomes contributions from the community. Before submitting a pull request, please review our contribution guide.

Security

Please consult the security guide for our responsible security vulnerability disclosure process.

License

See LICENSE.

Disclaimer

Oracle and its affiliates do not provide any warranty whatsoever, express or implied, for any software, material or content of any kind contained or produced within this repository, and in particular specifically disclaim any and all implied warranties of title, non-infringement, merchantability, and fitness for a particular purpose. Furthermore, Oracle and its affiliates do not represent that any customary security review has been performed with respect to any software, material or content contained or produced within this repository. In addition, and without limiting the foregoing, third parties may have posted software, material or content to this repository without any review. Use at your own risk.