The activity “Data Service” can be configured to read, write, update or delete your data in the database deployed by Simplifier DB Designer without writing any line of SQL Statements.
Technically the solution based on the latest OData V4 Protocol – open and state-of-the-art.
You will find the activity in the left menu of the process designer.
The ‘Load Dataset’ configuration reads a list of data from the database and display them in appropiate widget that support the view of list elements (technically aggregations) like a list or table widget.
The shape can also be used to reload a list of data records after editing an entity.
The selected entity set will determine which data entity / table is loaded.
The input mappings of the activity have to be configured to hold all necessary id properties of the chosen data set (primary key columns of database table)
The selected properties are then available for mapping.
To create a new data record the shape has to be configured as ‘Create Data’.
In the input mappings the fields of the record can be filled with data provided by widgets or variables.
The new data will be sent to the server via the OData interface of the DB Designer.
It is important that the data is formated in the correct way.
To delete a data record you have to configure the activity as ‘Delete Data’.
The data record of the entity with the provided id column(s) will be removed from the database.
An activity configured as “Write Data” will update the database record.
The ‘Reset Changes’ activity will discard the changes made to datarecord(s) before you update or create this in the database (database commit) and therefore reset the values to the initially loaded values.