Eloqua Bulk API Connection Properties

The following table describes the connection properties of Eloqua Bulk API Connector.

Connection Property	Description
Runtime Environment	The required Secure Agent installed in your system.
Base URL	The base URL to connect to the Eloqua application. You can enter https://secure.eloqua.com as the base URI or use the following format to specify the base URI: https://<host>.eloqua.com/api/bulk/2.0 where, <host> can be secure, www02.secure, or secure.p03 based on the pod that hosts the Eloqua instance. In https://<host>.eloqua.com/api/bulk/2.0 url, 2.0 represents the version number. When you do not mention the version number in the base URL, the Secure Agent considers the default version. To determine the base URL to connect to the Eloqua application, click the following URL: https://community.oracle.com/community/topliners/code-it/blog/2012/11/30/using-the-eloqua-api--determining-endpoint-urls-logineloquacom
Authentication Type	The type of user authentication to connect to the Eloqua application.
Domain Name	The required domain name.
User name	The user name of your Eloqua account.
Password	The password for your Eloqua account.
ClientID	The client ID to complete the OAuth 2.0 authentication to connect to Eloqua. You must enter the client ID if you select the OAuth 2.0 authentication type.
Client Secret	The client secret key to complete the OAuth 2.0 authentication to connect to Eloqua. You must enter the client secret key if you select the OAuth 2.0 authentication type.
Time Zone Offset	The time zone in Eloqua system relative to GMT.
Enable Debug Logger	You can enable debug logger to register the SOAP request and response in the session log.
Fetch Data for Preview	You can preview the first 10 rows of the first five columns in an Eloqua Bulk API object. Default is selected.
Activities or Custom Fields Configuration	You can use Activities object and custom fields of Contact and Account objects in sources and targets in JSON format.

Activities or Custom Fields Configuration

You can use Activities object and custom fields of Contact and Account objects in sources and targets.

Add the metadata information in JSON format in the Activities or Custom Fields Configuration property under the Eloqua Bulk connection properties. The specification of Activities object and custom fields contains the following sections:

Activities

Lists all the activities as a name-value pair, where the value is an array of field names. For example,

{"EmailAddress","johns@gmail.com"},
{"FirstName","Johns"}

ActivityItem

Defines an array of fields. Each field has the following name-value pairs:

- name: Name of the field. The field name must be the same as the field name that you enter in the Activities section.
- internalName: Name of the field label. Displays the name and unique name.
- datatype: Data type of the field. Default is String data type. The activities or custom fields supports the following data types:

▪ Number or Integer
▪ Date or Timestamp
▪ String

- maxLength: Maximum length or precision of the data type field.
- hasReadOnlyConstraint: Indicates whether the field is read only.
- hasNotNullConstraint: Indicates whether the field is mandatory.
- hasUniquenessConstraint: Indicates whether the field is a key.
- statement: The statement used in Eloqua REST request.

ContactItem

Defines an array of Contact custom fields. Each field has a name-value pair for the ActivityItem section.

AccountItem

Defines an array of Account custom fields. Each field has a name-value pair for the ActivityItem section.

Eloqua Bulk API Connection Properties

Activities or Custom Fields Configuration

Rules and Guidelines for Adding Custom Fields