Skip to content
KNIME Documentation
Main Navigation Get startedBuildWork with KnimeAccount and adminRelease notesDeveloper tools
Community Hub
DevelopersKnime
Sidebar Navigation

Getting Started

Installation

User Guide

Release Notes

Install Extensions

Building Workflows

Components

Flow Control

Expressions

File Handling

Deployment

Integrated Deployment

Workflow Invocation

Best Practices

Advanced Features

AI Extension

Get Started

Build an Agent

Inject context with RAG

LLM Providers

Tutorials

Summarize product reviews

Product FAQ assistant

Restaurant agent

Your first local agent

Task extractor

Reporting

Kerberos

Extensions

Database

Overview

Tutorials

Read and filter data from a database

Write a transformed dataset to a database

Concepts

Ports and Sessions

Query Generation

Type Mapping

Deprecated Framework

Connecting

Connect: Dedicated Node

Connect: File-Based Database

Connect: Generic DB Connector

Register a JDBC Driver

Install Third-Party Driver Plug-in

Drivers on Hub and Server

Kerberos Constrained Delegation

Reading and Transforming

Read Data

Transform Data Visually

Run a Custom SQL Query

Parameterize a Query

Writing and Modifying

Insert, Update, or Merge

Delete Rows

Bulk Load Data

Create and Remove Tables

Use Transactions

Reference

Connector Node Settings

JDBC Driver Reference

Deprecated Node Mapping

Migrate Deprecated Workflows

Python

Overview

Tutorials

Python Scripting Quickstart

Data App Development Using Plotly

Data Processing

K-AI Scripting Assistant

Data Type Conversion

Batch Processing

Jupyter Integration

Environment Management

Pixi Configuration

Dependency Management

Environment Persistence

Channel Mirrors & Air-Gapped Setups

Conda Migration

Alternative Configurations

Conda and Miniforge Setup

Conda Environment Propagation

Manual Python Configuration

Legacy Node Migration

Concepts

Pixi Backend Architecture

Storage Logic

Python Environments on Executors

Reference

Python Scripting API

Bundled Packages

Executor and Hub Configuration

Troubleshooting Guide

API Reference

Inputs and outputs

Classes

Views

Utility functions

R

Deep Learning

Snowflake

Google Cloud

Azure

AWS

Big Data

Big Data Admin

Big Data Secured Cluster

Databricks

Microsoft Fabric

Power BI

Tableau

Report Designer

H2O

Changelogs

Version 5.12

Version 5.11

Version 5.10

Version 5.9

Version 5.8

Version 5.7

Version 5.6

Version 5.5

Version 5.3

Extensions

Migrate deprecated database workflows ​

Use the Workflow Migration Tool to convert workflows that use deprecated database nodes to their current equivalents. The tool creates a migrated copy without modifying the original workflow.

Before you begin ​

  • Open the workflow you want to migrate in KNIME Analytics Platform.
  • Re-register any JDBC drivers you previously used. Drivers registered for the deprecated framework must be re-registered for the current framework. See Register a JDBC driver.

Migrate a workflow ​

Run the Workflow Migration Tool to convert deprecated database nodes to their current equivalents.

  1. Open the workflow that contains deprecated database nodes. A banner appears at the top of the workflow editor.
  2. Click Migrate workflow… to open the migration wizard.
  3. Confirm the workflow to migrate and set a name for the migrated copy. By default, the name appends (migrated) to the original.
  4. Click Next. The wizard analyses the workflow and lists all deprecated nodes with available migration rules and their replacements. Review any highlighted issues.
  5. Click Next to perform the migration.
  6. Review the migration report. Warnings and issues are highlighted. Save the report as HTML if needed.
  7. Click Finish. The migrated workflow opens with deprecated nodes replaced by their current counterparts.

The original workflow remains unchanged throughout the process.

Disable the migration banner ​

To stop KNIME from prompting you to migrate a specific workflow:

  1. Click Disable this message in the migration banner.
  2. In Preferences → Databases, clear Offer the migration of workflows that contain deprecated database nodes.
  3. Click Apply and Close.

To re-enable the prompt, return to Preferences → Databases and select the checkbox.

Next steps ​

  • Register a JDBC driver
  • Connect to a database using a dedicated connector node

Related pages ​

  • Deprecated node mapping
  • Deprecated database framework
Pager
Next pageInstallation