Skip to main content

Challenge

Writing action details to a database

4 Tasks

15 mins

Visible to all users
Beginner Pega Customer Decision Hub 8.7 English

Scenario

U+ Bank, a retail bank, is currently promoting multiple credit card offers by sending emails to qualified customers.

However, to comply with the security and spamming regulations, the bank decides to use a third-party email delivery service instead of using the inhouse email server. As a result, the offer details must be written to the database. The action details are then be shared with a third-party email distributor.

Use the following credentials to log in to the exercise system:

Role User name Password
Decisioning Architect DecisioningArchitect rules

Your assignment consists of the following tasks:

Task 1: Configure the Email flow template action

Under Contents > Actions, configure the Email flow template action to write action details to a database table by using the Generic DB Template.

Note: As the Email flow template action flow is used in all the credit card actions, the actions will automatically be updated to use the DB template.

Task 2: Examine the referred database template

In the Email flow template action flow Send Email shape properties, open and examine the referred database template to understand and be able to explain the configurations to someone.

Task 3: Configure schedule run

In the Next-Best-Action Designer -> Channels tab, configure and run a schedule run to write action details to the database template.

Note: In the Recurrence section, ensure the Refresh the audience check box is sledcted. Also, ensure that the All outbound customers segment is selected as strating population.
You must unselect the added volume constraints before running the outbound schedule.

Task 4: Verify that the action details are written to the database table

Under Contents > Templates, preview the Generic DB Template to confirm that the action details are written to the database table.

Note: The Preview option will download a .CSV file with actions details in it.

 

Challenge Walkthrough

You must initiate your own Pega instance to complete this Challenge.

Initialization may take up to 5 minutes so please be patient.

Detailed Tasks

1 Configure the Email flow template action

  1. On the exercise system landing page, click Pega CRM suite.
  2. Log in to Customer Decision Hub as the Decisioning Architect with User name DecisioningArchitect and Password rules.
  3. From the navigation pane on the left, click Content > Actions.
  4. Locate and open the Email flow template action.
  5. In the Email flow template, click Check out to make changes.
  6. Click the Flow tab.
    Email Flow Template
  7. Open the Send Email shape properties.
  8. Select Specify Treatment.
  9. In the Treatment Name list, select StandardCardEmail.
  10. Uncheck the Deliver Online check box.
  11. Check the Write to DB check box.
  12. In the Select Template list, select GenericDBTemplate.
    Send Email Properties
  13. Click Submit.
    Note: As the Email flow template action flow is used in all the credit card actions, the actions will automatically be updated to use the DB template.
  1. Check in to save the changes made.

2 Examine the referred database template

  1. In the Email flow template action, in the Flow tab, open the properties of the Send Email shape.
  2. To the right to the Select Template field, click the open icon.
    Open The DB Template
  3. Examine the database details specified in the database template.
    DB Template Definition
  4. Click the Fields tab to view the added customer and action details.
    DB Template Fields

3 Configure a schedule run

  1. In Next-Best-Action Designer, click the Channels tab.
  2. In the Primary Schedule section, click the More icon, and then select Suspend to suspend the current scheduled run.
    Suspend Schedule Run
    Note: If the Primary schedule is in Draft state, you can skip step 2.
  1. Click Edit to make changes to the run.
  2. Scroll down to the Primary Schedule section, and to the right of Recurrence, click the Gear icon to configure a schedule run frequency in the Configure outbound schedule window.
    Schedule Run Recurrence
  3. In the Start field, enter today's date. Ensure that the time is current and in U.S. EST time zone.
  4. In the End section, ensure No end data option is selected.
  5. Ensure that the Refresh the audience check box is selected.
  6. Click Submit to save outbound schedule and close the Configure outbound schedule window.
    Configure Outbound Schedule
  7. To the right of Volume constraints, click the Gear icon next to remove the added volume constraints.
    Volume Constraints
  8. Remove Limit credit card offers.
    Remove Constraints
  9. Click Apply.
  10. Click Save to save the changes made to the Channels tab.
  11. In the Channels tab, scroll down to the Primary Schedule section, and then click the More icon > Run to run the outbound schedule.
  12. Refresh the tab to view the latest status of the run.
  13. Once the run is complete, click COMPLETED to view the results.
    Run Results
    Note: Your run results number might not match the numbers shown in the exercise steps as the segment used in the exercise system selects a random sample of customers.

4 Verify that the action details are written to the database table

  1. After test completion, navigate to Contents > Treatments.
  2. Click the Database tab.
  3. Optional: Click Refresh to view the database template.
  4. On the Database landing page, expand the Generic DB Template row to view the number of staging records. The records match the number of actions shown in the run statistics.
    Database Template
  5. In the Generic DB Template row, click the More icon and select Preview to download the CSV file.
    Preview Details Written To DB Template
  6. When prompted, use Microsoft Excel to open the output file (you may have to enable pop-ups on your browser).
    Note: Notice that the number of records in the downloaded file matches the number of actions shown in the run statistics and the staging records. Also, you can verify that the Run_ID shown in the downloaded file is the same as the one displayed in the run details.
    DB Template Output File

This Challenge is to practice what you learned in the following Module:


Available in the following mission:

If you are having problems with your training, please review the Pega Academy Support FAQs.

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 Academy has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice