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