Skip to content

Click in-app to access the full platform documentation for your version of DataRobot.

Oracle Marketing Cloud (Eloqua) Connector for Data Prep

User Persona: Data Prep User, Data Prep Admin, or Data Source Admin

Note

This document covers all configuration fields available during connector setup. Some fields may have already been filled out by your Administrator at an earlier step of configuration and may not be visible to you. For more information on Data Prep's connector framework, see Data Prep Connector setup. Also, your Admin may have named this connector something else in the list of Data Sources.

Configure Data Prep

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.

Tip

You can connect Data Prep to multiple Oracle Marketing Cloud accounts. Using 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

See the Oracle Marketing Objects table.

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.

Oracle Marketing Objects

Name Description Limitations
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.


Updated October 28, 2021
Back to top