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

For more information, see SaaSアプリケーションへの接続.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
ヒントメモYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	ユースケースに応じて Data Movement gateway を選択します。情報メモ Qlik Talend Cloud スターターサブスクリプションでは Data Movement gateway をサポートしていないため、この項目は使用できません。別のサブスクリプションティアを利用しており、Data Movement gateway を使用しない場合は、 [None] (なし) を選択します。 Data Movement gateway の利点とそれを必要とするユースケースの詳細については、「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

このページは役に立ちましたか?

このページまたはコンテンツにタイポ、ステップの省略、技術的エラーなどの問題が見つかった場合はお知らせください。

こちらにフィードバックをお寄せください