How are changes to BDM handled?

Submitted by sanjay_6 on Sun, 05/01/2016 - 05:24
1
0
-1

How is the evolution of BDM handled? Adding or removing columns (fields), renaming, and other operations. I don't see any documentation on this. Is this done outside of Bonita by accessing the DB directly?

BDM
Migrations
2 answers

Submitted by Sean McP on Sun, 05/01/2016 - 16:38
1
0
-1
This one is the BEST answer!

Be very careful in using BDM editing...you could cause serious problems...

There is no documentation on the management of BDM's as such, and as you have found out.

If you use the BDM editor in Studio you should be fine if you DO NOT delete things.

Bonitasoft are aware of the issue and have added changes to BDM into their roadmap as documented here:
http://community.bonitasoft.com/ideas/fix-bdm-so-it-can-merge-items-rath...

Adding fields and queries in general works, Deleting fields could cause everything to stop (for that BDM). Changing Indexes may not work.

You would have to edit all your forms and pages and REST calls as well, make sure you have an Asset index of how and where BDM's and fields are used. I know this is facility is not in Community. It would be good to have such a report available :)

Prior to the changes being made by Bonitasoft be aware that Importing a BDM will overwrite the current one. Completely. So if you have two developers make sure they are using the same BDM, exactly the same BDM.

regards
Seán

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

Submitted by sean.zhang_1 on Sun, 05/01/2016 - 08:16
1
0
-1

Database DDL on BDM is handled by BonitaBPM platform itself, there's no need to do manual steps outside of Bonita.

Because of this, DB user that Bonita BPM is using to access BDM database must have sufficient permission to run DDL statement.

Comments

Submitted by sanjay_6 on Sun, 05/01/2016 - 14:47

Thanks for your answer!

I don't see this in the docs anywhere.

Can you please point me in the right direction?

How would I go about making schema changes?

Permalink
Submitted by sean.zhang_1 on Sun, 05/01/2016 - 16:53

In same way as you create new BDM..from Development -> Business Data Model -> Manage..., you can make any changes, and choose reset BDM database from dialog popup after clicking finish button. But, as Sean McP pointed in his answer, making changes on BDM schema is very critical, and may cause data lose in production database. So you must be very careful on this.

Permalink
Submitted by sanjay_6 on Sun, 05/01/2016 - 17:10

Thanks!

That was very helpful.

Permalink
Notifications