Python Script (DB) (deprecated)

Manipulator

Allows execution of a Python script in a local Python installation. The path to the Python executable has to be configured in Preferences → KNIME → Python.

NOTICE: The nodes uses the JayDeBeApi library to establish a connection to the database via a JDBC connection which his included. However to use JayDeBeApi JPype needs to be installed. For Windows precompiled libraries can be download from Unofficial Windows Binaries for Python Extension Packages.

Input Ports

  1. Type: Database Query An input database connection that provides all relevant information needed to connect to the database and an input SQL query used to initially fetch data from the database. In the Python script, it is available as DBUtil object under the name <i>db_util</i>.

Output Ports

  1. Type: Database Query A database connection with the result table containing data from the database. The data in the result table is fetched either using the automatically defined output SQL query by the <i>db_util</i> or using the output SQL query defined by the user by executing the <i>db_util.set_output_query()</i> method.

Find here

Scripting

Make sure to have this extension installed:

Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site

How to install extensions