Database¶
The Database node updates the selected database according to the selected action.
Node Type¶
Enterprise.
Input and Output Ability¶
This node has 1 entry point and 1 exit point. Both the input and the output are JSON.
Node Properties¶
Name
The name for this node.
Target Connection
The name of the target database connection, which can be created in EnOS Console Management > General Configurations > Connection Configurations.
Target Table
The table in the database to update.
Action
The update action, currently supporting Update or Insert, where rows that exist will be updated and rows that do not exist will be inserted.
Source Fields and Target Columns
The columns of the Target Table selected will be displayed under Target Column.
Enter the corresponding data to be updated/inserted under Source Field. Tick the corresponding checkbox(es) to match the data in the table. If the checked data matches the data in the table columns, the data in the table will be updated according to the data entered in Source Field. If no data is matched, a new row with the data entered in Source Field will be inserted in the table.
Note
At least one checkbox needs to be ticked.
Description
The description for this node.
Limitations¶
- As the database to connection to is not managed by EnOS, connection problems could occur due to server downtime or other instances that are not within our control.