Hello everyone,
I am trying to read values from a ms sql / postgres sql database to be able to use them directly in a form as a selection list in an application.
Currently we are running as POC a Bonita community 2021.2 environment with a postgres sql db.
I have also already found a similar requirement in the Bonita community.
https://community.bonitasoft.com/questions-and-answers/how-do-you-display-business-variable-list-containing-sql-data-ui-table-widget
It's seems, that the solution approach, which is described at
https://github.com/Bonitasoft-Community/rest-api-sql-data-source
is only implementable for an older Bonita version. At least the documentation is created for Bonita 7.8.4 and is dated May 14, 2019.
When I try to import the application.xml, as described in the documentation, I get an error "Can't import Application".
Furthermore is a warning in the engine log:
WARNING [http-nio-8080-exec-3] org.bonitasoft.engine.api.impl.ServerAPIImpl.checkMethodAccessibility The API method org.bonitasoft.engine.api.TenantAdministrationAPI.installBusinessDataModel is deprecated. It will be deleted in a future release. Please plan to update your code to use the replacement method instead. Check the Javadoc for more details.
Is there a better/updated solution for Bonita >= 2021.2 to use selection fields in application forms with external sql-content (ms sql/ postgres sql)?
Many greetings
Bodo