Send query results to Oracle Responsys

Oracle Responsys is an email marketing product that helps improve conversions, strengthen customer relationships, and dramatically lessen messaging fragmentation.

Important

After files are delivered to Oracle Responsys from Amperity you must configure an job (one time or recurring) that imports this data into a profile list or profile extension table using Connect.

This topic describes the steps that are required to send CSV files to Oracle Responsys from Amperity:

  1. Build a query

  2. Add orchestration

  3. Run orchestration

  4. Import results to Oracle Responsys

Note

Oracle Responsys must be enabled before you can configure an orchestration to send query results.

Build query

You will need to build a query that shapes the data so that fields in the output can be mapped to the fields required by Oracle Responsys.

Add orchestration

An orchestration defines the relationship between query results and a destination, including the location to which those query results will be sent and the frequency at which the orchestration will be run.

To add an orchestration

  1. From the Destinations tab, click Add Orchestration. This opens the Add Orchestration dialog box.

  2. From the Object Type drop-down, select Query.

  3. From the Object drop-down, select the query for which results will be sent to Oracle Responsys.

  4. From the Destination drop-down, select a destination that is configured for sending data to Oracle Responsys.

  5. From the Data Template drop-down, select a data template.

  6. Verify all settings.

  7. Set the workflow to Manual. (You can change this to automatic later, after verifying the end-to-end workflow.)

  8. Click Save.

Run orchestration

Run the orchestration manually to validate that it works.

To run the orchestration

  1. From the Destinations tab, under Orchestrations, open the    menu for the Oracle Responsys orchestration, and then select Run.

  2. The Status column for the orchestration will update to say “Waiting to start…”, after which the notifications pane will update to include a notification that shows the current status.

  3. When the orchestration has run successfully, the status is updated to “Completed”.

Import results to Reponsys

After these files are delivered to Oracle Responsys you must import this data into a profile list or profile extension table using Connect.

  • A profile list stores information for all customers, and then maintains a profile.

  • A profile extension table stores additional attributes that define behavioral, demographic, or profile preference characteristics for your customer profiles.

Caution

The following steps outline how you should expect to do this from the Connect interace within Oracle Responsys. You should review these steps to ensure that you have a full understanding of the end to end workflow. The following steps are focused on how to ensure those configuration details match what is sent from Amperity.

To import results to Oracle Responsys

Tip

See the Oracle Responsys help center page for complete steps on importing results from Amperity. This section provides an overview, and then highlights specific settings as they relate to how you configured your results to be sent from Amperity.

  1. From the Data side navigation bar, select Connect > Create Job > Import Profile Data. Add the required details to describe the job, and then click Done.

  2. Connect to a server.

    If you sent data to a server that is hosted by Oracle Responsys, click Responsys File Server.

    If you sent data to a server that is not hosted by Oracle Responsys, click External server by SFTP.

  3. Provide information about the file to be imported. Use the following table to understand how settings in Amperity relate to settings required by Oracle Responsys:

    Amperity setting

    Oracle Responsys setting

    Filename template

    The full name and extension of the file. For example: “ACMEResponsysChurn_2021-11-13.csv”.

    File to upload

    This must match the name of the file that was exported from Amperity.

    (None)

    Amperity supports UTF-8 character sets automatically.

    Character set

    Set this value to UTF-8.

    File format

    Configure Amperity for the CSV file format.

    Field delimiter

    Set this value to “,” (comma).

    Amperity

    Enable the Header option to use column names as column headers in your output.

    First line contains column names

    Select this checkbox if Include header row in output files is selected in Amperity.

    PGP public key

    Use this setting to provide a public encryption key.

    File is encrypted with PGP/GPG key

    Select this checkbox when Amperity provides a public encryption key to ensure that it can be decrypted by Oracle Responsys before uploading.

  4. Set the target definition to be a profile list or a profile extension table.

  5. Map the columns from the file sent from Amperity to the fields in the target definition.

    Important

    These fields must match the fields sent from Amperity, regardless of if it is from a campaign or if it is from an orchestration (queries or database export).

  6. Select any post processing action to take after the job is successful, such as launching a campaign from Oracle Responsys.

  7. Configure email notification (success or failure) for this job.

  8. Schedule the job to run once or on a recurring schedule.