Managing your Pega Platform database in Pega Cloud
Pega Cloud® supports certain database operations in Pega Platform™, including adding and deleting database columns and running queries on its composite schemas of
To interact with your Pega Platform database, Pega Cloud provides Schema Tools, Query Runner, and Query Inspector. You can also configure database tables (for example increase column length, create a table, or insert records into a table) through standard Pega Platform functions. You can also update records in the Pega Platform database by writing Java code or using ExecuteRDB SQL run through an Activity.
Pega Cloud-only Query Runner, Query Inspector, and Schema Tools for the Pega Platform database
A Pega Platform instance within Pega Cloud Services uses an internal database. You can interact with the database through Query Runner, Query Inspector, and Schema Tools after enabling them on your instance of Pega Platform. These tools offer functionality for managing your internal database to provide the same experience as on an on-premises system. Access to these tools requires the PegaRULES:DatabaseAdministrator role in your access group.
- Query Runner offers options to retrieve data that you pull from your Pega Platform database by using SELECT SQL statements. Query Runner is optimized to use SELECT statements only (instead of other types of SQL statements) for operators with read-only access to the database for the fastest return on your query.
- Query Inspector improves the SELECT statements that are used through the Query Runner. SELECT statements that you enter into the Query Runner generate the steps in the query statement through an EXPLAIN PLAN output. Use the EXPLAIN PLAN to improve query efficiency.
- Schema Tools extends a robust set of tools to administer your Pega Platform database, including viewing schema, increasing column size, adding or deleting indexes, and optimizing tables.
Query Runner and Query Inspector offer the following Pega Cloud-only functionality for interacting with your internal database. To learn how to manage SQL queries with Query Runner and Query Inspector, see the corresponding articles for each database task.
Run SQL queries
|Running SQL queries on Pega Cloud|
|View SQL query history||Viewing previously run queries|
|Export SQL queries||Exporting previously run query results|
|Analyze SQL queries with EXPLAIN PLAN||Using Query Inspector to improve SQL queries|
Schema Tools offers the following Pega Cloud-only functionality for interacting with your internal database. To learn how to view database schemas, see the corresponding articles for each database task.
|View database schema||Viewing database schema information|
|Increase column length||Increasing column length|
|View column BLOB size||Viewing column BLOB size|
|Collect table statistics||Updating statistics|
|Schedule BLOB size and table statistic updates||Scheduling schema updates|
|Defragment tables||Defragmenting tables|
|Create and remove indexes||Adding and deleting database indexes|
|View the history of actions taken using Schema Tools||Viewing history of Schema Tools actions|
Pega Platform gives you a range of capabilities to update your database schema, add or delete columns, insert database tables, and update records on your internal Pega Platform database.
The following articles describe the Pega Platform tasks that are required for Pega Cloud clients to perform the listed standard database operations.
|Add a database column|
|Delete a database column|
|Increase database column length|
|Altering a column type|
|Creating a database table|
|Inserting records into the database|
|Updating records on the database|
|Deleting records from the database|