Column Populator database properties

The database properties for the Column Populator are set in the prpcUtils.properties file.

Property	Description
pega.jdbc.driver.jar	The full path to the JDBC driver file for your database: Oracle : ojdbc#.jar where # indicates the Java version. Note that Java 7 and Java 8 both use the ojdbc7.jar file. DB/2 UDB: db2jcc.jar (universal driver) SQL Server: sqljdbc4.jar for Java versions 6, 7, and 8. PostgreSQL: postgresql-#.jdbc4.jar where # indicates the PostgresSQLversion.
pega.jdbc.driver.class	The class name of the JDBC driver for your database: Oracle 10g/11g: oracle.jdbc.OracleDriver IBM DB/2 Type 4: com.ibm.db2.jcc.DB2Driver SQL Server 2005, 2008: com.microsoft.sqlserver.jdbc.SQLServerDriver PostgreSQL: org.postgresql.Driver
pega.database.type	The type of database: Oracle 10g/11g: oracledate DB/2 UDB: udb SQL Server 2005, 2008: mssql PostgreSQL: postgres
pega.jdbc.url	The connection URL for your database, for example: Oracle : jdbc:oracle:thin:@//serverName:1521/service-name-or-SID DB/2 UDB: jdbc:db2://serverName:port/dbName SQL Server 2005, 2008: jdbc:sqlserver://serverName:1433; databaseName=your-DBname;SelectMethod=cursor; SendStringParametersAsUnicode=false; Include the SelectMethod and SendStringParametersAsUnicode parameters for SQL Server. PostgreSQL: jdbc:postgresql://localhost:5432/dbName
pega.jdbc.username pega.jdbc.password	The user name and password to use when connecting to your database.

Property