Requirement: In automation tool n8n, we want a node to connect with oracle database
Pre-requisites:
Install the NPM package
Package name : n8n-nodes-oracle-database-parameterization
Command to install
npm install n8n-nodes-oracle-database-parameterization
Set the environment variable:
export N8N_RUNNERS_ENABLED=trueexport N8N_CUSTOM_EXTENSIONS=$(pwd)/node_modules/n8n-nodes-oracle-database-parameterizatio
Start the n8n server:
n8n start
Now login to n8n tool:
Create the workflow:
Click on Add Node:
Search -- type oracle
Choose Credentials:
(in case you are performing the oracle database connection first time, then create the credentials and give your choice of name.
Add credentials
choose the credentials,
Add the SQL statement :
Note: you can give a name to this flow , (e.g. select users list, which are about to expire in 10 days)
