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 7 Platform database where data is extracted.

The prconfig.xml file contains sample database connection settings for an Oracle database:

<env name=”database/drivers” value=”oracle.jdbc.OracleDriver” />
<env name=”database/databases/PegaRULES/url” value=”jdbc:icrosoft:sqlserver://localhost:1433;SelectMethod=cursor;
SendStringParametersAsUnicode=false;ProgramName=PR ${SystemName}@${NodeName} ${DBName} #${ConnectionID}” />
<env name=”database/databases/PegaRULES/username” value=”a_username” />
<env name=”database/databases/PegaRULES/password" value="a_password" />


Modify this code as needed for your Pega 7 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 PDN 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	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

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 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}

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 7 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 7 Platform database.

Open topic with navigation