Basic data question
I have a table in a SQL database that is updated by another system that just adds rows to this table. This table has 20 columns and 10 column values come from this system. Now I need to create a Bonita application that would periodically pick new data rows from this table, run a process against each row data and update the remaining columns of the row as the case proceeds.
What is the recommended strategy? Do I need to use connectors to bring in the newly created rows data and then copy it as a business object in H2 BDM & use connects after every step to replicate the data back to SQL or is it better to make the SQL database as the BDM and that table a business object? This is confusing as I read the documentation. Any pointers will be a great help.
Thanks,
Udit Sud
What is the recommended strategy? Do I need to use connectors to bring in the newly created rows data and then copy it as a business object in H2 BDM & use connects after every step to replicate the data back to SQL or is it better to make the SQL database as the BDM and that table a business object? This is confusing as I read the documentation. Any pointers will be a great help.
I wouldn't use any BDO's in this case.
I would just do the following
Create diagram
Task 1 - get resultSet from Database, on output Convert data to List of List
Task 2 - Update Data
Task 3 - write data back to database.
That's all that's needed in this case,
regards
Seán
PS: If this reply answers your question, please mark a resolved.