NodePython 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. Port 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 db_util.

Output Ports

  1. Port 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 db_util or using the output SQL query defined by the user by executing the db_util.set_output_query() method.