Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Creating database instances for prconfig references

Updated on July 8, 2022

Create a database data instance so that Pega Platform can access a database whose connectivity is defined in the prconfig.xml file.

Before you begin: To use a configured reference, you must have identified the database and its connectivity parameters in the prconfig.xml file under database/databases and restarted the server. For more information, see Changing node settings by modifying the prconfig.xml file.
Not supported in Pega Cloud services environments.
  1. If the database platform of the additional database differs from the database platform of Pega Platform, or does not use postgresSQL, define Pega Platform the database driver. For more information, see Defining the database driver.
  2. In the header of Dev Studio, click CreateSysAdminDatabase.
  3. Enter a short description, and in the Database field, enter a name for the external database.
    The database name that you enter must be specified in the prconfig.xml file under database/databases. For example, for an entry that is named database/databases/AcmeDB, enter AcmeDB.
  4. Click Create and open.
  5. Optional: To indicate the system of record, in the Integration system field, press the Down arrow key, and then select the name of the integration system that you want to associate with this database.
    The value that you select is for informational purposes only, and does not affect the behavior of the database instance. You can use this value to organize rules for integration connectors, data types, and sources for data pages.
  6. In the How to connect list, click Use configuration in preferences.
  7. Optional: To specify the names of other database instances that views in this database can reach, on the Advanced tab, define the database parameters:
    1. In the Database Name list, click the Add item icon.
    2. In the Database Name field, press the Down arrow key, and then select the name of a database instance that views in the external database need to access.
    For example: This database instance describes the EXTERNAL1 database. To configure your application to access a view in EXTERNAL1 that joins data from the DATA1 and DATA2 databases, define database instances for DATA1 and DATA2, and then list DATA1 and DATA2 as other databases on the database instance for EXTERNAL1,
  8. Click Save.
  9. Optional: To test the database connection, on the Database tab, click Test connection.
    This test does not test the administrative user that you specify.
    1. Diagnostic information appears in a new window if the test fails.
    2. Modify the database instance until the test succeeds.
  • Previous topic Defining the database driver
  • Next topic Creating and updating external database instances with JDBC URLs

Related articles

Creating database data instancesDatabase data instances

Tags

Pega Platform 8.7 System Administration

Have a question? Get answers now.

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

Visit the Support Center

Did you find this content helpful?

Yes
No

Want to help us improve this content?
Suggest an edit

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