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