Access external database from a page

Q&A
1

I see that I can use connectors in a process to get or send data. But how can I get data from an external database to show on an application page? And then how do I use the selected data to instantiate a process?

I want the user to access the application URL and be presented with a dashboard showing a table with rows of data coming from an external SQL database based on a query. The user would then need a way to click a link at the end of each row to trigger a process instance by sending the data in that row to be used in the process. The tasks in this process would then update that data and write back to the external SQL table.

2

Use AJAX calls to the the data…

Here is what we do:

create application page
create custom widget (no Angular necessary)
write your javascript code to call AJAX to return the data which you can then use to populate the custom widget.

Now to “clicking on the elements to start processes” will require some special handling. You need to build your links, buttons etc. as part of the custom widget.

regards
Seán

PS: If this reply answers your question, please mark a resolved

3

Sean,

Can you please direct me to a document/link that tells me how to build a custom groovy page? I am looking to access BDM data in my custom page but the ones I created from UI builder are html pages and also when I modify anything and re-zip and try to add to portal it gives me an error.

http://documentation.bonitasoft.com/how-access-and-display-business-data-custom-page-0

http://documentation.bonitasoft.com/pages#examples

These does not exactly tell me how to start building groovy pages

4

Thanks Sean for answering here and the new post :wink:

5

This is really a new question and not related to the previous, but hey what thee hell…

To get to the example Groovy and HTML pages you have to:

From Studio:

  1. Server → Open Portal
  2. Sign in with ??
  3. Change to Administrator
  4. Click on Resources
  5. Export Example Groovy!! HTML page
  6. Extract the example zip to a directory
  7. Edit the page
  8. save
  9. While in the extracted directory Select ALL
  10. Zip the contents and give it its name

Then you can upload it and see how it works…

regards
Seán