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:

   mkdir -p ~/.n8n/custom
   tar -xzf n8n-nodes-sybase-odbc.tgz -C ~/.n8n/custom
   

2. Install dependencies and build inside the node folder:

   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:

  return [{ json: { query: "SELECT * FROM DBA.Cliente" } }];
  

Note

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