Rajani Kanth Anupoju (RajaniKanth)

RajaniKanth Member since 2011 20 posts
Posted: December 2, 2016
Last activity: March 27, 2017
Posted: 2 Dec 2016 15:29 EST
Last activity: 27 Mar 2017 9:23 EDT

Database Tool within developer studio to execute SIMPLE database queries

Traditionally Pega developers used to have database access within DEV & QA environments and hence they used to run any queries using any Developer tools (TOAD/ SQL Developer, etc) to execute queries.

But in recent times most of the customers are denying the database access to the developers and asking them to file requests which is teadious job & time consuming. Hence developers write some activity or a report defintion to execute queries that they want to view the responses for simplest queries. So it would be good if Pega provides a simple database querying tool within developer portal which will have access till QA environment. I know this can be acheivable using OOTB but looking for a simple UI which does the BASIC SQL jobs rather than multiple different ways.

Usecases :

1) Developer has exposed a column & wanted to confirm whether the value is getting populated or not.

2) View to look at a row of a table which satisfies a condition

3) View the record count of a table

***Updated by Moderator: Marissa to add FDBK ID to post***