Oracle Database node

There are some community nodes but they are not updated for long time. Hoping n8n will create one. Need that too.

This is something I would love to have, to ā€œvalidateā€ n8n in our environment.

@BadRequest @Mulen
I finally made the time yesterday to fork from one of the community oracle nodes and add parameterizzation. The code for that is published here now: https://www.npmjs.com/package/n8n-nodes-oracle-database-parameterization

(not going to claim itā€™s perfect or anything since Iā€™ve barely tested it, but so far it looks like itā€™s working)

3 Likes

Wow thanks. Will definetely try this out.

Thanks for the great work
Is there any way to access Oracle through an ssh tunnel?

Not sure? Thatā€™s not something Iā€™ve ever tried before. But the magical world of npmjs.com probably has some libraries related to ssh tunneling. So Iā€™m sure that if you fork from my repo: jgriffin1/n8n-nodes-oracle-database-parameterization: An N8N node for Oracle database queries that utilizes parameterization to increase security. (github.com) youā€™ll be able to modify the code in way that gets that working. My team ended up going a different direction and is no longer using N8N, so this isnā€™t something Iā€™m going to explore myself right now. But feel free to update this chat if you figure something out!