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. | |
| 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.