Oracle Eloqua

The Lyftron Provider for Oracle Eloqua offers the most natural way to access Oracle Eloqua data from Lyftron with ease and also enables to connect with BI, MDM & ML tools, Data warehouses, Databases and other SAAS based applications with zero code and zero infrastructure requirements. The provider wraps the complexity of accessing Oracle Eloqua data into easy-to-integrate relational fully managed ANSI Sql format. Make faster and better business decisions with Lyftron’s Oracle Eloqua data provider and automatically build your data migration pipelines in minutes, not months

The provider hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.

Key Features

• Comprehensive Delta load mechanism.
• Real-time access to Oracle Eloqua.
• Comprehensive full support of ANSI Sql to query data with ease.
• Collaborative query processing.

Prerequisites

The user must have credentials for Oracle Eloqua, Lyftron and your destination data warehouse, lake or database to perform the data pipeline operation with Lyftron

Establishing a Connection with Lyftron's Quickstart Steps

Create your Oracle Eloqua connection with Lyftron by following the 5 easy steps show below:

Step1. Add your connection

Click on Connect section on the left panel →  Click on Add Connection button

Step2. Select your connector

In the connector selection panel, search and click Oracle Eloqua for your connection 

Step3. Enter your connection details

In the Connection String section enter the values of the below parameters. The following connection string is required to establish Oracle Eloqua connection with Lyftron.

"User=user;Password=password;Company=MyCompany"

Key	Value	Field
Connection Name	Enter your connection details	Required
User	Your Oracle Eloqua User	Required
Password	Your Oracle Eloqua password	Required
Company	Your Oracle Eloqua MyCompany	Required
Logfile**	Use the logfile option to debug your job and provide your connection name to generate the log file.  [ConnectionConfigurationPath]\Connection_name_log.tx	Optional
Verbosity**	Choose verbosity 1-5 based on the severity of debugging	Optional

** For more information, check the Lyftron logging and debugging section.

If you want more detailed information about how to establish a connection with Lyftron, click on Lyftron Connection Quick Start guide.

Step4. Test your connection

Once you are done entering your connection details, simply click on the Test Connection button to test the connectivity. In case your connection fails, add Logfile and Verbosity parameters and check the Lyftron logging and debugging section, to debug the error.

Step5. Save your connection

Hurray! Now you have successfully connected with the Lyftron Oracle Eloqua connector and can utilize the connector to Extract, Warehouse, Analyze, Visualize and Share your data.

Data Model

The provider models the data in Oracle Eloqua into a list of tables that can be queried using standard SQL statements.

Generally, querying Oracle Eloqua tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. 

Views

Name	Type	Description
Account	Tables	Create, update, delete, and query Accounts. This table is supported in bulk mode.
AccountGroup	Tables	Retrieve Account group.
Campaign	Tables	Create, update, delete, and query Campaigns.
Contact	Tables	Create, update, delete, and query Contacts. This table is supported in bulk mode.
ContactEmailSubscription	Tables	Retrieve all email group subscription status for the specific contact.
ContactSegment	Tables	Create, update, delete, and query Contact Segments.
ContentSection	Tables	Create, update, delete, and query Content Sections.
Custom	Tables	Create and delete custom.
Email	Tables	Create, update, delete, and query Emails.
EmailFooter	Tables	Create, update, delete, and query Email Footers.
EmailGroup	Tables	Create, update, delete, and query Email Groups.
EmailHeader	Tables	Create, update, delete, and query Email Headers.
Event	Tables	Create and delete Event.
ExternalActivity	Tables	Create and query External Activities. This table is not supported in bulk mode.
ExternalAsset	Tables	Create, update, delete, and query External Assets.
Folder	Tables	Create, update, delete, and query Folders.
Form	Tables	Create, update, delete, and query Forms.
Hyperlink	Tables	Create, update, delete, and query Hyperlinks.
LandingPage	Tables	Create, update, delete, and query Landing Pages.
Microsite	Tables	Create, update, delete, and query Microsites.
OptionList	Tables	Create, update, delete, and query Option Lists.
AccountField	Views	Retrieve Account Fields.
AccountView	Views	Retrieve Account Views.
Activity_Bounceback	Views	Retrieve Bounceback Activities. This table is only supported in bulk mode.
Activity_CampaignMembership	Views	Retrieve Campaign Membership Activities.
Activity_EmailClickThrough	Views	Retrieve Email Click Through Activities.
Activity_EmailOpen	Views	Retrieve Email Open Activities.
Activity_EmailSend	Views	Retrieve Email Send Activities.
Activity_EmailSubscribe	Views	Retrieve Email Subscribe Activities.
Activity_EmailUnsubscribe	Views	Retrieve Email Unsubscribe Activities.
Activity_FormSubmit	Views	Retrieve Form Submit Activities.
Activity_PageView	Views	Retrieve Page View Activities. This table is only supported in bulk mode.
Activity_WebVisit	Views	Retrieve Web Visit Activities.
CampaignElement	Views	Retrieve Campaign Elements.
CampaignField	Views	Retrieve Campaign Fields.
CampaignFolder	Views	Retrieve Campaign Folders.
ContactField	Views	Retrieve Contact Fields.
ContactFilter	Views	Retrieve Contact Filters.
ContactFilterFolder	Views	Retrieve Contact Filter Folders.
ContactList	Views	Create, update, delete, and query Contact Lists.
ContactListFolder	Views	Retrieve Contact List Folders.
ContactScoringModelFolder	Views	Retrieve Contact Scoring Model Folders.
ContactSegmentData	Views	Retrieve Eloqua Contact Segment Data.
ContactSegmentFolder	Views	Retrieve Contact Segment Folders.
ContactView	Views	Retrieve Contact Views.
ContentSectionFolder	Views	Retrieve Content Section Folders.
Dependencies	Views	Retrieve Dependencies.
DynamicContent	Views	Retrieve Dynamic Contents.
DynamicContentFolder	Views	Retrieve Dynamic Content Folders.
EmailDeployment	Views	Retrieve email deployments.
EmailFolder	Views	Retrieve Email Folders.
EmailFooterFolder	Views	Retrieve Email Footer Folders.
EmailHeaderFolder	Views	Retrieve Email Header Folders.
ExternalType	Views	Retrieve External Types.
FieldMerge	Views	Retrieve Field Merges.
FieldMergeFolder	Views	Retrieve Field Merge Folders.
FormElement	Views	Retrieve Form Elements.
FormFolder	Views	Retrieve Form Folders.
FormProcessingStep	Views	Retrieve Form Processing Steps.
HyperlinkFolder	Views	Retrieve Hyperlink Folders.
Image	Views	Retrieve Image.
ImageFolder	Views	Retrieve Image Folders.
ImportedFile	Views	Retrieve Imported Files.
ImportedFileFolder	Views	Retrieve Imported File Folders.
LandingPageFolder	Views	Retrieve Landing Page Folders.
LeadScoringModel	Views	Query Lead Scoring Models.
PageTag	Views	Retrieve Page Tags.
PageTagGroup	Views	Retrieve Page Tag Groups.
Program	Views	Retrieve Programs.
Style	Views	Retrieve Styles.
Template	Views	Retrieve Templates.
TemplateCategory	Views	Retrieve Template Categories.
TrackedUrl	Views	Retrieve Tracked Urls.
User	Views	Retrieve Users.
Visitor	Views	Retrieve Visitors.
VisitorProfileField	Views	Retrieve all of the visitor profile fields.