Configuring the BIX target database connection settings

If you want to use the Database Schema output format, add a second set of database connection settings that specify the target database where the extracted data is written to the prconfig.xml file provided in the configuration directory of your BIX distribution.

Before you begin: This functionality is available when you purchase and install the BIX application.

The BIX Database Schema output format writes the extracted data directly to a target database. To support this output, you must provide a second set of database connection settings specifying the target database where the data is to be loaded.

  1. In the BIX prconfig.xml file, copy and paste the database connection settings that you created for the source database.
  2. In each element name, change PegaRULES to the name of the database that you specified as the Output Database Name in the Extract rule. Refer to the following examples:
    Original path Updated path
    database/databases/PegaRULES/url database/databases/TargetDB/url
    database/databases/PegaRULES/userName database/databases/TargetDB/userName
    database/databases/PegaRULES/password database/databases/TargetDB/password
  3. Repeat the procedure used for the source database connection to set the target database connection settings to the appropriate values.
What to do next:  In addition to specifying the database connection settings, Oracle and UDB databases require some additional configuration. Consult your DBA to resolve requirements specific to your installation. More information is available in Pega Community article How to configure non-J2EE database connections in the prconfig.xml file.