Basic data question

Q&A
1

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

2

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.