n8n node for connecting to databases via ODBC (IBM i, DB2, etc)
npm install n8n-odbc-databaseThis is an n8n community node that lets you connect to databases using ODBC (Open Database Connectivity) in your n8n workflows.
Supports any database with ODBC drivers including:
- IBM i (AS/400)
- IBM DB2
- PostgreSQL
- MySQL
- SQL Server
- Oracle
- And many more
For n8n cloud or self-hosted using npm:
1. Go to Settings → Community Nodes
2. Select Install
3. Enter n8n-nodes-odbc-database
4. Agree to the risks and install
``bash`
npm install n8n-nodes-odbc-database
This node requires the ODBC driver for your database to be installed on the system where n8n is running.
bash
Download and install IBM i Access ODBC Driver
https://www.ibm.com/support/pages/ibm-i-access-client-solutions
`$3
You need to install the ODBC drivers in your container using init containers or a custom Docker image.Usage
$3
Configure your database connection using one of three methods:
1. Connection String: Full ODBC connection string
`
DRIVER={IBM i Access ODBC Driver 64-bit};SYSTEM=hostname;UID=user;PWD=password
`2. DSN: Use a configured Data Source Name
`
DSN=MyDatabase
`3. Manual Configuration: Specify driver, host, database, username, and password individually
$3
- Execute Query: Run any SQL query (SELECT, INSERT, UPDATE, DELETE, etc.)
Example Queries
`sql
-- Select data
SELECT * FROM customers WHERE id = 1-- Insert data
INSERT INTO orders (customer_id, amount) VALUES (123, 99.99)
-- Update data
UPDATE products SET price = 29.99 WHERE sku = 'ABC123'
-- Delete data
DELETE FROM temp_data WHERE created_at < CURRENT_DATE - 30
``- Requires n8n version 0.198.0 or higher
- Requires ODBC drivers to be installed on the system
- Works with any database that has ODBC support
- n8n community nodes documentation
- ODBC Wikipedia
MIT