This Node Is Deprecated — This version of the node has been replaced with a new and improved version. The old version is kept for backwards-compatibility, but for all new workflows we suggest to use the version linked below.
Go to Suggested ReplacementDB Query ExtractorThis 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 extracts the SQL query from a database port and creates a flow variable and data table containing the query.
Options
Popular Successors
Database Table Selector7 %- Inject Variables (Database)5 %
Parameterized Database Query4 %Table Row to Variable4 %Variable Loop End3 %SQL Inject3 %Row Filter (deprecated)3 %Merge Variables3 %- Send Email3 %
- Columns to JSON3 %
- Container Output (Table)2 %
Database Query2 %File Reader2 %- String Manipulation2 %
Database Looping2 %- Group Loop Start2 %
Column Appender2 %- DB Writer2 %
Database Reader1 %- Java Edit Variable1 %
- Java Snippet1 %
- Cross Joiner1 %
XLS Writer1 %- Inject Variables (Data)1 %
Database Joiner1 %- Histogram (legacy)1 %
- Wait...< 1 %
Database Writer< 1 %Loop End< 1 %- GroupBy< 1 %
Column Rename< 1 %- Statistics< 1 %
- Line Plot (legacy)< 1 %
- Excel Writer< 1 %
Meta Info Extractor< 1 %- String Input (legacy)< 1 %
Variable to Table Column< 1 %Database SQL Executor< 1 %Database Drop Table< 1 %- Decision Tree Learner< 1 %
Concatenate (Optional in)< 1 %Joiner< 1 %- String Replacer< 1 %
- Scatter Matrix (legacy)< 1 %
Excel Reader (XLS)< 1 %Excel Writer (XLS)< 1 %- Table View (JavaScript)< 1 %
Python Script (DB)< 1 %- XML Row Combiner< 1 %
CSV Writer< 1 %Database Connection Table Reader< 1 %Database Connection Table Writer< 1 %SQL Extract< 1 %Database Connector< 1 %Database Table Creator< 1 %- CSV Writer< 1 %
Table Writer< 1 %- k-Means< 1 %
K Nearest Neighbor< 1 %- MultiLayerPerceptron Predictor< 1 %
- Concatenate< 1 %
- Auto-Binner< 1 %
- Column Rename (Regex)< 1 %
Linear Correlation< 1 %- Column Filter< 1 %
- Partitioning< 1 %
- Sorter< 1 %
- String Manipulation (Variable)< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
Rank Correlation< 1 %- Cache< 1 %
- Extract Table Spec< 1 %
- Crosstab< 1 %
- Interactive Histogram (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
MySQL Connector< 1 %PostgreSQL Connector< 1 %Microsoft SQL Server Connector< 1 %- DB Reader< 1 %
- String Distances< 1 %
- Similarity Search< 1 %
- Bar Chart (JavaScript)< 1 %
PMML Predictor< 1 %Table to HTML< 1 %- Scatter Plot (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Java Snippet (simple)< 1 %
- Java Edit Variable (simple)< 1 %
Strings To Document< 1 %- Text Output (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Python Source (legacy)< 1 %
- GET Request< 1 %
- String to Date&Time< 1 %
- Date&Time-based Row Filter< 1 %
XML Writer< 1 %
Views
- This node has no views
Workflows
- No workflows found
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.