ODBC/JDBC Gateway icon

ODBC/JDBC Gateway

Esegue query SQL su RDBMS multipli tramite il gateway ODBC/JDBC

Actions9

Table → Select

AI-generated

Summary

Selects rows from a configured ODBC/JDBC Gateway table, with optional column selection, filters, sorting, and a row limit. The node sends a parameterized query to the gateway and returns each row as an n8n item with column names as JSON keys.

Inputs

  • Connection Name or ID (required) — Preconfigured gateway connection to query.
  • Schema Name or ID — Schema containing the table; leave empty to use the driver default.
  • Table Name or ID (required) — Table to read.
  • Output Columns — Columns to return; an empty selection returns all columns.
  • Conditions (WHERE) — Optional column comparisons using equals, not equals, greater/less than, LIKE, IN, IS NULL, or IS NOT NULL. LIKE values can use % wildcards; IN values are comma-separated. Values are bound query parameters.
  • Combine Conditions — Joins multiple conditions with AND or OR; defaults to AND.
  • Sort — Optional ordered list of columns and ascending or descending directions.
  • Return All — When enabled, omits the row limit; otherwise the node applies the Limit value.
  • Limit — Maximum rows to return when Return All is disabled; defaults to 50.

Output shape

A list of n8n items, one per returned row.

Each item's JSON contains the selected columns as keys and their row values. Items are linked to the corresponding input item. With no matching rows, no row items are produced.

Links

Discussion