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.

Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.

Función/Capacidad	Detalles de compatibilidad
Compatibilidad con proyectos de Qlik Talend Data Integration	Solo proyectos de replicación. No se admiten proyectos de canalización de datos.
Métodos de actualización de destinos	Tareas de replicación: Aplicar los cambios Guardar cambios Tareas de aterrizaje de datos en un lago de datos: Captura de datos de cambios (CDC)
Administrar los metadatos	No es necesario generar metadatos manualmente.
Evolución del esquema	Solo se admite la operación Cambiar tipo de datos de columna.
Replicación de columnas LOB (NCLOB, CLOB y BLOB)	No admitido.
CDC programado	Obligatorio. Así es como el destino se mantiene actualizado con los cambios en la fuente. Para tareas de replicación, vea Programar tareas Para tareas de aterrizaje en un lago de datos, vea Programación de CDC para tareas de destino/aterrizaje en un lago de datos
Notificaciones	Parcialmente compatible Configuración de notificaciones sobre cambios
Supervisión	Solo CDC, ya que la carga completa no es relevante para este conector. Supervisar una tarea individual de datos
Descarte automático de cargas útiles de columnas JSON	No admitido. Las cargas útiles de columnas JSON en los conjuntos de datos de origen no se deniegan automáticamente en el destino.

Preparing for authentication

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

Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

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

Para más información, vea Conectar con aplicaciones SaaS.

Haga clic en Autenticar cuando haya completado la configuración de conexión requerida.
Es posible que se le solicite que inicie sesión en la aplicación de origen.
Se mostrará una ventana con un código de autenticación.
Copie el código en el portapapeles y regrese al cuadro de diálogo de conexión.
Pegue el código en Autenticación completa con el código proporcionado por la fuente y haga clic en Verificar.
Nota de sugerenciaEs posible que tenga que desplazarse hacia abajo para ver este campo.
Cuando el estado es Verificado, se verifica la autenticación.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.

Connection settings
Setting	Description
Data gateway	Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.
Start Date	Indique la fecha, en el formato `MM/DD/YYYY`, a partir de la cual deben replicarse los datos de su fuente a su destino.
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

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.

Deje aquí sus comentarios