Eloqua

Eloqua enables marketers to plan and execute campaigns while delivering a personalized customer experience for their prospects.

Eloqua integration replicates data using the Oracle Eloqua Marketing Cloud Service REST API and Eloqua bulk export API.

See the Schema section for a list of objects available for replication.

進一步查看此連接器，包括實用的連結和支援的功能。

功能	支援詳細資訊
支援的 Qlik Talend Data Integration 專案	僅複寫專案。不支援資料管道專案。
目標更新方法	複寫任務：套用變更儲存變更在資料湖中登陸資料任務：變更資料擷取 (CDC)
管理中繼資料	不需要手動產生中繼資料。
結構描述演進	僅支援變更欄資料類型操作。
LOB 欄 (NCLOB、CLOB 和 BLOB) 複寫	不支援。
已排程 CDC	必填。此為目標與來源的變更保持同步的方式。對於複寫任務，請參閱排程任務對於湖登陸任務，請參閱排程湖登陸任務的 CDC
通知	部分支援設定變更進行時的通知
監控	僅限 CDC，因為此連接器與完整載入無關。監控個別資料任務
自動解除 JSON 欄裝載的巢狀結構	不支援。來源資料集中的 JSON 欄裝載不會在目標上自動解除巢狀結構。

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

確認您使用的帳戶可讀取您要擷取的表格。

To obtain you client ID and secret:

Log into your Eloqua account as an account administrator.
Navigate to AppCloud Developer Console > Settings.
Under Platform Extensions, choose AppCloud Developer.
Under App Type, select Interactive or Web App.
Make sure Authorized Redirect URIs is set to https://connector.qlik.com/auth/oauth/v3.htm.
After the client ID and secret have been generated, copy and paste them to a secured file as they are displayed only once.

Creating the connection

如需詳細資訊，請參閱連線到 SaaS 應用程式。

在您填入所需的連線設定時按一下驗證。
可能會要求您登入來源應用程式。
會顯示一個視窗，其中有驗證代碼。
將代碼複製到剪貼簿並返回連線對話方塊。
在使用來源提供的代碼完成驗證中貼上代碼並按一下驗證。
提示備註您可能需要向下捲動以查看此欄位。
若狀態是已驗證，代表已進行了驗證。
在連線名稱中提供連線名稱。
選取開啟連線中繼資料以在建立後定義連線的中繼資料。

Connection settings
Setting	Description
Data gateway	如您的使用情況有需要，選取資料移動閘道。資訊備註此欄位無法用於 Qlik Talend Cloud 啟動器訂閱，因為不支援資料移動閘道。若您有另一個訂閱層級且不想使用資料移動閘道，選取無。如需關於資料移動閘道福利的資訊以及需要此項的使用案例，請參閱 Qlik 資料閘道 - 資料移動。
Start Date	以 `MM/DD/YYYY` 格式輸入資料必須從來源複寫到目標的日期。
Client ID	Client ID.
Client Secret	Client secret.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

accounts

The accounts table contains info about the accounts, or companies, in your Eloqua account.

Note: This table is replicated using the Eloqua Bulk API.

Custom accounts fields

If applicable, Stitch will replicate custom fields related to accounts in Eloqua.

Replication Method	CDC
Primary Key	Id
Replication Key	UpdatedAt
Useful links	Eloqua API method

CompanyIDExt

STRING

CreatedAt

DATE-TIME

Custom Fields

VARIES

STRING

UpdatedAt

DATE-TIME

activity_bounceback

The activity_bounceback table contains info about Bounceback contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_bounceback with	on
assets	activity_bounceback.AssetId = assets.id
activity_email_clickthrough	activity_bounceback.AssetId = activity_email_clickthrough.AssetId activity_bounceback.CampaignId = activity_email_clickthrough.CampaignId activity_bounceback.ContactId = activity_email_clickthrough.ContactId
activity_email_open	activity_bounceback.AssetId = activity_email_open.AssetId activity_bounceback.CampaignId = activity_email_open.CampaignId activity_bounceback.ContactId = activity_email_open.ContactId
activity_email_send	activity_bounceback.AssetId = activity_email_send.AssetId activity_bounceback.CampaignId = activity_email_send.CampaignId activity_bounceback.ContactId = activity_email_send.ContactId
activity_form_submit	activity_bounceback.AssetId = activity_form_submit.AssetId activity_bounceback.CampaignId = activity_form_submit.CampaignId activity_bounceback.ContactId = activity_form_submit.ContactId
activity_page_view	activity_bounceback.AssetId = activity_page_view.AssetId activity_bounceback.CampaignId = activity_page_view.CampaignId activity_bounceback.ContactId = activity_page_view.ContactId
activity_subscribe	activity_bounceback.AssetId = activity_subscribe.AssetId activity_bounceback.CampaignId = activity_subscribe.CampaignId activity_bounceback.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_bounceback.AssetId = activity_unsubscribe.AssetId activity_bounceback.CampaignId = activity_unsubscribe.CampaignId activity_bounceback.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_bounceback.AssetId = activity_web_visit.AssetId
campaigns	activity_bounceback.CampaignId = campaigns.id
forms	activity_bounceback.CampaignId = forms.processingSteps.campaignId
contacts	activity_bounceback.ContactId = contacts.Id
visitors	activity_bounceback.ContactId = visitors.contactId

ActivityDate

DATE-TIME

ActivityId

STRING

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

DeploymentId

STRING

EmailAddress

STRING

EmailRecipientId

STRING

ExternalId

STRING

SmtpErrorCode

STRING

SmtpStatusCode

STRING

Type

STRING

updatedAt

DATE-TIME

activity_email_clickthrough

The activity_email_clickthrough table contains info about EmailClickthrough contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_email_clickthrough with	on
assets	activity_email_clickthrough.AssetId = assets.id
activity_bounceback	activity_email_clickthrough.AssetId = activity_bounceback.AssetId activity_email_clickthrough.CampaignId = activity_bounceback.CampaignId activity_email_clickthrough.ContactId = activity_bounceback.ContactId
activity_email_open	activity_email_clickthrough.AssetId = activity_email_open.AssetId activity_email_clickthrough.CampaignId = activity_email_open.CampaignId activity_email_clickthrough.ContactId = activity_email_open.ContactId activity_email_clickthrough.VisitorId = activity_email_open.VisitorId
activity_email_send	activity_email_clickthrough.AssetId = activity_email_send.AssetId activity_email_clickthrough.CampaignId = activity_email_send.CampaignId activity_email_clickthrough.ContactId = activity_email_send.ContactId
activity_form_submit	activity_email_clickthrough.AssetId = activity_form_submit.AssetId activity_email_clickthrough.CampaignId = activity_form_submit.CampaignId activity_email_clickthrough.ContactId = activity_form_submit.ContactId activity_email_clickthrough.VisitorId = activity_form_submit.VisitorId
activity_page_view	activity_email_clickthrough.AssetId = activity_page_view.AssetId activity_email_clickthrough.CampaignId = activity_page_view.CampaignId activity_email_clickthrough.ContactId = activity_page_view.ContactId activity_email_clickthrough.VisitorId = activity_page_view.VisitorId
activity_subscribe	activity_email_clickthrough.AssetId = activity_subscribe.AssetId activity_email_clickthrough.CampaignId = activity_subscribe.CampaignId activity_email_clickthrough.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_email_clickthrough.AssetId = activity_unsubscribe.AssetId activity_email_clickthrough.CampaignId = activity_unsubscribe.CampaignId activity_email_clickthrough.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_email_clickthrough.AssetId = activity_web_visit.AssetId
campaigns	activity_email_clickthrough.CampaignId = campaigns.id
forms	activity_email_clickthrough.CampaignId = forms.processingSteps.campaignId
contacts	activity_email_clickthrough.ContactId = contacts.Id
visitors	activity_email_clickthrough.ContactId = visitors.contactId activity_email_clickthrough.VisitorId = visitors.id

ActivityDate

DATE-TIME

ActivityId

STRING

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

DeploymentId

STRING

EmailAddress

STRING

EmailClickedThruLink

STRING

EmailRecipientId

STRING

EmailSendType

STRING

EmailWebLink

STRING

ExternalId

STRING

IpAddress

STRING

SubjectLine

STRING

Type

STRING

VisitorExternalId

STRING

VisitorId

STRING

updatedAt

DATE-TIME

activity_email_open

The activity_email_open table contains info about EmailOpen contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_email_open with	on
assets	activity_email_open.AssetId = assets.id
activity_bounceback	activity_email_open.AssetId = activity_bounceback.AssetId activity_email_open.CampaignId = activity_bounceback.CampaignId activity_email_open.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_email_open.AssetId = activity_email_clickthrough.AssetId activity_email_open.CampaignId = activity_email_clickthrough.CampaignId activity_email_open.ContactId = activity_email_clickthrough.ContactId activity_email_open.VisitorId = activity_email_clickthrough.VisitorId
activity_email_send	activity_email_open.AssetId = activity_email_send.AssetId activity_email_open.CampaignId = activity_email_send.CampaignId activity_email_open.ContactId = activity_email_send.ContactId
activity_form_submit	activity_email_open.AssetId = activity_form_submit.AssetId activity_email_open.CampaignId = activity_form_submit.CampaignId activity_email_open.ContactId = activity_form_submit.ContactId activity_email_open.VisitorId = activity_form_submit.VisitorId
activity_page_view	activity_email_open.AssetId = activity_page_view.AssetId activity_email_open.CampaignId = activity_page_view.CampaignId activity_email_open.ContactId = activity_page_view.ContactId activity_email_open.VisitorId = activity_page_view.VisitorId
activity_subscribe	activity_email_open.AssetId = activity_subscribe.AssetId activity_email_open.CampaignId = activity_subscribe.CampaignId activity_email_open.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_email_open.AssetId = activity_unsubscribe.AssetId activity_email_open.CampaignId = activity_unsubscribe.CampaignId activity_email_open.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_email_open.AssetId = activity_web_visit.AssetId
campaigns	activity_email_open.CampaignId = campaigns.id
forms	activity_email_open.CampaignId = forms.processingSteps.campaignId
contacts	activity_email_open.ContactId = contacts.Id
visitors	activity_email_open.ContactId = visitors.contactId activity_email_open.VisitorId = visitors.id

ActivityDate

DATE-TIME

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

DeploymentId

STRING

EmailAddress

STRING

EmailRecipientId

STRING

EmailWebLink

STRING

ExternalId

STRING

IpAddress

STRING

Type

STRING

VisitorExternalId

STRING

VisitorId

STRING

updatedAt

DATE-TIME

activity_email_send

The activity_email_send table contains info about EmailSend contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_email_send with	on
assets	activity_email_send.AssetId = assets.id
activity_bounceback	activity_email_send.AssetId = activity_bounceback.AssetId activity_email_send.CampaignId = activity_bounceback.CampaignId activity_email_send.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_email_send.AssetId = activity_email_clickthrough.AssetId activity_email_send.CampaignId = activity_email_clickthrough.CampaignId activity_email_send.ContactId = activity_email_clickthrough.ContactId
activity_email_open	activity_email_send.AssetId = activity_email_open.AssetId activity_email_send.CampaignId = activity_email_open.CampaignId activity_email_send.ContactId = activity_email_open.ContactId
activity_form_submit	activity_email_send.AssetId = activity_form_submit.AssetId activity_email_send.CampaignId = activity_form_submit.CampaignId activity_email_send.ContactId = activity_form_submit.ContactId
activity_page_view	activity_email_send.AssetId = activity_page_view.AssetId activity_email_send.CampaignId = activity_page_view.CampaignId activity_email_send.ContactId = activity_page_view.ContactId
activity_subscribe	activity_email_send.AssetId = activity_subscribe.AssetId activity_email_send.CampaignId = activity_subscribe.CampaignId activity_email_send.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_email_send.AssetId = activity_unsubscribe.AssetId activity_email_send.CampaignId = activity_unsubscribe.CampaignId activity_email_send.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_email_send.AssetId = activity_web_visit.AssetId
campaigns	activity_email_send.CampaignId = campaigns.id
forms	activity_email_send.CampaignId = forms.processingSteps.campaignId
contacts	activity_email_send.ContactId = contacts.Id
visitors	activity_email_send.ContactId = visitors.contactId

ActivityDate

DATE-TIME

ActivityId

STRING

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

DeploymentId

STRING

EmailAddress

STRING

EmailRecipientId

STRING

EmailSendType

STRING

EmailWebLink

STRING

ExternalId

STRING

SubjectLine

STRING

Type

STRING

updatedAt

DATE-TIME

activity_form_submit

The activity_form_submit table contains info about FormSubmit contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_form_submit with	on
assets	activity_form_submit.AssetId = assets.id
activity_bounceback	activity_form_submit.AssetId = activity_bounceback.AssetId activity_form_submit.CampaignId = activity_bounceback.CampaignId activity_form_submit.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_form_submit.AssetId = activity_email_clickthrough.AssetId activity_form_submit.CampaignId = activity_email_clickthrough.CampaignId activity_form_submit.ContactId = activity_email_clickthrough.ContactId activity_form_submit.VisitorId = activity_email_clickthrough.VisitorId
activity_email_open	activity_form_submit.AssetId = activity_email_open.AssetId activity_form_submit.CampaignId = activity_email_open.CampaignId activity_form_submit.ContactId = activity_email_open.ContactId activity_form_submit.VisitorId = activity_email_open.VisitorId
activity_email_send	activity_form_submit.AssetId = activity_email_send.AssetId activity_form_submit.CampaignId = activity_email_send.CampaignId activity_form_submit.ContactId = activity_email_send.ContactId
activity_page_view	activity_form_submit.AssetId = activity_page_view.AssetId activity_form_submit.CampaignId = activity_page_view.CampaignId activity_form_submit.ContactId = activity_page_view.ContactId activity_form_submit.VisitorId = activity_page_view.VisitorId
activity_subscribe	activity_form_submit.AssetId = activity_subscribe.AssetId activity_form_submit.CampaignId = activity_subscribe.CampaignId activity_form_submit.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_form_submit.AssetId = activity_unsubscribe.AssetId activity_form_submit.CampaignId = activity_unsubscribe.CampaignId activity_form_submit.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_form_submit.AssetId = activity_web_visit.AssetId
campaigns	activity_form_submit.CampaignId = campaigns.id
forms	activity_form_submit.CampaignId = forms.processingSteps.campaignId
contacts	activity_form_submit.ContactId = contacts.Id
visitors	activity_form_submit.ContactId = visitors.contactId activity_form_submit.VisitorId = visitors.id

ActivityDate

DATE-TIME

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

ExternalId

STRING

RawData

STRING

Type

STRING

VisitorExternalId

STRING

VisitorId

STRING

updatedAt

DATE-TIME

activity_page_view

The activity_page_view table contains info about PageView contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_page_view with	on
assets	activity_page_view.AssetId = assets.id
activity_bounceback	activity_page_view.AssetId = activity_bounceback.AssetId activity_page_view.CampaignId = activity_bounceback.CampaignId activity_page_view.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_page_view.AssetId = activity_email_clickthrough.AssetId activity_page_view.CampaignId = activity_email_clickthrough.CampaignId activity_page_view.ContactId = activity_email_clickthrough.ContactId activity_page_view.VisitorId = activity_email_clickthrough.VisitorId
activity_email_open	activity_page_view.AssetId = activity_email_open.AssetId activity_page_view.CampaignId = activity_email_open.CampaignId activity_page_view.ContactId = activity_email_open.ContactId activity_page_view.VisitorId = activity_email_open.VisitorId
activity_email_send	activity_page_view.AssetId = activity_email_send.AssetId activity_page_view.CampaignId = activity_email_send.CampaignId activity_page_view.ContactId = activity_email_send.ContactId
activity_form_submit	activity_page_view.AssetId = activity_form_submit.AssetId activity_page_view.CampaignId = activity_form_submit.CampaignId activity_page_view.ContactId = activity_form_submit.ContactId activity_page_view.VisitorId = activity_form_submit.VisitorId
activity_subscribe	activity_page_view.AssetId = activity_subscribe.AssetId activity_page_view.CampaignId = activity_subscribe.CampaignId activity_page_view.ContactId = activity_subscribe.ContactId
activity_unsubscribe	activity_page_view.AssetId = activity_unsubscribe.AssetId activity_page_view.CampaignId = activity_unsubscribe.CampaignId activity_page_view.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_page_view.AssetId = activity_web_visit.AssetId
campaigns	activity_page_view.CampaignId = campaigns.id
forms	activity_page_view.CampaignId = forms.processingSteps.campaignId
contacts	activity_page_view.ContactId = contacts.Id
visitors	activity_page_view.ContactId = visitors.contactId activity_page_view.VisitorId = visitors.id

ActivityDate

DATE-TIME

ActivityId

STRING

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

ExternalId

STRING

IpAddress

STRING

Type

STRING

Url

STRING

VisitorExternalId

STRING

VisitorId

STRING

WebVisitId

STRING

updatedAt

DATE-TIME

The activity_subscribe table contains info about Subscribe contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_subscribe with	on
assets	activity_subscribe.AssetId = assets.id
activity_bounceback	activity_subscribe.AssetId = activity_bounceback.AssetId activity_subscribe.CampaignId = activity_bounceback.CampaignId activity_subscribe.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_subscribe.AssetId = activity_email_clickthrough.AssetId activity_subscribe.CampaignId = activity_email_clickthrough.CampaignId activity_subscribe.ContactId = activity_email_clickthrough.ContactId
activity_email_open	activity_subscribe.AssetId = activity_email_open.AssetId activity_subscribe.CampaignId = activity_email_open.CampaignId activity_subscribe.ContactId = activity_email_open.ContactId
activity_email_send	activity_subscribe.AssetId = activity_email_send.AssetId activity_subscribe.CampaignId = activity_email_send.CampaignId activity_subscribe.ContactId = activity_email_send.ContactId
activity_form_submit	activity_subscribe.AssetId = activity_form_submit.AssetId activity_subscribe.CampaignId = activity_form_submit.CampaignId activity_subscribe.ContactId = activity_form_submit.ContactId
activity_page_view	activity_subscribe.AssetId = activity_page_view.AssetId activity_subscribe.CampaignId = activity_page_view.CampaignId activity_subscribe.ContactId = activity_page_view.ContactId
activity_unsubscribe	activity_subscribe.AssetId = activity_unsubscribe.AssetId activity_subscribe.CampaignId = activity_unsubscribe.CampaignId activity_subscribe.ContactId = activity_unsubscribe.ContactId
activity_web_visit	activity_subscribe.AssetId = activity_web_visit.AssetId
campaigns	activity_subscribe.CampaignId = campaigns.id
forms	activity_subscribe.CampaignId = forms.processingSteps.campaignId
contacts	activity_subscribe.ContactId = contacts.Id
visitors	activity_subscribe.ContactId = visitors.contactId

activity_unsubscribe

The activity_unsubscribe table contains info about Unsubscribe contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_unsubscribe with	on
assets	activity_unsubscribe.AssetId = assets.id
activity_bounceback	activity_unsubscribe.AssetId = activity_bounceback.AssetId activity_unsubscribe.CampaignId = activity_bounceback.CampaignId activity_unsubscribe.ContactId = activity_bounceback.ContactId
activity_email_clickthrough	activity_unsubscribe.AssetId = activity_email_clickthrough.AssetId activity_unsubscribe.CampaignId = activity_email_clickthrough.CampaignId activity_unsubscribe.ContactId = activity_email_clickthrough.ContactId
activity_email_open	activity_unsubscribe.AssetId = activity_email_open.AssetId activity_unsubscribe.CampaignId = activity_email_open.CampaignId activity_unsubscribe.ContactId = activity_email_open.ContactId
activity_email_send	activity_unsubscribe.AssetId = activity_email_send.AssetId activity_unsubscribe.CampaignId = activity_email_send.CampaignId activity_unsubscribe.ContactId = activity_email_send.ContactId
activity_form_submit	activity_unsubscribe.AssetId = activity_form_submit.AssetId activity_unsubscribe.CampaignId = activity_form_submit.CampaignId activity_unsubscribe.ContactId = activity_form_submit.ContactId
activity_page_view	activity_unsubscribe.AssetId = activity_page_view.AssetId activity_unsubscribe.CampaignId = activity_page_view.CampaignId activity_unsubscribe.ContactId = activity_page_view.ContactId
activity_subscribe	activity_unsubscribe.AssetId = activity_subscribe.AssetId activity_unsubscribe.CampaignId = activity_subscribe.CampaignId activity_unsubscribe.ContactId = activity_subscribe.ContactId
activity_web_visit	activity_unsubscribe.AssetId = activity_web_visit.AssetId
campaigns	activity_unsubscribe.CampaignId = campaigns.id
forms	activity_unsubscribe.CampaignId = forms.processingSteps.campaignId
contacts	activity_unsubscribe.ContactId = contacts.Id
visitors	activity_unsubscribe.ContactId = visitors.contactId

ActivityDate

DATE-TIME

ActivityId

STRING

ActivityType

STRING

AssetId

STRING

AssetName

STRING

AssetType

STRING

CampaignId

INTEGER

ContactId

STRING

EmailAddress

STRING

EmailRecipientId

STRING

ExternalId

STRING

Type

STRING

updatedAt

DATE-TIME

activity_web_visit

The activity_web_visit table contains info about WebVisit contact activities.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join activity_web_visit with	on
assets	activity_web_visit.AssetId = assets.id
activity_bounceback	activity_web_visit.AssetId = activity_bounceback.AssetId
activity_email_clickthrough	activity_web_visit.AssetId = activity_email_clickthrough.AssetId
activity_email_open	activity_web_visit.AssetId = activity_email_open.AssetId
activity_email_send	activity_web_visit.AssetId = activity_email_send.AssetId
activity_form_submit	activity_web_visit.AssetId = activity_form_submit.AssetId
activity_page_view	activity_web_visit.AssetId = activity_page_view.AssetId
activity_subscribe	activity_web_visit.AssetId = activity_subscribe.AssetId
activity_unsubscribe	activity_web_visit.AssetId = activity_unsubscribe.AssetId

ActivityDate

DATE-TIME

ActivityType

STRING

AssetId

STRING

AssetType

STRING

ContactId

STRING

Type

STRING

updatedAt

DATE-TIME

assets

The assets table contains info about the external assets associated with your Eloqua account. External assets are non-Eloqua, or offline, activities performed by your contacts or prospects.

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join assets with	on
activity_bounceback	assets.id = activity_bounceback.AssetId
activity_email_clickthrough	assets.id = activity_email_clickthrough.AssetId
activity_email_open	assets.id = activity_email_open.AssetId
activity_email_send	assets.id = activity_email_send.AssetId
activity_form_submit	assets.id = activity_form_submit.AssetId
activity_page_view	assets.id = activity_page_view.AssetId
activity_subscribe	assets.id = activity_subscribe.AssetId
activity_unsubscribe	assets.id = activity_unsubscribe.AssetId
activity_web_visit	assets.id = activity_web_visit.AssetId
campaigns	assets.folderId = campaigns.folderId assets.createdBy = campaigns.createdBy assets.updatedBy = campaigns.createdBy assets.createdBy = campaigns.updatedBy assets.updatedBy = campaigns.updatedBy assets.createdBy = campaigns.runAsUserId assets.updatedBy = campaigns.runAsUserId
emails	assets.folderId = emails.dynamicContents.folderId assets.folderId = emails.hyperlinks.folderId assets.folderId = emails.images.folderId assets.createdBy = emails.createdBy assets.updatedBy = emails.createdBy assets.createdBy = emails.dynamicContents.createdBy assets.updatedBy = emails.dynamicContents.createdBy assets.createdBy = emails.dynamicContents.updatedBy assets.updatedBy = emails.dynamicContents.updatedBy assets.createdBy = emails.fieldMerges.createdBy assets.updatedBy = emails.fieldMerges.createdBy assets.createdBy = emails.fieldMerges.updatedBy assets.updatedBy = emails.fieldMerges.updatedBy assets.createdBy = emails.hyperlinks.createdBy assets.updatedBy = emails.hyperlinks.createdBy assets.createdBy = emails.hyperlinks.updatedBy assets.updatedBy = emails.hyperlinks.updatedBy assets.createdBy = emails.images.createdBy assets.updatedBy = emails.images.createdBy assets.createdBy = emails.images.updatedBy assets.updatedBy = emails.images.updatedBy assets.createdBy = emails.updatedBy assets.updatedBy = emails.updatedBy
forms	assets.folderId = forms.folderId

accessedAt

DATE-TIME

createdAt

DATE-TIME

createdBy

STRING

currentStatus

STRING

depth

STRING

description

STRING

externalAssetTypeId

STRING

folderId

STRING

name

STRING

permissions

ARRAY

This is a nested data structure.

scheduledFor

STRING

sourceTemplateId

STRING

type

STRING

updatedAt

DATE-TIME

updatedBy

STRING

campaigns

The campaigns table contains info about the campaigns in your Eloqua account. Campaigns are comprised of different elements (such as segments, emails, landing pages, etc.) that are used to perform a variety of functions.

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join campaigns with	on
activity_bounceback	campaigns.id = activity_bounceback.CampaignId
activity_email_clickthrough	campaigns.id = activity_email_clickthrough.CampaignId
activity_email_open	campaigns.id = activity_email_open.CampaignId
activity_email_send	campaigns.id = activity_email_send.CampaignId
activity_form_submit	campaigns.id = activity_form_submit.CampaignId
activity_page_view	campaigns.id = activity_page_view.CampaignId
activity_subscribe	campaigns.id = activity_subscribe.CampaignId
activity_unsubscribe	campaigns.id = activity_unsubscribe.CampaignId
forms	campaigns.id = forms.processingSteps.campaignId campaigns.folderId = forms.folderId
assets	campaigns.folderId = assets.folderId campaigns.createdBy = assets.createdBy campaigns.updatedBy = assets.createdBy campaigns.runAsUserId = assets.createdBy campaigns.createdBy = assets.updatedBy campaigns.updatedBy = assets.updatedBy campaigns.runAsUserId = assets.updatedBy
emails	campaigns.folderId = emails.dynamicContents.folderId campaigns.folderId = emails.hyperlinks.folderId campaigns.folderId = emails.images.folderId campaigns.createdBy = emails.createdBy campaigns.updatedBy = emails.createdBy campaigns.runAsUserId = emails.createdBy campaigns.createdBy = emails.dynamicContents.createdBy campaigns.updatedBy = emails.dynamicContents.createdBy campaigns.runAsUserId = emails.dynamicContents.createdBy campaigns.createdBy = emails.dynamicContents.updatedBy campaigns.updatedBy = emails.dynamicContents.updatedBy campaigns.runAsUserId = emails.dynamicContents.updatedBy campaigns.createdBy = emails.fieldMerges.createdBy campaigns.updatedBy = emails.fieldMerges.createdBy campaigns.runAsUserId = emails.fieldMerges.createdBy campaigns.createdBy = emails.fieldMerges.updatedBy campaigns.updatedBy = emails.fieldMerges.updatedBy campaigns.runAsUserId = emails.fieldMerges.updatedBy campaigns.createdBy = emails.hyperlinks.createdBy campaigns.updatedBy = emails.hyperlinks.createdBy campaigns.runAsUserId = emails.hyperlinks.createdBy campaigns.createdBy = emails.hyperlinks.updatedBy campaigns.updatedBy = emails.hyperlinks.updatedBy campaigns.runAsUserId = emails.hyperlinks.updatedBy campaigns.createdBy = emails.images.createdBy campaigns.updatedBy = emails.images.createdBy campaigns.runAsUserId = emails.images.createdBy campaigns.createdBy = emails.images.updatedBy campaigns.updatedBy = emails.images.updatedBy campaigns.runAsUserId = emails.images.updatedBy campaigns.createdBy = emails.updatedBy campaigns.updatedBy = emails.updatedBy campaigns.runAsUserId = emails.updatedBy

accessedAt

DATE-TIME

actualCost

STRING

badgeId

STRING

budgetedCost

STRING

campaignCategory

STRING

campaignType

STRING

clrEndDate

DATE-TIME

createdAt

DATE-TIME

createdBy

STRING

crmId

STRING

currentStatus

STRING

depth

STRING

description

STRING

elements

ARRAY

This is a nested data structure.

endAt

DATE-TIME

fieldValues

ARRAY

This is a nested data structure.

firstActivation

DATE-TIME

folderId

STRING

isEmailMarketingCampaign

STRING

isIncludedInROI

STRING

isMemberAllowedReEntry

STRING

isReadOnly

STRING

isSyncedWithCRM

STRING

memberCount

STRING

name

STRING

permissions

ARRAY

This is a nested data structure.

product

STRING

region

STRING

runAsUserId

STRING

scheduledFor

DATE-TIME

sourceTemplateId

STRING

startAt

DATE-TIME

type

STRING

updatedAt

DATE-TIME

updatedBy

STRING

contacts

The contacts table contains info the contacts in your Eloqua account.

Note: This table is replicated using the Eloqua Bulk API.

Custom contacts fields

If applicable, Stitch will replicate custom fields related to contacts in Eloqua.

Replication Method	CDC
Primary Key	Id
Replication Key	UpdatedAt
Useful links	Eloqua API method

Join contacts with	on
activity_bounceback	contacts.Id = activity_bounceback.ContactId
activity_email_clickthrough	contacts.Id = activity_email_clickthrough.ContactId
activity_email_open	contacts.Id = activity_email_open.ContactId
activity_email_send	contacts.Id = activity_email_send.ContactId
activity_form_submit	contacts.Id = activity_form_submit.ContactId
activity_page_view	contacts.Id = activity_page_view.ContactId
activity_subscribe	contacts.Id = activity_subscribe.ContactId
activity_unsubscribe	contacts.Id = activity_unsubscribe.ContactId
visitors	contacts.Id = visitors.contactId

AccountName

STRING

ContactIDExt

STRING

CreatedAt

DATE-TIME

Custom Fields

VARIES

EmailFormat

STRING

IsBounceBack

STRING

IsSubscribed

STRING

UpdatedAt

DATE-TIME

custom_objects

For each custom object in your Eloqua account, Stitch will display a table as available for selection. The name of the table will be the normalized name of the object, using snake case (spaces replaced with underscores) and removing special characters. For example: If your account contains an Enrichement Attributes custom object, there will be a corresponding enrichment_attributes available for selection in Stitch.

Note: This table is replicated using the Eloqua Bulk API.

Replication Method	CDC
Primary Key	id
Replication Key	UpdatedAt
Useful links	Eloqua API method

CreatedAt

DATE-TIME

Custom Fields

VARIES

DataCardIDExt

STRING

UpdatedAt

DATE-TIME

STRING

emailGroups

The emailGroups table contains details about the email groups in your Eloqua account.

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join emailGroups with	on
emails	emailGroups.emailFooterId = emails.emailFooterId emailGroups.emailHeaderId = emails.emailHeaderId

Join emailGroups with

emails

emailGroups.emailFooterId = emails.emailFooterId

emailGroups.emailHeaderId = emails.emailHeaderId

createdAt

DATE-TIME

createdBy

STRING

depth

STRING

displayName

STRING

emailFooterId

STRING

emailHeaderId

STRING

isSecureNotificationsGroup

STRING

isVisibleInOutlookPlugin

STRING

isVisibleInPublicSubscriptionList

STRING

isWelcomeCommunicationsGroup

STRING

name

STRING

notificationEmailId

STRING

requireOptIn

STRING

subscriptionLandingPageId

STRING

subscriptionListDataLookupId

STRING

subscriptionListId

STRING

type

STRING

unSubscriptionListDataLookupId

STRING

unSubscriptionListId

STRING

unsubscriptionLandingPageId

STRING

updatedAt

DATE-TIME

updatedBy

STRING

useSecureChannel

STRING

emails

The emails table contains details about the emails sent from your Eloqua account.

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join emails with	on
forms	emails.id = forms.processingSteps.emailId emails.dynamicContents.folderId = forms.folderId emails.hyperlinks.folderId = forms.folderId emails.images.folderId = forms.folderId
emailGroups	emails.emailFooterId = emailGroups.emailFooterId emails.emailHeaderId = emailGroups.emailHeaderId
assets	emails.dynamicContents.folderId = assets.folderId emails.hyperlinks.folderId = assets.folderId emails.images.folderId = assets.folderId emails.createdBy = assets.createdBy emails.dynamicContents.createdBy = assets.createdBy emails.dynamicContents.updatedBy = assets.createdBy emails.fieldMerges.createdBy = assets.createdBy emails.fieldMerges.updatedBy = assets.createdBy emails.hyperlinks.createdBy = assets.createdBy emails.hyperlinks.updatedBy = assets.createdBy emails.images.createdBy = assets.createdBy emails.images.updatedBy = assets.createdBy emails.updatedBy = assets.createdBy emails.createdBy = assets.updatedBy emails.dynamicContents.createdBy = assets.updatedBy emails.dynamicContents.updatedBy = assets.updatedBy emails.fieldMerges.createdBy = assets.updatedBy emails.fieldMerges.updatedBy = assets.updatedBy emails.hyperlinks.createdBy = assets.updatedBy emails.hyperlinks.updatedBy = assets.updatedBy emails.images.createdBy = assets.updatedBy emails.images.updatedBy = assets.updatedBy emails.updatedBy = assets.updatedBy
campaigns	emails.dynamicContents.folderId = campaigns.folderId emails.hyperlinks.folderId = campaigns.folderId emails.images.folderId = campaigns.folderId emails.createdBy = campaigns.createdBy emails.dynamicContents.createdBy = campaigns.createdBy emails.dynamicContents.updatedBy = campaigns.createdBy emails.fieldMerges.createdBy = campaigns.createdBy emails.fieldMerges.updatedBy = campaigns.createdBy emails.hyperlinks.createdBy = campaigns.createdBy emails.hyperlinks.updatedBy = campaigns.createdBy emails.images.createdBy = campaigns.createdBy emails.images.updatedBy = campaigns.createdBy emails.updatedBy = campaigns.createdBy emails.createdBy = campaigns.updatedBy emails.dynamicContents.createdBy = campaigns.updatedBy emails.dynamicContents.updatedBy = campaigns.updatedBy emails.fieldMerges.createdBy = campaigns.updatedBy emails.fieldMerges.updatedBy = campaigns.updatedBy emails.hyperlinks.createdBy = campaigns.updatedBy emails.hyperlinks.updatedBy = campaigns.updatedBy emails.images.createdBy = campaigns.updatedBy emails.images.updatedBy = campaigns.updatedBy emails.updatedBy = campaigns.updatedBy emails.createdBy = campaigns.runAsUserId emails.dynamicContents.createdBy = campaigns.runAsUserId emails.dynamicContents.updatedBy = campaigns.runAsUserId emails.fieldMerges.createdBy = campaigns.runAsUserId emails.fieldMerges.updatedBy = campaigns.runAsUserId emails.hyperlinks.createdBy = campaigns.runAsUserId emails.hyperlinks.updatedBy = campaigns.runAsUserId emails.images.createdBy = campaigns.runAsUserId emails.images.updatedBy = campaigns.runAsUserId emails.updatedBy = campaigns.runAsUserId

accessedAt

DATE-TIME

archive

BOOLEAN

bounceBackEmail

STRING

contentSections

ARRAY

This is a nested data structure.

createdAt

DATE-TIME

createdBy

STRING

currentStatus

STRING

depth

STRING

description

STRING

dynamicContents

ARRAY

This is a nested data structure:

createdAt: DATE-TIME
createdBy: STRING
defaultContentSection: STRING
depth: STRING
description: STRING
folderId: STRING
id: STRING
name: STRING
permissions: STRING
rules: STRING
type: STRING
updatedAt: DATE-TIME
updatedBy: STRING

emailFooterId

STRING

emailGroupId

STRING

emailHeaderId

STRING

encodingId

STRING

fieldMerges

ARRAY

This is a nested data structure:

allowUrlsInValue: STRING
contactFieldId: STRING
createdAt: DATE-TIME
createdBy: STRING
defaultValue: STRING
depth: STRING
eventId: STRING
eventSessionFieldId: STRING
fieldConditions: STRING
folderId: STRING
id: STRING
mergeType: STRING
name: STRING
syntax: STRING
type: STRING
updatedAt: DATE-TIME
updatedBy: STRING

files

ARRAY

This is a nested data structure.

folderId

STRING

forms

ARRAY

This is a nested data structure.

htmlContent

OBJECT

This is a nested data structure:

contentSource: STRING
cssHeader: STRING
docType: STRING
documentDescription: STRING
html: STRING
htmlBody: STRING
metaTags: ARRAY, which is also a nested data structure.
root: STRING
systemHeader: STRING
type: STRING

hyperlinks

ARRAY

This is a nested data structure:

createdAt: DATE-TIME
createdBy: STRING
depth: STRING
folderId: STRING
href: STRING
hyperlinkType: STRING
id: STRING
name: STRING
referencedEntityId: STRING
type: STRING
updatedAt: DATE-TIME
updatedBy: STRING

STRING

images

ARRAY

This is a nested data structure.

isContentProtected

BOOLEAN

isPlainTextEditable

STRING

isPrivate

BOOLEAN

isTracked

STRING

landingPages

ARRAY

This is a nested data structure.

layout

STRING

name

STRING

permissions

STRING

plainText

STRING

renderMode

STRING

replyToEmail

STRING

replyToName

STRING

sendPlainTextOnly

STRING

senderEmail

STRING

senderName

STRING

sourceTemplateId

STRING

style

STRING

subject

STRING

type

STRING

updatedAt

DATE-TIME

updatedBy

STRING

virtualMTAId

STRING

forms

The forms table contains info about the forms in your Eloqua account.

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	updatedAt
Useful links	Eloqua API method

Join forms with	on
campaigns	forms.processingSteps.campaignId = campaigns.id forms.folderId = campaigns.folderId
activity_bounceback	forms.processingSteps.campaignId = activity_bounceback.CampaignId
activity_email_clickthrough	forms.processingSteps.campaignId = activity_email_clickthrough.CampaignId
activity_email_open	forms.processingSteps.campaignId = activity_email_open.CampaignId
activity_email_send	forms.processingSteps.campaignId = activity_email_send.CampaignId
activity_form_submit	forms.processingSteps.campaignId = activity_form_submit.CampaignId
activity_page_view	forms.processingSteps.campaignId = activity_page_view.CampaignId
activity_subscribe	forms.processingSteps.campaignId = activity_subscribe.CampaignId
activity_unsubscribe	forms.processingSteps.campaignId = activity_unsubscribe.CampaignId
emails	forms.processingSteps.emailId = emails.id forms.folderId = emails.dynamicContents.folderId forms.folderId = emails.hyperlinks.folderId forms.folderId = emails.images.folderId
assets	forms.folderId = assets.folderId

accessedAt

DATE-TIME

createdAt

DATE-TIME

createdBy

STRING

currentStatus

STRING

customCSS

STRING

defaultKeyFieldMapping

STRING

depth

STRING

description

STRING

elements

ARRAY

This is a nested data structure:

altText: STRING
createdFromContactFieldId: STRING
dataType: STRING
depth: STRING
displayType: STRING
fieldMergeId: STRING
fields: STRING
htmlName: STRING
id: STRING
instructions: STRING
name: STRING
numberOfFieldsToDisplay: STRING
onlyShowIncompleteFields: STRING
optionListId: STRING
randomizeFields: STRING
style: STRING
type: STRING
useGlobalSubscriptionStatus: STRING
validations: STRING

emailAddressFormFieldId

STRING

folderId

STRING

html

STRING

htmlName

STRING

name

STRING

permissions

STRING

processingSteps

ARRAY

This is a nested data structure:

allowResend: BOOLEAN
campaignElementId: STRING
campaignId: STRING
description: STRING
emailAddressFormFieldId: STRING
emailId: STRING
eventId: STRING
execute: STRING
id: STRING
keyFieldId: STRING
keyFieldMapping: STRING
landingPageId: STRING
mappings: STRING
name: STRING
resendLimit: INTEGER
type: STRING

processingType

STRING

size

STRING

style

STRING

submitFailedLandingPageId

STRING

type

STRING

updatedAt

DATE-TIME

updatedBy

STRING

visitors

The visitors table contains info about your Eloqua visitors. According to Eloqua, “A visitor is a data entity that represents a unique cookie. The tracked activity data from that cookie is associated with the Visitor. There can be multiple visitors linked to a single contact.”

Note: This table is replicated using the Eloqua Application REST API.

Replication Method	CDC
Primary Key	id
Replication Key	V_LastVisitDateAndTime
Useful links	Eloqua API method

Join visitors with	on
contacts	visitors.contactId = contacts.Id
activity_bounceback	visitors.contactId = activity_bounceback.ContactId
activity_email_clickthrough	visitors.contactId = activity_email_clickthrough.ContactId visitors.id = activity_email_clickthrough.VisitorId
activity_email_open	visitors.contactId = activity_email_open.ContactId visitors.id = activity_email_open.VisitorId
activity_email_send	visitors.contactId = activity_email_send.ContactId
activity_form_submit	visitors.contactId = activity_form_submit.ContactId visitors.id = activity_form_submit.VisitorId
activity_page_view	visitors.contactId = activity_page_view.ContactId visitors.id = activity_page_view.VisitorId
activity_subscribe	visitors.contactId = activity_subscribe.ContactId
activity_unsubscribe	visitors.contactId = activity_unsubscribe.ContactId

V_Browser_Type

STRING

V_CityFromIP

STRING

V_CompanyDNSName

STRING

V_CompanyNameFromIP1

STRING

V_CountryFromIP

STRING

V_CountryName

STRING

V_Current_Total_Pages

INTEGER

V_Current_Visit_Length

INTEGER

V_FirstPageInVisit

STRING

V_FirstVisitDateAndTime

DATE-TIME

V_HostName

STRING

V_IPAddress

STRING

V_ISPFromIP

STRING

V_LastPageInVisit

STRING

V_LastVisitDateAndTime

DATE-TIME

V_LatitudeFromIP

NUMBER

V_LongitudeFromIP

NUMBER

V_Name

STRING

V_ProvinceFromIP

STRING

V_TimeZone

STRING

V_TimeZoneOffsetMin

INTEGER

V_Total_Pages

INTEGER

V_Total_Time

INTEGER

V_Total_Visits

INTEGER

V_ZipCodeFromIP

STRING

contactId

STRING

createdAt

STRING

currentStatus

STRING

externalId

STRING

type

STRING

visitorId

STRING

此頁面是否對您有幫助？

若您發現此頁面或其內容有任何問題——錯字、遺漏步驟或技術錯誤——請告知我們！

在此留下意見回饋