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.
- 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 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.
- Inserting data records by using SQL
Use the ExecuteRDB SQL API to insert multiple records into your internal database in a batch through an activity. The ExecuteRDB SQL API directly inserts records in your database without requiring you to create a data object in Pega Platform.
- Updating data records by using SQL
Use the ExecuteRDB SQL API to directly update records in your database through an activity, without requiring you to update a data object in Pega Platform.
- Deleting data records by using SQL
Use the ExecuteRDB SQL API to delete records in your database through an activity, without requiring you to delete a data object in Pega Platform.
Previous topic Change the type of property rule in a higher ruleset version Next topic Inserting data records by using SQL