Skip to main content

This content has been archived and is no longer being updated.

Links may not function; however, this content may be relevant to outdated versions of the product.

Connecting to multiple databases with Data-Admin-DB-Name

Suggest edit Updated on September 13, 2021

Summary

A developer asks: Can I specify multiple database definitions in the pegarules.xml file?

if I do so, do I still need to specify them in the Data-Admin-DB-Name database definition form, and still need to map classes to tables in Process Commander?

Suggested Approach

Process Commander can connect to multiple relational databases. Each requires a Data-Admin-DB-Name instance.

There are three ways of linking a Data-Admin-DB-Name instance with the database:

  • Specify in the Database Name form that the details are to be obtained from the pegarules.xml file.   Choose this option when you plan to use a key ring file to encrypt the password.
  • Put the JDBC URL connection details right in the Data-Admin-DB-Name form.
  • Use a JDBC datasource from your Web application server. (This choice is not available for Apache Tomcat systems.)

The datasource is the preferred method.

In addition, create one or more Data-Admin-DB-Table instances to link Process Commander classes to database tables.

  • Previous topic An Entity-Relationship Diagram for work object tables in the PegaRULES database
  • Next topic Managing Elasticsearch index host nodes outside of the Search landing page
Did you find this content helpful? YesNo

100% found this useful

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us