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.
The prconfig.xml file contains sample database connection settings for a SQL database that you can modify for your Pega Platform database.
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 PDN article: How to configure non-J2EE database connections in the prconfig.xml file.
database/drivers
element, change the value to the appropriate driver for your database. For example: Database driver | Value |
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 |
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 driver | Value |
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} |
database/databases/PegaRULES/userName
and database/databases/PegaRULES/password
to the user name and password of a user for the Pega Platform database.database/databases/PegaDATA/userName
and database/databases/PegaDATA/password
to the user name and password of a user for the Pega Platform database.This functionality is available when you purchase and install the BIX application.