DB configuration for Pega Personal Edition 8

Chys

I have installed Pega Personal Edition 8.4 and using postgres successfully.

I don't see PegaRULES and PegaDATA Schema at DB end(postgres). But i have noticed all Pega tables are available under 'data' schema as shown in attached screenshot

I wanted to know how do i map the manually created table at DB end to Pega class. (I know we create DB table instance to class and provide Db,Schema and table name to mapping, but it's not working when postgres Db and data schema is provided)

Please let me know if any additional configuration is needed.

Thanks in Advance 🙂

Karthick

Chys
In Database terminology we have a concept called as Synonym. It's a way of having an alias name for the actual database objects like table, views, schemas, etc..

The actual schema is data and pega has a synonym PegaData. both the reference should work. The same applies for Rules schema too.

azharrkv

When we install Pega personal edition, It internally creates rules and data schema in postgres database.

Follow the below steps to map a class to table in personal edition.

1) Create a table in the data schema of postgres database.

CREATE TABLE data.table_name_sample
	( 	column1 number(10) NOT NULL,
		column2 varchar2(50) NOT NULL,
		column3 varchar2(50)
	);

2) Create a class in pega
3) Create a Database Table Instance for the class created in step2 and configure the below.
In Database Field select PegaDATA from autopopulate
In Table Name Field enter the table we have created in the data schema table_name_sample