Configuring the target database for BIX command-line extractions in on-premises systems
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.
This content only applies to on-premises systems and is not supported in Pega Cloud environments.
- In the BIX
prconfig.xmlfile, copy and paste the database connection settings that you created for the source database. - 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=" " /> - 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. - 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