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.
-
In the BIX
prconfig.xml
file, copy and paste the database
connection settings that you created for the source database.
-
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 |
-
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.