LinkedIn
Copied!

Table of Contents

Managing your data model through SQL

Version:

Only available versions of this content are shown in the dropdown

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.

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.