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 .
- Type: Database QueryDBAn 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 .