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.5 English
This content has been updated. Click here to continue your progress on the latest version.

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 Analyst CDHAnalyst rules
Caution: To reuse the exercise system from a previous challenge, first complete the Configuring volume constraints challenge. Otherwise, click Initialize Pega or Reset Instance in this challenge.

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 a 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 selected. Also, ensure that the All mailable customers segment is selected as starting population. You must unselect the added volume constraints before running the outbound schedule.

Task 4: Confirm your results

Under Contents > Treatments, 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. Log in as Decisioning Analyst with user name CDHAnalyst and password rules.
  2. From the navigation pane on the left, click Content > Actions.
  3. Locate and open the Email flow template action.
  4. In the Email flow template, click Check out to make changes.
  5. Click the Flow tab.
    Action flow
  6. Open the Send Email shape properties.
  7. Select Specify Treatment.
  8. In the Treatment Name list, select StandardCardEmail.
  9. Uncheck the Deliver Online check box.
  10. Check the Write to DB check box.
  11. In the Select Template list, select GenericDBTemplate.
    send email template
  12. 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. Click 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.
    send email template
  3. Examine the database details specified in the database template.
    Db template
  4. Click the Fields tab to view the added customer and action details.
    customer and offer details

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 run
    Note: If the Primary schedule is in Draft state, you can skip step 2.
  3. Click Edit to make changes to the run.
    Edit Channels tab
  4. 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.
    Edit run recurrence
  5. In the Start field, enter today’s date. Ensure that the time is current and in U.S. EST time zone.
  6. Ensure that the Refresh the audience check box is selected.
    recurrence window
  7. Click Submit to save outbound schedule and close the Configure outbound schedule window.
  8. To the right of Volume constraints, click the Gear icon next to remove the added volume constraints.
    Volume constraints settings
  9. Remove Limit credit card offers.
    Unselect volume constraints
  10. Click Apply.
  11. Click Save to save the changes made to the Channels tab.
  12. In the Channels tab, scroll down to the Primary Schedule section, and then click the More icon > Run to run the outbound schedule.
  13. Refresh the tab to view the latest status of the run.
  14. 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 100 customers in each run.

4 Confirm your results

  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.
    DB template staging
  5. In the Generic DB Template row, click the More icon and select Preview to download the CSV file.
    Preview DB template file
  6. ​​​​​​When prompted, use Microsoft Excel to open the output file (you may have to enable pop-ups on your browser).
    Action details to DB
    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.


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