You are here: Business Intelligence Exchange (BIX) > Configuring the extraction environment > Configuring the BIX target database connection settings

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.

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:
  3. 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

  4. Repeat the procedure used for the source database connection to set the target database connection settings to the appropriate values.

Note: 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 PDN article How to configure non-J2EE database connections in the prconfig.xml file.

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