Supported connectors

Database platforms

Serve as primary and auxiliary Data Warehouses, where data is used to define campaign targeting rules and segmentation, as well as store details for all outbound and inbound activity initiated by RPI.

Email Service providers

Execute dynamic and personalized email offers and collect event data (opens, clicks, bounces, etc.) for use within reporting or to trigger further actions within an Interaction workflow.

• SMS/mobile providers

• Mobile push notification (direct) providers

• Mobile push notification providers

Execute dynamic and personalized SMS offers and collect event data (e.g., delivered, failed, etc.) for use within reporting or to trigger further actions within an Interaction workflow. RPI also supports mobile push for broadcasting direct messages to Apple, Android, and Windows devices.

CRM platforms

An RPI offer can execute new or existing campaigns within CRM platforms. The event data is automatically collected and can be used to trigger further actions within an Interaction workflow, across other channels such as Email, SMS, Direct Mail, etc.

Data onboarding providers

Utilize these connectors to generate pre-defined or custom data files for automatic uploading and processing within the DMP and Social platforms.

External content providers

The ECP connectors provide connectivity to external content and digital asset management systems, and are used to store content (e.g., images, text) for use by RPI (e.g., in email offers or landing pages).

Cache providers

The Cache connectors allow RPI to store and access various data quickly (in-memory), such as Visitor Profiles, Realtime Decisions rules, and content. This allows immediate action within data dependent websites, without the delays of retrieving information back from the database.

Queue providers

The Queue connectors allow RPI access to inbound collection of data from sources like a web form submission. RPI can then act on this information in several ways, such as sending a follow up email after a purchase, executing Realtime decisions to display personalized landing page content, etc.

Web analytics providers

Enhance your links with our web analytics connectors and RPI will collect and store various metrics available from each of the providers.

Survey providers

Embed surveys within email offers and landing pages, and RPI will collect and display response stats within the application.

Miscellaneous web providers

Additional connectors available that will enhance widget, email, and landing page functionality within RPI.

AWS Redshift

AWS Redshift Relational Database Management System

Current

Primary & Auxiliary

Azure Database for MySQL

Azure’s managed MySQL database

v8

Primary & Auxiliary

Azure Database for PostgreSQL

Azure’s managed PostgreSQL database

v16

Primary & Auxiliary

Azure SQL Database

Microsoft’s Cloud managed database

v12.0.2000.8 (RTM)

Primary & Auxiliary

Google BigQuery

Google's cloud-based Data Warehouse, fully managed infrastructure designed for large data analysis.

Current

Primary & Auxiliary

Google Big Table

Google's hosted NoSQL database service

Current

Auxiliary Only

PostgreSQL

PostgreSQL object relational database management system

v16

Primary & Auxiliary

Snowflake

Cloud-based Data Warehouse

Current

Primary & Auxiliary

SQL Server

Microsoft relational database management system

2012, 2016, 2017, 2019, 2022

Primary & Auxiliary

Send Test Emails

Assets - Text Asset

Assets - HTML Asset

Assets - Image Asset

*

*

*

* Supports image assets via specification of an external folder at the channel configuration interface.

Assets - Smart Assets

*

* Dynamic content that contains nested dynamic content is not supported by Eloqua connector.

Assets - Table Asset

-

Assets - Web Form

Email Properties - Purpose

Email Properties - Date Format

-

Content containing Attributes

Dynamic Sender

-

Dynamic Sender - Send Test Emails

*

-

* Provision of preview parameters required.

Dynamic Email Name

-

Insert Link - External image

External image must be public.

Insert Link - URL attributes

Insert - Social Element - Facebook Like Image URL

-

-

-

Insert - Social Element - Facebook Like Share Content

-

-

-

Insert - Social Element - External button images

External image must be public.

Insert - Social Element - Image assets as button images

Insert - Social Element - Facebook Page

Insert - Forward to Friend

-

-

-

Insert - Social Element - Alchemer

Cell Sharing - Entire content

-

-

-

Cell Sharing - By region

-

-

-

Insert - Share Content - Facebook

-

-

-

External file in content

External file must be public.

Schedule delivery

-

-

View as web page

*

-

-

*If “Prevent HTML transforms” is turned on in offer template, delivered emails won’t contain web page link and footer.

Content mode

Bypass unsubscribes

*

-

-

-

*“Suppress marketing emails only” turned on at channel configuration.

Subscriber List Support

-

-

-

SMTP Service

-

-

-

Configurable Retry Period

-

-

Timely results data available

Asynchronous processing

-

-

-

Import via File

-

-

BCC email address

-

Queue Listener Supported

Email channels no longer require provision of Recipient email property.

Queue Listener Recommended

-*

*Unsuitable for use at queue listeners for the following reasons:

• Built using Batch Email Send API; overhead required for each send can cause performance issues when sending a single email at a time.

Supported at NoSQL

Smart Asset Determined using Attribute Values

Smart Asset Determined using Audience Segment Names

Smart Asset Determined using Model Project

Smart Asset Determined using Rules

Enable Trace supported

*

*Enable SOAP Trace

Reply To Email Address

-

-

Email-Realtime Smart Asset Support

Azure Keyvault

*

• Applied to email channels with password masking.

• * Tested for Salesforce Marketing Cloud Data Transfer

Dynamic BCC email address

-

-

-

Dynamic Reply-to Name

-

-

-

HIPAA-Compliant

-

-

-

Auto-suppress

Custom suppression table

Serial send

-

Batch send

-

Opt-out message

-

-

Enable API trace

-

Test using seeds

Test using seed groups

Links

Attribute personalization

Dynamic content

Targeted count

Delivered count

-

Failed count

Duplicates count

Queued count

-

Sending count

-

Sent count

Undelivered count

-

Invalid Phone Number count

-

-

Split when > 160 chars

-

Null nos. sent to provider

-

-

Invalid nos. sent to provider

Shorten URLs

Audience Selector

Allows the option to specify the type of audience to which a notification will be sent, e.g., Named User, Tag, Device Token, or Channel Id.

-

Send Message as Entire JSON Payload

When turned on, messages sent using the channel will use a JSON-formatted payload.

-

Notification Lifetime

Ability to specify how long a notification is valid (in seconds).

-

-

Targeted Devices

The ability to target specific devices (if known) for a recipient.

-

-

Collapsible

A collapsible message is a message that may be replaced by a new message if it has yet to be delivered to the device.

-

Use identity

The ability to target a specific user, e.g., alice@example.com.

-

-

Use tag

The ability to target a group of recipients.

-

-

Registration token

This specifies an attribute which contains data used to uniquely identify recipients.

-

-

Endpoint ID

This attribute is optional and contains data to uniquely identify recipients.

-

-

Channel type

This specifies the attribute used to identify the type of device, e.g., 'APNS' or 'GCM'.

-

--

High priority

Flags the message as high priority.

-

Message action

This specifies where a message recipient should be directed when selecting or tapping on a push notification (e.g., Home page, Landing Page, Web Page, Deep link, Share link).

-

-

Web Adapters

This specifies if the message contains a URL activity can be tracked and monitored.

-

-

Override Android

When turned on, Android devices will receive a custom message instead of the default.

-

Override iOS

When turned on, iOS devices will receive a custom message instead of the default.

-

Override SMS

When turned on, it allows an SMS message to be sent to the registered device.

-

-

Override Facebook

When turned on, it allows a FB message to be sent to the registered device.

-

-

Allows personalization

Attributes and Assets can be used in the Offer's content for personalization.

Queue listener

This specifies that the channel can be used in Queue Listener.

Send msg as entire JSON payload

Notification lifetime

-

-

Use Tags

Use registered tags

-

Collapsible

-

High priority

-

-

Message Content (Text Only)

-

Override Android

-

Override iOS

-

Override SMS

-

-

Override Facebook

-

-

Salesforce.com

Channels > CRM

The Salesforce.com connector will allow users to push Leads and Contacts to new and existing campaigns within the Salesforce.com platform. Data attributes can also be synced between the RPI primary data warehouse and the CRM platform.

Upon execution of the offer and subsequent channel synchronization, the following event data will be aggregated as well as individual records captured and stored in the primary data warehouse: Processed, Uploaded, Invalid Leads, and Total Errors.

Online

Facebook Offline Conversions

Channels > Data Onboarding > Facebook Audience

The Facebook Offline Conversions connector allows users to push offline data, such as in-store transactions, to the Facebook platform where it will be matched to determine how many customers viewed or selected on a Facebook Ad, prior to the event occurring.

N/A

Facebook Custom Audiences

Channels > Data Onboarding > Facebook Audience

The Facebook Custom Audience connector allows users to generate pre-defined and custom data files and pushes that data to the Facebook platform as either a new custom audience or appended to an existing custom audience. This process will generate a set of aggregated metrics, which can be viewed within the application.

N/A

Google Ads Customer Match

Channels > Data Onboarding

The Google Ads Customer Match connector allows users to generate customer list files and push the data to the Google Ads platform for targeting the matched users within campaigns across Search, Gmail, YouTube, or Display ads. The data can be generated as either a new Customer Match list or appended/deleted within an existing list.

N/A

LiveRamp

Channels > Data Onboarding > LiveRamp

The LiveRamp connector allows users to generate customer list files and push the data to the LiveRamp platform.

N/A

Use ECP-hosted image when inserting link

Hosting of Text assets

Hosting of HTML assets

Hosting of Image assets

Hosting of Smart assets

Hosting of Table assets

-

-

-

-

Hosting of File assets

-

-

-

Hosting of Audio files (If Public, rendered as hyperlink)

Hosting of Video files (If Public, rendered as hyperlink)

Following available at File Information Dialog - Details tab: Name, Type, Subtype, Folder, Domain name, Provider type, Provider name, File URL, Public, Modified, Created

Following available at File Information Dialog - Details tab: Thumbnail URL

-

-

-

-

Information available at File Information Dialog - Details tab when hosted file Not Public

-

-

-

-

Following available at File Information Dialog - Details tab when hosted file Public

Following available at File Information Dialog - Details tab: Created/Modified by

-

-

-

-

Metadata name/value pairs available at File Information Dialog - Details tab

-

Metadata tab available at File Information Dialog

-

Ability to add/remove/save changes to External Metadata available at File Information Dialog

-

Usage tab available at File Information Dialog

-

-

-

-

Ability to create new ECP root and subfolder at File System Dialog

-

Ability to upload to ECP root and subfolder at File System Dialog

Ability to delete ECP subfolder at File System Dialog

-

Following columns displayed at list at ECP root and subfolder at File System Dialog: Name, Type, Version, Date Modified, Date

Following columns displayed for ECP file at File System Dialog: Name, Type, Version, Date Modified

Ability to View Information for ECP file at File System Dialog

Ability to copy ECP file to folder from File System Dialog

Ability to download ECP file from File System Dialog

Ability to view following information at ECP subfolder in File System Dialog - Information Panel: Folder icon, 'External Folder', Name, Domain name, Modified, Created

-

Ability to view extra information for ECP files at File System Dialog - Information Panel: Modified by, Created by, Checking comment, Thumbnail URL

-

-

-

-

Information available at File System Dialog - Information Panel when hosted file Public

Information available at File System Dialog - Information Panel when hosted file Not Public

-

-

-

-

Ability to view metadata name/value pairs for ECP files at File System Dialog - Information Panel

-

Ability to use as a Web Publish Site

-

Ability to use as a Default file export location

Ability to use as External folder at email service provider

Azure CosmosDB

Cache

Azure’s managed NoSQL document-oriented database, utilizing the SQL API.

N/A

Azure Redis Cache

Cache

Azure Redis Cache is a fully managed and highly scalable open-source in-memory data store, built on the Redis platform.

N/A

Cassandra*

Cache

Open source, non-relational distributed database management system.

v3.9

MongoDB*

Cache

Open-source NoSQL database.

v2.2.4

Redis

Cache

Redis is an open-source, in-memory data store and managed on-premise.

N/A

Azure Event Hubs

Queue Provider

Azure Event Hubs is a highly scalable fully-managed Big Data streaming platform and event ingestion service.

Azure Service Bus *

Queue Provider

Azure Service Bus is a fully-managed enterprise integration message broker.

Azure Storage Queue *

Queue Provider

Azure Storage Queue is a fully-managed service for storing large numbers of messages.

Google Pub/Sub Queue Service

Queue Provider

Google Pub/Sub is a fully-managed Realtime messaging service.

RabbitMQ

Queue Provider

RabbitMQ is an open-source message queue service and managed on-premise. It is built on the Open Telecom Platform framework, allowing for clustering and failover options.

-

-

Kafka

Queue Provider

Kafka is a distributed streaming platform that provides a messaging system, a storage system, and a streaming platform in a single package.

-

-

-

Google Analytics

Web Adapter

Google Analytics adapters allow users to collate metrics gathered by Google based on the behavior of a contact witnessed at a website.

v3 (Analytics API)

Alchemer

Channels > Web

The Alchemer Web Channel allows users to embed survey links directly within email offers and landing pages. RPI will track the number of responses to an existing SurveyGizmo survey, and optionally transfer survey and respondent detail back into the data warehouse.

V5 API

Litmus

Miscellaneous

RPI uses Litmus to facilitate the “Test Inbox Delivery” functionality in the offer designer. While not exposed to the user, Litmus is used to perform inbox deliverability tests and spam check ratings.

N/A

Aux Database

Amazon Redshift Spectrum

Aux Database

Amazon Athena

Aux Database

Google Datastore

Cache

Memcached

Cache

MemoryDB Redis

CRM

Microsoft Dynamics CRM

Data Onboarding

Twitter Tailored Audience

Data Warehouse

Oracle

Data Warehouse

MySQL

Data Warehouse

Teradata

Data Warehouse

Azure SQL Data Warehouse

Data Warehouse

Yellowbrick

ECP

Drupal

ECP

WebDAV

ECP

WebDAM

ECP

Contentful

Email

Acoustic

Email

CheetahMail/Marigold

Email

Sparkpost

Email

Responsys

Email

dotdigital

Email

Amazon Simple Email Service

Email

Amazon Pinpoint

Miscellaneous

Litmus

NoSQL Database

Google DataStore

Push Direct

Airship Push Direct

Push Direct

Amazon Pinpoint

Queue

Amazon SQS

SMS

Amazon Pinpoint