Save JDBC¶
This node writes data to databases using JDBC.
Type¶
transform
Class¶
fire.nodes.save.NodeSaveJDBC1
Fields¶
Name |
Title |
Description |
|---|---|---|
connection |
Connection |
The JDBC connection to connect |
jdbcDatabase |
Database |
Database for connecting to the JDBC |
jdbctable |
Table |
JDBC Table from which to read the data |
truncate |
Truncate |
Whether to truncate the table in case Save Mode is Overwrite |
saveMode |
Save Mode |
Whether to Append, Overwrite or Error if the table Exists |
properties |
Properties |
|
extraOptionsKeys |
Properties Name |
Extra options/properites available while executing in Save JDBC. |
extraOptionsValues |
Properties Value |
Config Values for the Corresponding properites name |
Details¶
Save JDBC Node Details¶
This node writes data to databases using JDBC.
Parameters to be set:¶
OUTPUT STORAGE LEVEL: Keep this as DEFAULT.
CONNECTION: Select the desired database connection to use.
DB TABLE: Specify the name of the database table where the data will be written.
TRUNCATE: Choose whether to truncate (delete all existing data from) the table before writing (true or false).
SAVE MODE: Choose how to save existing data in the table (Append, Overwrite, ErrorIfExists, Ignore).
-Append: If data/table already exists, contents of the table are to be appended to existing data.
-Overwrite: If table already exists, existing data is overwritten by the new content.
-ErrorIfExists: If data already exists, an exception is thrown and operation stops.
-Ignore: If table already exists, the save operation is ignored.