n8n-nodes-sybase-odbc

Minimal n8n custom node that executes SQL via ODBC using the odbc npm package.

What it does

- Reads each incoming item and expects item.json.query to contain the SQL string.
- Connects via ODBC (DSN or connection string) and runs the query.
- Returns the results in the node output.

Install (on your n8n host)

1. Copy the package to your host and extract into your custom nodes folder:
``bash
mkdir -p ~/.n8n/custom
tar -xzf n8n-nodes-sybase-odbc.tgz -C ~/.n8n/custom
`

2. Install dependencies and build inside the node folder:
`bash
cd ~/.n8n/custom/n8n-nodes-sybase-odbc
npm install
npm run build
`

3. Restart n8n.

Usage


- Add the node n8n-nodes-sybase-odbc (Execute ODBC) to your workflow.
- Configure connection using either:
- DSN (ODBC Data Source Name) in the "connectionString" parameter: DSN=MyDSN;UID=user;PWD=pass
- Full connection string (Driver=...;Server=...;Database=...;UID=...;PWD=...)
- The node runs each item.json.query. For example, using a Function node:
`js
return [{ json: { query: "SELECT * FROM DBA.Cliente" } }];
``

Note

This is a minimal template. Adjust error handling and resource management according to your environment.