Configuring a Database

Enable orchestration with other system by inserting/updating/deleting database row or updating a raw sequel. This will be executed for every record in the Journey.

About this task

To configure a Database, complete the following steps:

Procedure

  1. From the Journey control panel within the Palette, drag-and-drop the Database control to the required part on Canvas.
    The Database Configuration dialog appears.
  2. Provide values for the following fields:
    • Name - Mandatory
    • Description - Optional
  3. Add Offers - Check the checkbox I want to associate Offers to this touchpoint
    Select Offers button will get enabled.
  4. Click on Select Offers.
  5. The Offers screen from Centralized Offer Management appears. User can select one or multiple offers from the list of offers displayed or double click on the offer to select from the offer variant.
    Note: On Database Touchpoint, Select Offers button will be enabled only when user sets the partition setting for the Journey
  6. From Select Channel of communication dropdown, select the required communication channel.
  7. Click Next.
    The Create New Action page appears.
  8. Default database connection is reflected in the Existing Connection field. Also, the defined properties of the database are reflected in the respective property fields. Select the required connection from the available connections.
  9. Click Next.
    The Field Mapping page appears.
  10. Map the Database Fields with Journey Fields.
  11. Click Save.