Configuring the source database for BIX command-line extractions
Configure the source database by editing the
prbootstrap.properties
and prconfig.xml
files in
the configuration directory of your BIX distribution to add database connection settings that
specify Pega Platform database from which you extract data. Configuring the
source database permits command line extractions
prconfig.xml
file contains sample database connection settings for an SQL
database that you can modify for your Pega Platform database. Open the
prbootstrap.properties
file with your text and source-code editor, such as Notepad++.Uncomment (remove the # symbol) from the following lines:
com.pega.pegarules.bootstrap.allclasses.dbcpsource=example.oracle
example.oracle.url=jdbc:oracle:thin:@hostname:1521:rules11g
example.oracle.jdbc.class=oracle.jdbc.OracleDriverle.oracle.username=<username>
example.oracle.password=<password>
com.pega.pegarules.bootstrap.allclasses.schema=<rule schema>
com.pega.pegarules.bootstrap.datatables.schema=<data schema>
Enter your source database information to the elements in the uncommented lines.
Replaceexample
andoracle
in each element with your database name and the database type as in the following examples. Include angle brackets (<>) as shown in specific input values.For the
com.pega.pegarules.bootstrap.allclasses.dbcpsource
element, enter NameForDatabase.DatabaseType.For the
NameForDatabase.Database.url=
element, enter the Database URL.For additional database URL details, refer to your database documentation.For the
NameForDatabase.Database.username=<username>
element, enter Username for database connection.For the
NameForDatabase.Database.password=<password>
element, enter Password for database connection.For the
Database.jdbc.class=
element, enter Database driver class.For additional database driver details, refer to your database documentation.For the
com.pega.pegarules.bootstrap.allclasses.schema=
element, enter <rule schema of source database>.For the
com.pega.pegarules.bootstrap.datatables.schema=
element, enter <data schema of source database>.
Save and close the
prbootstrap.properties
file.Open the
prconfig.xml
file with your text and source-code editor, such as Notepad++.Uncomment (remove the #) from the following lines:
<env name="database/drivers" value="oracle.jdbc.OracleDriver;com.ibm.db2.jcc.DB2Driver" />
<env name="database/databases/PegaRULES/url" value=" jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false" />
<env name="database/databases/PegaRULES/userName" value="a_username" />
<env name="database/databases/PegaRULES/password" value="a_password " />
<env name="database/databases/PegaDATA/url" value="jdbc:sqlserver://serverName:1433;SelectMethod=cursor;SendStringParametersAsUnicode=false " />
Above the line containing the element
<env name="database/drivers" value=" " />
, add the following elements:<env name="database/databases/PegaDATA/userName" value="a_username " />
<env name="database/databases/PegaDATA/password" value="a_password " />
Enter your source database schema information to the elements in the uncommented lines.
Replace the exampleOracle
input values with input values for your source database in quotation marks as shown in the following entries.For the
<env name="database/databases/PegaRULES/defaultSchema" value=" " />
element, enter "name of the rule schema of source database".For the
<env name="database/databases/PegaDATA/defaultSchema" value=" " />
element, enter "name of the data schema for source database".For the
<env name="database/drivers" value=" " />
element, enter "Database driver class".For additional database driver details, refer to your database documentation.For the
<env name="database/databases/PegaRULES/url" value=" " />
element, enter "database URL".For additional database URL details, refer to your database documentation.For the
<env name="database/databases/PegaDATA/userName" value= />
element, enter "database username".For the
<env name="database/databases/PegaDATA/password" value="a_password" />
element, enter "database password".For the
<env name="database/databases/PegaRULES/userName" value="a_username" />
element, enter "database username".For the
<env name="database/databases/PegaRULES/password" value="a_password" />
element, enter "database password".
If you chose the Database Schema format for the BIX extraction process when you created the Extract rule, configure your target database. For details, see Configuring the target database for BIX command-line extractions.
Previous topic Understanding BIX command-line extractions Next topic Configuring the target database for BIX command-line extractions