Insert - Insert a Record In a Database
Learn how to perform insert operations on a database.
The Insert operation takes a record as input and inserts that record in a database.
Example: To insert the data into the Device Sensor Data Model Entity.
Steps:
Click + under database operations to create the New Database operation.
Enter the Name of the operation and select type as Insert.
Click OK. The new component is created and displayed in the designer.
Click Edit in the top menu to open the Properties Panel.
Navigate to Properties > Data Source and select the required data source. You can create a new data source such as SQL Data Source under the settings.
Select the name of Entity or Data Model in Properties > Entity. This generates the insert instruction based on the entity schema automatically. The input parameters are strongly typed to the target table, meaning the parameter names must match the field Resource IDs in the entity schema.
If you want to write the instruction (SQL) instead of selecting the Entity, you can write the SQL instruction under Properties > Instruction.
Write down the SQL instruction in the editor and click OK.
Click SAVE to save the configuration.
