The latest articles on DEV Community by Brendan (@nayameth). https://dev.to/nayameth https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F2735305%2F9f964eb0-275b-4afc-8675-af2bb5e8ef18.jpg https://dev.to/nayameth en Brendan Sun, 19 Jan 2025 17:46:31 +0000 https://dev.to/nayameth/enhancing-oracle-database-integration-in-n8n-with-a-plugin-400m https://dev.to/nayameth/enhancing-oracle-database-integration-in-n8n-with-a-plugin-400m <p>If you’ve ever integrated Oracle databases with n8n, you may already be familiar with a community-maintained plugin that simplified connectivity. However, you might also have noticed that the original repository is no longer actively supported. Recently, I stumbled upon a fork of the n8n-nodes-oracle plugin that, despite being two years old, is still overseen by a developer who remains active on GitHub. Although the plugin itself hasn’t changed in that time—simply because no new features or bug fixes have been requested—it continues to serve as a stable and practical alternative to the original, which is no longer maintained.</p> <p>Below is a quick overview of what the fork provides, how to install it, and why it could still be a valuable resource for n8n users.</p> <h2> Background: A Fork of an Unmaintained Plugin </h2> <p>While searching for an efficient way to connect Oracle databases to n8n, many users stumbled upon the original n8n-nodes-oracle plugin. It provided a straightforward solution but lacked ongoing maintenance. Recognizing this gap, a developer forked the codebase and expanded it to include stored procedure functionality—something the community had been requesting for a while.</p> <h2> Key Features </h2> <ol> <li><p><strong>Stored Procedure Support</strong><br> One of the most notable improvements is the ability to call Oracle stored procedures. This expands n8n’s capabilities for complex operations and reduces the need for manual or external scripting.</p></li> <li><p><strong>Active Maintenance</strong>(hopefully)<br> Even though this fork isn’t brand new, it is still overseen by a developer who remains active on GitHub. Whether you discover bugs or have feature requests, there’s a good chance they’ll be addressed in a timely manner.</p></li> <li><p><strong>Straightforward Integration</strong><br> Configuration remains similar to the original. Once installed, you can quickly set up Oracle credentials in n8n and use the plugin in your workflows just like any other node.</p></li> </ol> <h2> Installation &amp; Setup </h2> <p>To install the forked plugin, run:<br> </p> <div class="highlight js-code-highlight"> <pre class="highlight shell"><code>npm i azratul/n8n-nodes-oracle </code></pre> </div> <p><strong>Credentials</strong>: After installing, go to your n8n instance and add your Oracle credentials.<br> <strong>Nodes</strong>: Look for the “Oracle” nodes.<br> <strong>Usage</strong>: You can now build workflows calling Oracle databases for either queries or stored procedures.</p> <h2> Conclusion </h2> <p>If you need a robust, actively maintained solution for connecting n8n to Oracle databases, this long-standing fork is worth exploring. Its stored procedure support and consistent updates address the biggest gaps of the original plugin. To learn more or contribute, head over to <a href="https://github.com/azratul/n8n-nodes-oracle" rel="noopener noreferrer">https://github.com/azratul/n8n-nodes-oracle</a>.</p> n8n opensource oracle