NodePostgreSQL Connector (legacy)

Source

This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.

This node creates a connection to a PostgreSQL server via its JDBC driver. You need to provide the server's hostname (or IP address), the port, and a database name. Login credentials can either be provided directly in the configuration or via credentials set on the workflow.

Output Ports

  1. Port Type: Database Connection
    A database JDBC connection

  1. Database Jam Session

    database credentials MySQL MongoDB Oracle MariaDB PostgreSQL MS SQL Server
    This workflow jams together data from not 1, not 2, but from 6 databases! That is: MySQL, MongoDB, MS SQL Server, MariaD…
    knime > Examples > 01_Data_Access > 02_Databases > 08_Database_Jam_Session

  2. Will they blend? Twitter and PostGreSQL Database

    data blending database PostGreSQL Twitter
    This is a mini-workflow for Data WareHousing, in particular it archiviates daily tweets.History is saved in a PostGreSQL…
    knime > Examples > 08_Other_Analytics_Types > 04_Social_Media > 01_Twitter_meets_PostgreSQL

  3. 01_Bioactivity_Prediction_Load_Pull_Data

    This workflow is the first one executed by the model factory. It pulls the data from the ChEMBLdb (https://www.ebi.ac.uk…
    knime > Examples > 50_Applications > 37_Monster_Model_Factory > Process > _Process_Step_Templates > workflows > Templates > 01_Bioactivity_Prediction_Load_Pull_Data