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