This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
This node is part of the deprecated database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
This node injects an SQL query into a database connection. If the connection already has a query, it will be replaced.
Options
Popular Predecessors
- String Input (legacy)16 %
- Excel Writer14 %
- Java Edit Variable10 %
- Python Edit Variable (legacy)6 %
SQL Extract5 %Microsoft SQL Server Connector4 %Table Column to Variable4 %Database Writer3 %- Java Edit Variable (simple)3 %
Database Query3 %Database Table Creator3 %Database Connector2 %- String Manipulation (Variable)2 %
Database Pivot2 %Database Table Selector1 %MySQL Connector1 %Table Row To Variable Loop Start< 1 %Database GroupBy< 1 %SQLite Connector< 1 %SQL Inject< 1 %- PMML to SQL< 1 %
Impala Connector< 1 %Vertica Connector< 1 %- Extract Variables (Data)< 1 %
Table Row to Variable< 1 %Database Joiner< 1 %Database Table Connector< 1 %Database Reader< 1 %Database SQL Executor< 1 %- Table Creator< 1 %
- Column Resorter< 1 %
- Rule Engine Variable< 1 %
PostgreSQL Connector< 1 %Excel Reader (XLS)< 1 %- Inject Variables (Database)< 1 %
Table Row to Variable< 1 %Database Column Filter< 1 %Database Row Filter< 1 %Database Drop Table< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %- String Manipulation< 1 %
Merge Variables< 1 %Amazon Redshift Connector< 1 %Date Input (legacy)< 1 %- Date&Time Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
Views
- This node has no views
Workflows
01_Collecting_data_from_TwitterKNIME Hub- 01_Collecting_data_from_TwitterKNIME Hub
- CHALLENGE-2021.knarKNIME Hub
- CHALLENGE-2021.knarKNIME Hub
- transidentite_memoire2023-otti.e.knarKNIME Hub
Links
- No links available
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.