(warning) The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.

Oracle Marketing Cloud (Eloqua) Connector Documentation

User Persona: Paxata User - Paxata Admin - Data Source Admin

*Note: This document covers all configuration fields available during Connector setup. Some fields may have already been filled out by your Admin at an earlier step of configuration and may not be visible to you. For more information on Paxata’s Connector Framework, please see here.

Also: Your Admin may have named this Connector something else in the list of Data Sources.

Configuring Paxata

This connector allows you to connect to Oracle Marketing Cloud for library imports. The following parameters are used to configure the connection.

General

  • Name: Name of the data source as it will appear to users in the UI.

  • Description: Description of the data source as it will appear to users in the UI.

Something to consider: You may connect Paxata to multiple Oracle Marketing Cloud accounts and having a descriptive name can be a big help to users in identifying the appropriate data source.

Oracle Marketing Cloud Configuration

  • Company: The company for which the Oracle Marketing Cloud account is registered

  • User: The user of the Oracle Marketing Cloud account.

  • Password: The password of the Oracle Marketing Cloud user.

  • Timeout: The number of seconds to wait for an operation. The default value is 300 seconds. To allow for a longer wait time, increase this value. If set to 0, operations never time out.

Web Proxy Configuration

If you connect to Oracle Marketing Cloud through a proxy server, these fields define the proxy details.

  • Web Proxy: 'None' if no proxy is required or 'Proxied' if the connection to the Oracle Marketing Cloud account should be made via a proxy server. If a web proxy server is required, the following fields are required to enable a proxied connection.
  • Proxy host: The host name or IP address of the web proxy server.
  • Proxy port: The port on the proxy server for .
  • Proxy username: The username for the proxy server.
  • Proxy password: The password for the proxy server.
    *Leave username & password blank for an unauthenticated proxy connection

Data Import Information

Via Browsing

  • View the list of Oracle Marketing Objects table below.

Via SQL Query

  • Using a validSQL Select Query.
  • Query Limitations: Oracle Marketing Cloud has limited support on multiple conditions for querying.
    • SINGLE WHERE CLAUSE: In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it throw an error.
    • DATETIME NO EQUALS: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.
    • UPDATEDAT ONLY GREATER THAN: Additionally, the UpdatedAt column only supports filtering with the '>' operator.
    • Objects that exhibit these limitations are identified in the Oracle Marketing Objects table below.

Oracle Marketing Objects

NameDescriptionLimitations

Account

Browse and query Accounts. 


AccountGroup

Browse and query Account group.


Campaign

Browse and query Campaigns.


Contact

Browse and query Contacts. 


ContactEmailSubscription

Browse and query all email group subscription status for the specific contact.


ContactSegment

Browse and query Contact Segments.


ContentSection

Browse and query Content Sections.


Custom

Browse and query custom.


Email

Browse and query Emails.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

EmailFooter

Browse and query Email Footers.


EmailGroup

Browse and query Email Groups.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

EmailHeader

Browse and query Email Headers.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

Event

Browse and query Event.


ExternalActivity

Browse and query External Activities.


ExternalAsset

Browse and query External Assets.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

Folder

Browse and query Folders.


Form

Browse and query Forms.


Hyperlink

Browse and query Hyperlinks.


LandingPage

Browse and query Landing Pages.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

Microsite

Browse and query Microsites.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

OptionList

Browse and query Option Lists.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

AccountField

Browse and query Account Fields.


AccountView

Browse and query Account Views.


Activity_Bounceback

Browse and query Bounceback Activities. 


Activity_CampaignMembership

Browse and query Campaign Membership Activities.


Activity_EmailClickThrough

Browse and query Email Click Through Activities.


Activity_EmailOpen

Browse and query Email Open Activities.


Activity_EmailSend

Browse and query Email Send Activities.


Activity_EmailSubscribe

Browse and query Email Subscribe Activities.


Activity_EmailUnsubscribe

Browse and query Email Unsubscribe Activities.


Activity_FormSubmit

Browse and query Form Submit Activities.


Activity_PageView

Browse and query Page View Activities. 


Activity_WebVisit

Browse and query Web Visit Activities.


CampaignElement

Browse and query Campaign Elements.


CampaignField

Browse and query Campaign Fields.


CampaignFolder

Browse and query Campaign Folders.


ContactField

Browse and query Contact Fields.


ContactFilter

Browse and query Contact Filters.


ContactFilterFolder

Browse and query Contact Filter Folders.


ContactList

Browse and query Contact Lists.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

ContactListFolder

Browse and query Contact List Folders.


ContactScoringModelFolder

Browse and query Contact Scoring Model Folders.


ContactSegmentData

Browse and query Eloqua Contact Segment Data.


ContactSegmentFolder

Browse and query Contact Segment Folders.


ContactView

Browse and query Contact Views.


ContentSectionFolder

Browse and query Content Section Folders.


Dependencies

Browse and query Dependencies.


DynamicContent

Browse and query Dynamic Contents.


DynamicContentFolder

Browse and query Dynamic Content Folders.


EmailDeployment

Browse and query email deployments.


EmailFolder

Browse and query Email Folders.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

EmailFooterFolder

Browse and query Email Footer Folders.


EmailHeaderFolder

Browse and query Email Header Folders.


ExternalType

Browse and query External Types.


FieldMerge

Browse and query Field Merges.


FieldMergeFolder

Browse and query Field Merge Folders.


FormElement

Browse and query Form Elements.


FormFolder

Browse and query Form Folders.


FormProcessingStep

Browse and query Form Processing Steps.


HyperlinkFolder

Browse and query Hyperlink Folders.


Image

Browse and query Image.


ImageFolder

Browse and query Image Folders.


ImportedFile

Browse and query Imported Files.


ImportedFileFolder

Browse and query Imported File Folders.


LandingPageFolder

Browse and query Landing Page Folders.


LeadScoringModel

Browse and query Query Lead Scoring Models.


PageTag

Browse and query Page Tags.


PageTagGroup

Browse and query Page Tag Groups.


Program

Browse and query Programs.


Style

Browse and query Styles.


Template

Browse and query Templates.


TemplateCategory

Browse and query Template Categories.


TrackedUrl

Browse and query Tracked Urls.


User

Browse and query Users.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

Visitor

Browse and query Visitors.

SINGLE WHERE CLAUSE

DATETIME NO EQUALS

UPDATEDAT ONLY GREATER THAN

VisitorProfileField

Browse and query all of the visitor profile fields.


Technical Specs

Bulk API

  • This Connector will automatically negotiate usage of the Bulk API when possible.