Question
UMKC
US
Last activity: 22 May 2024 3:38 EDT
How view database from cloud community edition
I used to have Pega Personal edition before and I always used PgAdmin to view the database tables and the records.
I'm currently using cloud community edition, so I want to know if there's any way I can view the data from pegadata tables.
Any suggestions on a rule which helps view database tables ?
***Edited by Moderator Rupashree S. to add Capability tags***
Accepted Solution
Updated: 22 May 2024 1:40 EDT
Maantic Inc
IN
If you have PegaRULES:DatabaseAdministrator role added to you access group, you'll be able to see the table columns, length etc. You cannot see the data in the table from the community edition directly, instead you can write your own reports to retrieve or use the query runner to write your own SQL.
Lventur
IN
When we are in Pega Cloud we will not be able to view the database information.
From PDC we will be to get high level information about DB like overall DB size, table size etc...
Accepted Solution
Updated: 22 May 2024 1:40 EDT
Maantic Inc
IN
If you have PegaRULES:DatabaseAdministrator role added to you access group, you'll be able to see the table columns, length etc. You cannot see the data in the table from the community edition directly, instead you can write your own reports to retrieve or use the query runner to write your own SQL.