Configuring the BIX source database

Edit the prconfig.xml file provided in the configuration directory of your BIX distribution, adding database connection settings that specify the source Pega Platform database where data is extracted.

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

The prconfig.xml file contains sample database connection settings for a SQL database that you can modify for your Pega Platform database.

Note: The following steps outline the procedure for specifying typical database connection settings. 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.
  1. In the database/drivers element, change the value to the appropriate driver for your database. For example:
    Database Driver
    Oracle 9i/10g oracle.jdbc.OracleDriver
    IBM DB/2 Type 4 com.ibm.db2.jcc.DB2Driver
    SQL Server 2005 com.microsoft.sqlserver.jdbc.SQLServerDriver
    SQL Server 2000 com.microsoft.jdbc.sqlserver.SQLServerDriver
  2. In the database/databases/PegaRULES/url element, set the value to the connection URL for your database. Following are examples of the appropriate format for some supported databases:
    Database URL example
    Oracle jdbc:oracle:thin:@//serverName:port/service-name-or-SID
    DB/2 (Universal Driver) jdbc:db2://serverName:port/dbName
    SQL Server 2005 jdbc:sqlserver://your_sql_server_host:1433; SendStringParametersAsUnicode=false; SelectMethod=cursor; ProgramName=${NodeName}:${SystemName}.${ConnectionID}
  3. Set the value of database/databases/PegaRULES/userName and database/databases/PegaRULES/password to the user name and password of a user for the Pega Platform database.
  4. Set the value of database/databases/PegaDATA/userName and database/databases/PegaDATA/password to the user name and password of a user for the Pega Platform database.