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 runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.
The place holder in brackets for table name and table column must be replaced, while the possible value place holder enclosed in hashes must not be edit and will be resolved during execution.
If the optional input is connected the database connection information is taken from the port, otherwise you need to specify the connection information in the dialog.
Make sure you have your vendor-specific database driver registered in the KNIME preference page (section Database Driver).
Options
Popular Successors
- Joiner21 %
- GroupBy5 %
- Value Counter4 %
Database Update4 %- Column Filter3 %
- Excel Writer3 %
Database Looping3 %Excel Writer (XLS)2 %- Reference Row Splitter2 %
- Interactive Table (legacy)2 %
- Rule-based Row Filter1 %
Row Filter (deprecated)1 %Table Writer1 %- Rank1 %
- Rule Engine1 %
- Math Formula1 %
- Duplicate Row Filter< 1 %
Column Rename< 1 %- Max Filter< 1 %
Recursive Loop End< 1 %- Rule-based Row Splitter< 1 %
XLS Writer< 1 %Excel Sheet Appender (XLS)< 1 %Concatenate (Optional in)< 1 %Cell Replacer< 1 %- String to Number< 1 %
Column Appender< 1 %Table Column to Variable< 1 %- Loop End< 1 %
- Concatenate< 1 %
- Number Rounder< 1 %
CSV Writer< 1 %Database Reader< 1 %- CSV Writer< 1 %
- Chunk Loop Start< 1 %
- Column Combiner< 1 %
Number To String< 1 %- Number to String< 1 %
- Column Name Replacer< 1 %
- Double to Integer< 1 %
Row Splitter (deprecated)< 1 %Joiner< 1 %- Table Manipulator< 1 %
- Pivot< 1 %
- Sorter< 1 %
- String Manipulation< 1 %
CASE Switch Data (End)< 1 %- Parallel Chunk End< 1 %
- OpenBabel< 1 %
- Legacy Date&Time to Date&Time< 1 %
String to Date&Time< 1 %Extract Date&Time Fields< 1 %- Create Bit Vector< 1 %
Cell Splitter< 1 %String To Number< 1 %- Table Partitioner< 1 %
- String to Number (PMML)< 1 %
- RowID< 1 %
- Counter Generation< 1 %
- Table to JSON< 1 %
- RDKit From InChI< 1 %
- Split Collection Column< 1 %
- Binary Objects to PNGs< 1 %
- Loop End (Column Append)< 1 %
Variable Condition Loop End< 1 %- Cross Joiner< 1 %
- Reference Row Filter< 1 %
Column Splitter< 1 %- Ungroup< 1 %
- Unpivot< 1 %
- Single sample t-test< 1 %
- Table Indexer< 1 %
Excel Writer (XLS)< 1 %- String to Date/Time (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Writer< 1 %- Column List Loop Start< 1 %
- Naive Bayes Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
Auto-Binner< 1 %- Cell Splitter By Position< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- Column to Grid< 1 %
Constant Value Column< 1 %- Reference Column Filter< 1 %
- String Splitter (Regex)< 1 %
- String Replacer< 1 %
- Statistics< 1 %
- Extract Table Spec< 1 %
Merge Variables< 1 %- Interactive Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- SDF Extractor< 1 %
DB Table Creator< 1 %- Time Series Generator< 1 %
- Column Expressions (legacy)< 1 %
- Generic Web Service Client< 1 %
- Java Snippet (simple)< 1 %
- Value Filter (legacy)< 1 %
- Table View (JavaScript) (legacy)< 1 %
- JSON Path< 1 %
- Date&Time-based Row Filter< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- XPath< 1 %
- HTTP Retriever< 1 %
- Benchmark End< 1 %
- Create Well Position< 1 %
Python Plot< 1 %- Similar fragments< 1 %
Active Learn Loop End< 1 %- URI to String< 1 %
- Wait...< 1 %
Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %- Table Row to Variable< 1 %
Table Row To Variable Loop Start< 1 %Database Delete< 1 %Database Connector< 1 %Parameterized Database Query< 1 %Database Table Creator< 1 %- Java Snippet< 1 %
Loop End< 1 %Counting Loop Start< 1 %Generic Loop Start< 1 %- Group Loop Start< 1 %
- Table Row to Variable Loop Start< 1 %
Variable Loop End< 1 %- Cluster Assigner< 1 %
- Decision Tree Predictor< 1 %
Random Forest Learner< 1 %- Numeric Binner< 1 %
- Case Converter< 1 %
- Cell Splitter< 1 %
- Number to Category (Apply)< 1 %
- Column Name Extractor< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Resorter< 1 %
- Extract Missing Value Cause< 1 %
- Reference Column Splitter< 1 %
- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Missing Value< 1 %
- Set Operator< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Data Explorer< 1 %
- Empty Table Switch< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Cache< 1 %
- Send Email< 1 %
- Timer Info< 1 %
- Histogram (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
Color Appender< 1 %- Color Manager< 1 %
- Save Workflow< 1 %
- Molecule Type Cast< 1 %
- SDF Writer< 1 %
- Parallel Chunk Start< 1 %
DB Loader< 1 %- Parameterized DB Query Reader< 1 %
- DB Reader< 1 %
DB Writer< 1 %- DB Row Filter< 1 %
- Boosting Learner Loop End< 1 %
PMML Predictor< 1 %- Table to H2O< 1 %
- Java IF (Table)< 1 %
- Tika Parser URL Input< 1 %
- Dictionary Replacer< 1 %
Dictionary tagger< 1 %- Strings to Document< 1 %
- Line Plot (JavaScript) (legacy)< 1 %
- Scatter Plot (JavaScript) (legacy)< 1 %
- Columns to JSON< 1 %
Python Script (1⇒1)< 1 %Python Script (2⇒1)< 1 %Python Script (1⇒1)< 1 %- R Snippet< 1 %
- Table to R< 1 %
- GET Request< 1 %
- Table Difference Checker< 1 %
- Database Connection Closer< 1 %
Date&Time Difference< 1 %Date&Time to String< 1 %String to Duration< 1 %- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Molecule to CDK< 1 %
Views
- This node has no views
Workflows
Links
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.