Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Extending the data model in Pega Customer Decision Hub

Updated on July 22, 2021

Speed up your implementation process by extending the Customer Analytics Record (CAR) data model to suit your business needs.

The first part of any project is planning and analyzing your data. Pega Customer Decision Hub for Communications provides the data attributes for you in the form of a data model (CAR) that you can build upon to create a personalized, extended Customer Analytics Record (xCAR).

In general, an xCAR is a single object that holds extra data from multiple sources. For example, you can extend a customer record with their purchase history, subscriptions, activity on social media platforms, and so on.

Pega provides the CAR as a fully formed data model that is updated on an as-needed basis and published independently from Pega releases. You can download the Communications Customer Analytical Data Model component from Pega Marketplace and use the model in Next-Best-Action Designer in the following ways:

  1. Create the following classes in your implementation layer that inherit from the standard classes that you want to extend:

    1. YourOrganization-Data-Comms-Account class that inherits directly from PegaCDH-Data-Comms-Account.

    2. YourOrganization-Data-Comms-Subscription class that inherits directly from PegaCDH-Data-Comms-Subscription.

    3. YourOrganization-Data-Comms-Holding class that inherits directly from PegaCDH-Data-Comms-Holding.

    For more information, see Creating classes
  2. Copy the table definitions of the classes that you created:

    1. In the navigation pane of Dev Studio, click RecordsSysAdminDatabase Table.

    2. In the Class name column, search for PegaCDH-Data-Comms-Account, and then open the record by clicking it.

    3. Click Test connectivity.

  3. Use the Results browser tab for reference to create your own table definitions for Account, Subscription, and Holding, for example, UComm-Data-Comms-Account.

  4. Edit the data table rule for each of your classes to map them to the database tables, for example, UComm-Data-Comms-Account maps to ucomm_account.

  5. Extend the data model with a new property in the Account, Subscriber, or Holding class:

    1. Create a new property.

      For more information, see Properties.
    2. Add the new property, for example, SocialSecurityNumber, to your Account implementation class, for example, UComm-Data-Comms-Account.

    3. Add the new column, for example, social_security_number, to your Account table definition, for example, ucomm_account.

    4. Update the external mapping of your Account implementation to map the column to the property.

    5. Modify the ETL procedure to populate the new property.

  6. If you want to modify a property that already exists in the data model, for example by changing the type of the PaymentPlusStatus property from Text to Number:

    1. Add the modified property to your Account implementation class with the name and the type, for example, by adding PaymentPlusStatusNum to the UComm-Data-Comms-Account.

    2. Add the new column to your Account table definition, for example by creating the payment_plus_status_num column in ucomm_account.

    3. Update the external mapping of your Account implementation to map the column to the property.

      The payment_plus_status_num column name maps to the .PaymentPlusStatusNum property.
    4. Modify the ETL procedure to populate the property.

  7. Resave the Context Dictionary configuration.

  • Previous topic Communications Customer Analytical Data Model Guide
  • Next topic Creating a discount using CAR data in Pega Customer Decision Hub

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us