Managing the database by using data types
Add database columns and change the database column length by using the Data Type explorer in Dev Studio and the Integration Designer in App Studio. By updating the Pega Platform database through Data Types, you can use the same functionality as by updating your database directly. Updating your database through data types gives Pega Cloud clients another option to manage their database.
- Renaming a data object
Rename a data object to align its purpose with the label that users see in your data model.
- Changing the type of a field
To store data in a different format, change the type of a field.
- Deleting a data object
Remove data objects from your data model that are no longer relevant.
- Deleting data records in bulk
To remove data records more quickly, make your changes in bulk by importing a .csv file.
- Change the type of property rule in a higher ruleset version
You can create a property rule that overrides an existing property rule (one with the same name and the same or subclass Applies To key part) that is in a lower version of the ruleset or in a ruleset and version that is lower on your ruleset list. However, Pega Platform restricts the Type values for the new property.
- Managing your data model through SQL
Insert, update, and delete records through activities that use ExecuteRDB SQL API. The ExecuteRDB SQL API directly inserts records in your database without requiring you to create a data object in Pega Platform.
- Adding a database column by using the Data Type explorer in Dev Studio
Add a database column to your internal database by editing the columns in the Data Type Records tab.
- Changing database column length by using the Integration Designer
Edit the column length in a table in your internal database for properties that are associated with data objects.
Previous topic Deleting data records by using SQL Next topic Adding a database column by using the Data Type explorer in Dev Studio