Deprecated node mapping
This reference lists deprecated database nodes alongside their replacements in the current KNIME Database Extension. Use this table when migrating workflows manually or when reviewing the output of the Workflow Migration Tool.
For step-by-step migration instructions, see Migrate deprecated database workflows.
Node mapping
| Deprecated node | Current node |
|---|---|
| Amazon Athena Connector | Amazon Athena Connector |
| Amazon Redshift Connector | Amazon Redshift Connector |
| Database Apply-Binner | DB Apply-Binner |
| Database Auto-Binner | DB Auto-Binner |
| Database Column Filter | DB Column Filter |
| Database Column Rename | DB Column Rename |
| Database Connection Table Reader | DB Reader |
| Database Connection Table Writer | DB Connection Table Writer |
| Database Connector | DB Connector |
| Database Delete | DB Delete (Table) or DB Delete (Filter) |
| Database Drop Table | DB Table Remover |
| Database GroupBy | DB GroupBy |
| Database Joiner | DB Joiner |
| Database Looping | DB Looping |
| Database Numeric-Binner | DB Numeric-Binner |
| Database Pivot | DB Pivot |
| Database Query | DB Query |
| Database Reader | DB Query Reader |
| Database Row Filter | DB Row Filter |
| Database Sampling | DB Row Sampling |
| Database Sorter | DB Sorter |
| Database SQL Executor | DB SQL Executor |
| Database Table Connector | DB Connector + DB Table Selector |
| Database Table Creator | DB Table Creator |
| Database Table Selector | DB Table Selector |
| Database Update | DB Update |
| Database Writer | DB Writer |
| H2 Connector | H2 Connector |
| Hive Connector | Hive Connector |
| Hive Loader | DB Loader |
| Impala Connector | Impala Connector |
| Impala Loader | DB Loader |
| Microsoft SQL Server Connector | Microsoft SQL Server Connector |
| MySQL Connector | MySQL Connector |
| Parameterized Database Query | Parameterized DB Query Reader |
| PostgreSQL Connector | PostgreSQL Connector |
| SQL Extract | DB Query Extractor |
| SQL Inject | DB Query Injector |
| SQLite Connector | SQLite Connector |
| Vertica Connector | Vertica Connector |
| — | Microsoft Access Connector (new, no deprecated equivalent) |
| — | DB Insert (new, no deprecated equivalent) |
| — | DB Merge (new, no deprecated equivalent) |
| — | DB Column Rename (Regex) (new, no deprecated equivalent) |
| — | DB Partitioning (new, no deprecated equivalent) |
| — | DB Type Mapper (new, no deprecated equivalent) |
Register drivers for the deprecated framework
The JDBC driver registration page for the deprecated framework no longer appears in KNIME preferences. To register a driver for the legacy Database Connector (deprecated) node, create a preferences file manually.
- Create a text file named
driver.epfwith the following content:
text
\!/=
/instance/org.knime.workbench.core/database_drivers=<PATH_TO_THE_JDBC_DRIVER>
file_export_version=3.0Replace
<PATH_TO_THE_JDBC_DRIVER>with the path to the driver.jarfile. To register multiple drivers, separate paths with a semicolon (;).Example for Windows with two drivers:
text
\!/=
/instance/org.knime.workbench.core/database_drivers=C\:\\KNIME\\JDBC\\db2\\db2jcc4.jar;C\:\\KNIME\\JDBC\\Neo4J\\neo4j-jdbc-driver-3.4.0.jar
file_export_version=3.0On Windows, escape each backslash with a second backslash.
- Import the file via File → Import Preferences.
- Restart KNIME Analytics Platform.
TIP
To register drivers for the current framework (for example, the DB Connector node), use the standard preferences dialog instead. See Register a JDBC driver.