Node-RED SCM & DB Nodes

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

What's Included

• db-nodes

  • Database connection (with Test Connection)
  • SQL execution (Editor or msg.sql)
  • AQ enqueue / dequeue
  • Transactional processing (begin / end transaction)

• fusion-scm-nodes

  • General transaction node (fusion-request)
  • General lookup node (scm-lookup)
  • SMO Transformer
  • Create Asset
  • Create Meter Reading
  • Inventory transactions (misc, subinventory transfer)
  • Delete transaction
  • Lookup nodes (asset, meter reading, organization)

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 Node-RED Dependencies

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

cd ~/.node-red
npm install oracledb
npm install axios
npm install https-proxy-agent

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.

Documentation

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

Examples

Example Node-RED flows are provided in the documentation showcasing different use cases:

• Subscriber exists? → If Not, Create New Subscriber → If It Exists, Enqueue → Dequeue Example
• Enqueue → Dequeue → Create Meter Reading → If Not Found, Create Asset
• Transactional dequeue with rollback protection

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.