Is the SQL to create the BPMS / BRMS database available?

Solution Unverified - Updated -

Issue

I am trying to configure JBoss Enterprise BRMS to use SQL Server as it's DB repository. However, I wish that the database tables/indexes (to be used by JBoss Enterprise BRMS) are created from SQL scripts.

  • Can you please provide me the SQL to create the tables/indexes used by JBoss Enterprise BRMS database? The only work around I can think of is to install JBoss Enterprise BRMS which is already configured with SQL Server, and then export the DDL for the database.
  • Is there further documentation on the database including an E-R design and whether querying the database from outside of JBoss Enterprise BRMS is supported? i.e. Is the design subject to change without notification?

Environment

  • JBoss BRMS
    • 5.x
    • 6.x
  • JBoss BPM Suite
    • 6.x
  • Red Hat Decision Manager - RHDM
    • 7.x
  • Red Hat Process Automation Manager - RHPAM
    • 7.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content