How to use DB in-connector?
I want to get data from the database and display it on the WEB screen table.
However, although it seems to use DB connector for the entrance connector, I do not know what to do in "definition of output operation".
Can you tell me what to do?
First of all can you clarify if you want to:
- Reuse data already stored in an existing database
- Starting a brand new development without preexisting data set?
Answer will depend on your use case. Thanks.
In order to answer your question I think I first need to clarify the architecture of a Bonita process.
A process is a series of tasks. Tasks will be executed by the Bonita Engine. For a human task engine wait for the user to submit the associated form before continuing the process execution.
In Bonita you usually store your data using the BDM feature. User will be able to input some data in a step form, submit the form, the data will be used to update step contract inputs and then contract inputs can be used in operations defined on the task or by connectors associated with the tasking being executed.
You can also have connector executed before the form is available to the user. They can be used to update business variables.
In the form you can also display business variables by getting the business variables using the APIs.
If you need to use an external existing database you need to be able first to display the data. For that you need to have the data available using a REST API (Bonita forms have variables that can be initialized with a REST API call). If you don't have such API already available you might take a look to the following community contribution: https://github.com/Bonitasoft-Community/rest-api-sql-data-source
Second thing you might want to do is to update the data in the database. To do so you need to declare a contract on the step and use the contract input as the input of a database connector.
Hope this will help you. If you need more assistance please share your process .bos file that you can create by exporting the process from Bonita Studio.