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.

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

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

Open topic with navigation