Skip to main content


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

Configuring the target database for BIX command-line extractions in on-premises systems

Updated on April 6, 2022

The BIX Database Schema output format writes the extracted data directly to a target database. If you want to use the Database Schema output format for the BIX command-line extraction process, add a second set of database connection settings in the prconfig.xml file that specify the target database into which you extract data.

To support this output, provide a second set of database connection settings specifying the target database where you want to load the data.

This content only applies to on-premises systems and is not supported in Pega Cloud environments.

Before you begin: You must configure the source database before configuring the target database. For details, see Configuring the source database for BIX command-line extractions.
  • You must have access to the prconfig file located in the following distribution directory: PRPC-8.x.x-8xx\Additional_Products\BIX\config\prconfig.xml
  • You must have access to the following target database information:
    • The Output Database name you defined when creating the Extract rule.
    • The database type (PostgreSQL, Oracle, IBM) used for the target database, including the Java Database Connectivity (JDBC) URL. See your database documentation for details.
    • The rule schema name of the target database.
    • The data schema name of the target database.
    • The username and password credentials for the target database.
  1. In the BIX prconfig.xml file, copy and paste the database connection settings that you created for the source database.
  2. Below the line containing the element <env name="database/databases/PegaDATA/password" value="a_password" />, copy the following the database connection elements for the target database:
    <env name="database/databases/<TargetDBName>/defaultSchema" value=" " /><env name="database/databases/<TargetDBName>/username" value=" " /><env name="database/databases/<TargetDBName>/password" value=" " />
  3. In each element name, change the string <TargetDBName> to the name of the target database that you specified as the Output Database Name in the Extract rule.
    For example:
    Original elementUpdated element
    database/databases/PegaRULES/urldatabase/databases/TargetDB/url
    database/databases/PegaRULES/userNamedatabase/databases/TargetDB/userName
    database/databases/PegaRULES/passworddatabase/databases/TargetDB/password
  4. Create a formatted database table for the command-line extraction process by generating a DDL file. For more information, see Generating a DDL file for command-line Database Schema extractions. For more information, consult your database administrator and see the Pega Community article How to configure non-J2EE database connections in the prconfig.xml file.
  • Previous topic Configuring the source database for BIX command-line extractions in on-premises systems
  • Next topic Configuring optional prconfig.xml settings in on-premises systems

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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