Oracle Responsys Marketing Cloud Connector Setup Guide

This article describes how to set up the Oracle Responsys Marketing Cloud connector.

Connector actions

Action Name	AudienceStream	EventStream
Merge List Recipients	✓	✓
Merge Profile Extension Recipients	✓	✓
Merge Table Records	✓	✓
Trigger Custom Event	✓	✓

Batch limits

This connector uses batched requests to support high-volume data transfers to the vendor. For more information, see Batched Actions. Requests are queued until one of the following thresholds is met or the profile is published:

Max number of requests: 100
Max time since oldest request: 60 minutes
Max size of requests: 1 MB

Configure settings

Navigate to the Connector Marketplace and add a new connector. For general instructions on how to add a connector, see the About Connectors article.

After adding the connector, configure the following settings:

API Username
API Password
Login Endpoint

Action settings - parameters and options

Click Next or go to the Actions tab. This is where you configure connector actions.

This section describes how to set up parameters and options for each action.

Action - Merge List Recipients

Parameters

Parameter	Description
List Name	Required
Default Permission Status	Optional Values are Opt In or Opt Out.
Match Columns	Optional The column name to be used to match the recipient record to the Profile Extension records.
Match Operator	Optional Operator to join match column names.
Update Strategy	Optional Controls how the existing record should be updated. No Update — When selected, if an existing record is matched, no update will happen (Insert only). Replace All — When selected, if an existing record is matched, all the properties configured will be updated.
HTML Value	Optional Value of incoming preferred email format data. Example: `H` may represent a preference for HTML-formatted email.
Opt In Value	Optional Value of incoming opt-in status data that represents an opt-in status. Example: `I` may represent an opt-in status.
Opt Out Value	Optional Value of incoming opt-out status data that represents an opt-out status. Example: `O` may represent an opt-out status.
Reject Record if Channel Empty	Optional String containing a comma-separated channel codes that will result in record rejection when the channel address filed is null. Channel codes are: E – Email M – Mobile P – Postal Code Example" `"E,M"` indicates that a record that has a null value for the email or mobile number value should be rejected.
Text Value	Optional Value of incoming preferred email format data. Example: `T` may represent a preference for text-formatted email.

Action - Merge Profile Extension Recipients

Parameters

Parameter	Description
List Name	Required
Profile Extension Table (PET) Name	Profile extension table name.
Update Strategy	Required Controls how the existing record should be updated. No Update — When selected, if an existing record is matched, no update will happen (Insert only). Replace All — When selected, if an existing record is matched, all the properties configured will be updated.
Match Columns	The column name to be used to match the recipient record to the profile extension records. Options are: Recipient ID (RIID) Customer ID Email Address Mobile Number Email (MD5 hashed) Email (SHA 256 hashed)
Map Template Name	Optional Specify a mapping template configured in Oracle Responsys.

Action - Merge Table Records

Parameters

Parameter	Description
Folder Name	Required
Table Name	Required
Update Strategy	Required Controls how the existing record should be updated. No Update — When selected, if an existing record is matched, no update will happen (Insert only). Replace All — When selected, if an existing record is matched, all the properties configured will be updated.
Match Columns	The column name to be used to match the recipient record to the Supplemental Table records.
Map Template Name	Optional Specify a mapping template configured in Oracle Responsys.

Action - Trigger Custom Event

Parameters

Parameter	Description
Event Name	Required Custom Event Name
Folder Name	Required
Object Name	Required Profile List Name
Email Format	Required Values are Text or HTML.
Customer ID	Customer ID
Email Address	Email Address
Mobile Number	Mobile Number
Mobile Number	Mobile Number
Number Data Mapping	Optional
Date Data Mapping	Optional
String Data Mapping	Optional
Optional Data	Optional

Vendor documentation

Oracle Marketing Cloud - Oracle Responsys API

Pega Webhook

Oracle Responsys (SOAP API)

Was this page helpful?

This page was last updated: August 20, 2024