ReadJDBC

This node reads data from Relational Databases using JDBC and creates a DataFrame from it

Input

It reads data from Relational Databases

Output

It creates a DataFrame from the data read and sends it to its output

Type

dataset

Class

fire.nodes.dataset.NodeDatasetJDBC

Fields

Name Title Description
url URL The JDBC URL to connect to
user User User for connecting to the DB
password Password Password for connecting to the DB
dbtable DB Table The JDBC table that should be read. Note that anything that is valid in a FROM clause of a SQL query can be used. For example, instead of a full table you could also use a subquery in parentheses.
driver Driver The class name of the JDBC driver needed to connect to this URL
outputColNames Column Names of the Table Output Columns Names of the Table
outputColTypes Column Types of the Table Output Column Types of the Table
outputColFormats Column Formats Output Column Formats