Connection String OptionsBack To Top

AuthScheme
Company
User
Password
InitiateOAuth
OAuthClientId
OAuthClientSecret
OAuthAccessToken
OAuthSettingsLocation
CallbackURL
OAuthVerifier
OAuthRefreshToken
OAuthExpiresIn
OAuthTokenTimestamp
SSLServerCert
FirewallType
FirewallServer
FirewallPort
FirewallUser
FirewallPassword
ProxyAutoDetect
ProxyServer
ProxyPort
ProxyAuthScheme
ProxyUser
ProxyPassword
ProxySSLType
ProxyExceptions
Logfile
Verbosity
LogModules
MaxLogFileSize
MaxLogFileCount
Location
BrowsableSchemas
Tables
Views
AutoCache
CacheDriver
CacheConnection
CacheLocation
CacheTolerance
Offline
CacheMetadata
BatchSize
BulkPollingInterval
BulkQueryTimeout
ConnectionLifeTime
ConnectOnOpen
DataRetentionDuration
DisplayColumnName
MapDataCardsCaseSensitiveMatch
MapDataCardsRelationship
MaxRows
Other
Pagesize
PoolIdleTimeout
PoolMaxSize
PoolMinSize
PoolWaitTime
PseudoColumns
Readonly
RetryCount
RetryInterval
RTK
SupportEnhancedSQL
Timeout
UseBulkAPI
UseConnectionPooling
UseSimpleNames

AuthScheme

Data Type

string

Default Value

"Basic"

Remarks

The driver supports the following authentication mechanisms. See the Getting Started chapter for authentication guides.

Basic: Set this to authenticate with a Oracle Eloqua company, user, password.
OAuth: Set this to use oauth authentication. Set OAuthClientId, OAuthClientSecret to the Oracle Eloqua OAuth credentials. Additionally, set InitiateOAuth to GETANDREFRESH or REFRESH.

Company

Data Type

string

Default Value

Remarks

This field is used to provide authentication for the user to the Eloqua servers.

User

Data Type

string

Default Value

Remarks

Together with Password, this field is used to authenticate against the Oracle Eloqua server.

Password

Data Type

string

Default Value

Remarks

The User and Password are together used to authenticate with the server.

InitiateOAuth

Data Type

string

Default Value

"OFF"

Remarks

The following options are available:

OFF: Indicates that the OAuth flow will be handled entirely by the user. An OAuthAccessToken will be required to authenticate.
GETANDREFRESH: Indicates that the entire OAuth Flow will be handled by the driver. If no token currently exists, it will be obtained by prompting the user via the browser. If a token exists, it will be refreshed when applicable.
REFRESH: Indicates that the driver will only handle refreshing the OAuthAccessToken. The user will never be prompted by the driver to authenticate via the browser. The user must handle obtaining the OAuthAccessToken and OAuthRefreshToken initially.

OAuthClientId

Data Type

string

Default Value

Remarks

As part of registering an OAuth application, you will receive the OAuthClientId value, sometimes also called a consumer key, and a client secret, the OAuthClientSecret.

As part of registering an OAuth application, you will receive the OAuthClientId, also called a consumer key. You will also receive a client secret, also called a consumer secret. Set the client secret in the OAuthClientSecret property.

OAuthAccessToken

Data Type

string

Default Value

Remarks

The OAuthAccessToken property is used to connect using OAuth. The OAuthAccessToken is retrieved from the OAuth server as part of the authentication process. It has a server-dependent timeout and can be reused between requests.

The access token is used in place of your user name and password. The access token protects your credentials by keeping them on the server.

OAuthSettingsLocation

Data Type

string

Default Value

"%APPDATA%\\CData\\OracleEloqua Data Provider\\OAuthSettings.txt"

Remarks

When InitiateOAuth is set to GETANDREFRESH or REFRESH, the driver saves OAuth values to avoid requiring the user to manually enter OAuth connection properties and allowing the credentials to be shared across connections or processes.

Alternatively to specifying a file path, memory storage can be used instead. Memory locations are specified by using a value starting with 'memory://' followed by a unique identifier for that set of credentials (ex: memory://user1). The identifier can be anything you choose but should be unique to the user. Unlike with the file based storage, you must manually store the credentials when closing the connection with memory storage to be able to set them in the connection when the process is started again. The OAuth property values can be retrieved with a query to the sys_connection_props system table. If there are multiple connections using the same credentials, the properties should be read from the last connection to be closed.

If left unspecified, the default location is "%APPDATA%\\CData\\OracleEloqua Data Provider\\OAuthSettings.txt" with %APPDATA% being set to the user's configuration directory:


Platform	%APPDATA%
Windows	The value of the APPDATA environment variable
Mac	~/Library/Application Support
Linux	~/.config

CallbackURL

Data Type

string

Default Value

Remarks

During the authentication process, the OAuth authorization server redirects the user to this URL. This value must match the callback URL you specify in your app settings.

OAuthVerifier

Data Type

string

Default Value

Remarks

The verifier code returned from the OAuth authorization URL. This can be used on systems where a browser cannot be launched such as headless systems.

Authentication on Headless Machines

See Establishing a Connection to obtain the OAuthVerifier value.

Set OAuthSettingsLocation along with OAuthVerifier. When you connect, the driver exchanges the OAuthVerifier for the OAuth authentication tokens and saves them, encrypted, to the specified file. Set InitiateOAuth to GETANDREFRESH automate the exchange.

Once the OAuth settings file has been generated, you can remove OAuthVerifier from the connection properties and connect with OAuthSettingsLocation set.

To automatically refresh the OAuth token values, set OAuthSettingsLocation and additionally set InitiateOAuth to REFRESH.

OAuthRefreshToken

Data Type

string

Default Value

Remarks

The OAuthRefreshToken property is used to refresh the OAuthAccessToken when using OAuth authentication.

OAuthExpiresIn

Data Type

string

Default Value

Remarks

Pair with OAuthTokenTimestamp to determine when the AccessToken will expire.

OAuthTokenTimestamp

Data Type

string

Default Value

Remarks

Pair with OAuthExpiresIn to determine when the AccessToken will expire.

SSLServerCert

Data Type

string

Default Value

Remarks

If using a TLS/SSL connection, this property can be used to specify the TLS/SSL certificate to be accepted from the server. Any other certificate that is not trusted by the machine is rejected.

This property can take the following forms:


Description	Example
A full PEM Certificate (example shortened for brevity)	-----BEGIN CERTIFICATE----- MIIChTCCAe4CAQAwDQYJKoZIhv......Qw== -----END CERTIFICATE-----
A path to a local file containing the certificate	C:\cert.cer
The public key (example shortened for brevity)	-----BEGIN RSA PUBLIC KEY----- MIGfMA0GCSq......AQAB -----END RSA PUBLIC KEY-----
The MD5 Thumbprint (hex values can also be either space or colon separated)	ecadbdda5a1529c58a1e9e09828d70e4
The SHA1 Thumbprint (hex values can also be either space or colon separated)	34a929226ae0819f2ec14b4a3d904f801cbb150d

If not specified, any certificate trusted by the machine is accepted.

Certificates are validated as trusted by the machine based on the System's trust store. The trust store used is the 'javax.net.ssl.trustStore' value specified for the system. If no value is specified for this property, Java's default trust store is used (for example, JAVA_HOME\lib\security\cacerts).

Use '*' to signify to accept all certificates. Note that this is not recommended due to security concerns.

FirewallType

Data Type

string

Default Value

"NONE"

Remarks

This property specifies the protocol that the driver will use to tunnel traffic through the FirewallServer proxy. Note that by default, the driver connects to the system proxy; to disable this behavior and connect to one of the following proxy types, set ProxyAutoDetect to false.


Type	Default Port	Description
TUNNEL	80	When this is set, the driver opens a connection to Oracle Eloqua and traffic flows back and forth through the proxy.
SOCKS4	1080	When this is set, the driver sends data through the SOCKS 4 proxy specified by FirewallServer and FirewallPort and passes the FirewallUser value to the proxy, which determines if the connection request should be granted.
SOCKS5	1080	When this is set, the driver sends data through the SOCKS 5 proxy specified by FirewallServer and FirewallPort. If your proxy requires authentication, set FirewallUser and FirewallPassword to credentials the proxy recognizes.

To connect to HTTP proxies, use ProxyServer and ProxyPort. To authenticate to HTTP proxies, use ProxyAuthScheme, ProxyUser, and ProxyPassword.

FirewallServer

Data Type

string

Default Value

Remarks

This property specifies the IP address, DNS name, or host name of a proxy allowing traversal of a firewall. The protocol is specified by FirewallType: Use FirewallServer with this property to connect through SOCKS or do tunneling. Use ProxyServer to connect to an HTTP proxy.

Note that the driver uses the system proxy by default. To use a different proxy, set ProxyAutoDetect to false.

FirewallPort

Data Type

int

Default Value

Remarks

This specifies the TCP port for a proxy allowing traversal of a firewall. Use FirewallServer to specify the name or IP address. Specify the protocol with FirewallType.

FirewallUser

Data Type

string

Default Value

Remarks

The FirewallUser and FirewallPassword properties are used to authenticate against the proxy specified in FirewallServer and FirewallPort, following the authentication method specified in FirewallType.

FirewallPassword

Data Type

string

Default Value

Remarks

This property is passed to the proxy specified by FirewallServer and FirewallPort, following the authentication method specified by FirewallType.

ProxyAutoDetect

Data Type

bool

Default Value

false

Remarks

This takes precedence over other proxy settings, so you'll need to set ProxyAutoDetect to FALSE in order use custom proxy settings.

NOTE: When this property is set to True, the proxy used is determined as follows:

A search from the JVM properties (http.proxy, https.proxy, socksProxy, etc.) is performed.
In the case that the JVM properties don't exist, a search from java.home/lib/net.properties is performed.
In the case that java.net.useSystemProxies is set to True, a search from the SystemProxy is performed.
In Windows only, an attempt is made to retrieve these properties from the Internet Options in the registry.

To connect to an HTTP proxy, see ProxyServer. For other proxies, such as SOCKS or tunneling, see FirewallType.

ProxyServer

Data Type

string

Default Value

Remarks

The hostname or IP address of a proxy to route HTTP traffic through. The driver can use the HTTP, Windows (NTLM), or Kerberos authentication types to authenticate to an HTTP proxy.

If you need to connect through a SOCKS proxy or tunnel the connection, see FirewallType.

By default, the driver uses the system proxy. If you need to use another proxy, set ProxyAutoDetect to false.

ProxyPort

Data Type

int

Default Value

Remarks

The port the HTTP proxy is running on that you want to redirect HTTP traffic through. Specify the HTTP proxy in ProxyServer. For other proxy types, see FirewallType.

ProxyAuthScheme

Data Type

string

Default Value

"BASIC"

Remarks

This value specifies the authentication type to use to authenticate to the HTTP proxy specified by ProxyServer and ProxyPort.

Note that the driver will use the system proxy settings by default, without further configuration needed; if you want to connect to another proxy, you will need to set ProxyAutoDetect to false, in addition to ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

The authentication type can be one of the following:

BASIC: The driver performs HTTP BASIC authentication.
DIGEST: The driver performs HTTP DIGEST authentication.
NEGOTIATE: The driver retrieves an NTLM or Kerberos token based on the applicable protocol for authentication.
PROPRIETARY: The driver does not generate an NTLM or Kerberos token. You must supply this token in the Authorization header of the HTTP request.

If you need to use another authentication type, such as SOCKS 5 authentication, see FirewallType.

ProxyUser

Data Type

string

Default Value

Remarks

The ProxyUser and ProxyPassword options are used to connect and authenticate against the HTTP proxy specified in ProxyServer.

You can select one of the available authentication types in ProxyAuthScheme. If you are using HTTP authentication, set this to the user name of a user recognized by the HTTP proxy. If you are using Windows or Kerberos authentication, set this property to a user name in one of the following formats:

user@domain

domain\user

ProxyPassword

Data Type

string

Default Value

Remarks

This property is used to authenticate to an HTTP proxy server that supports NTLM (Windows), Kerberos, or HTTP authentication. To specify the HTTP proxy, you can set ProxyServer and ProxyPort. To specify the authentication type, set ProxyAuthScheme.

If you are using HTTP authentication, additionally set ProxyUser and ProxyPassword to HTTP proxy.

If you are using NTLM authentication, set ProxyUser and ProxyPassword to your Windows password. You may also need these to complete Kerberos authentication.

For SOCKS 5 authentication or tunneling, see FirewallType.

By default, the driver uses the system proxy. If you want to connect to another proxy, set ProxyAutoDetect to false.

ProxySSLType

Data Type

string

Default Value

"AUTO"

Remarks

This property determines when to use SSL for the connection to an HTTP proxy specified by ProxyServer. This value can be AUTO, ALWAYS, NEVER, or TUNNEL. The applicable values are the following:


AUTO	Default setting. If the URL is an HTTPS URL, the driver will use the TUNNEL option. If the URL is an HTTP URL, the component will use the NEVER option.
ALWAYS	The connection is always SSL enabled.
NEVER	The connection is not SSL enabled.
TUNNEL	The connection is through a tunneling proxy. The proxy server opens a connection to the remote host and traffic flows back and forth through the proxy.

ProxyExceptions

Data Type

string

Default Value

Remarks

The ProxyServer is used for all addresses, except for addresses defined in this property. Use semicolons to separate entries.

Note that the driver uses the system proxy settings by default, without further configuration needed; if you want to explicitly configure proxy exceptions for this connection, you need to set ProxyAutoDetect = false, and configure ProxyServer and ProxyPort. To authenticate, set ProxyAuthScheme and set ProxyUser and ProxyPassword, if needed.

Logfile

Data Type

string

Default Value

Remarks

Once this property is set, the driver will populate the log file as it carries out various tasks, such as when authentication is performed or queries are executed. If the specified file doesn't already exist, it will be created.

Connection strings and version information are also logged, though connection properties containing sensitive information are masked automatically.

If a relative filepath is supplied, the location of the log file will be resolved based on the path found in the Location connection property.

For more control over what is written to the log file, you can adjust the Verbosity property.

Log contents are categorized into several modules. You can show/hide individual modules using the LogModules property.

To edit the maximum size of a single logfile before a new one is created, see MaxLogFileSize.

If you would like to place a cap on the number of logfiles generated, use MaxLogFileCount.

Java Logging

Java logging is also supported. To enable Java logging, set Logfile to:

Logfile=JAVALOG://myloggername

As in the above sample, JAVALOG:// is a required prefix to use Java logging, and you will substitute your own Logger.

The supplied Logger's getLogger method is then called, using the supplied value to create the Logger instance. If a logging instance already exists, it will reference the existing instance.

When Java logging is enabled, the Verbosity will now correspond to specific logging levels.

Verbosity

Data Type

string

Default Value

"1"

Remarks

The verbosity level determines the amount of detail that the driver reports to the Logfile. Verbosity levels from 1 to 5 are supported. These are detailed in the Logging page.

LogModules

Data Type

string

Default Value

Remarks

Only the modules specified (separated by ';') will be included in the log file. By default all modules are included.

See the Logging page for an overview.

MaxLogFileSize

Data Type

string

Default Value

"100MB"

Remarks

When the limit is hit, a new log is created in the same folder with the date and time appended to the end. The default limit is 100 MB. Values lower than 100 kB will use 100 kB as the value instead.

Adjust the maximum number of logfiles generated with MaxLogFileCount.

MaxLogFileCount

Data Type

int

Default Value

-1

Remarks

When the limit is hit, a new log is created in the same folder with the date and time appended to the end and the oldest log file will be deleted.

The minimum supported value is 2. A value of 0 or a negative value indicates no limit on the count.

Adjust the maximum size of the logfiles generated with MaxLogFileSize.

Location

Data Type

string

Default Value

"%APPDATA%\\CData\\OracleEloqua Data Provider\\Schema"

Remarks

The path to a directory which contains the schema files for the driver (.rsd files for tables and views, .rsb files for stored procedures). The folder location can be a relative path from the location of the executable. The Location property is only needed if you want to customize definitions (for example, change a column name, ignore a column, and so on) or extend the data model with new tables, views, or stored procedures.

If left unspecified, the default location is "%APPDATA%\\CData\\OracleEloqua Data Provider\\Schema" with %APPDATA% being set to the user's configuration directory:


Platform	%APPDATA%
Windows	The value of the APPDATA environment variable
Mac	~/Library/Application Support
Linux	~/.config

BrowsableSchemas

Data Type

string

Default Value

Remarks

Listing the schemas from databases can be expensive. Providing a list of schemas in the connection string improves the performance.

Tables

Data Type

string

Default Value

Remarks

Listing the tables from some databases can be expensive. Providing a list of tables in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the tables you want in a comma-separated list. Each table should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Tables=TableA,[TableB/WithSlash],WithCatalog.WithSchema.`TableC With Space`.

Note that when connecting to a data source with multiple schemas or catalogs, you will need to provide the fully qualified name of the table in this property, as in the last example here, to avoid ambiguity between tables that exist in multiple catalogs or schemas.

Views

Data Type

string

Default Value

Remarks

Listing the views from some databases can be expensive. Providing a list of views in the connection string improves the performance of the driver.

This property can also be used as an alternative to automatically listing views if you already know which ones you want to work with and there would otherwise be too many to work with.

Specify the views you want in a comma-separated list. Each view should be a valid SQL identifier with any special characters escaped using square brackets, double-quotes or backticks. For example, Views=ViewA,[ViewB/WithSlash],WithCatalog.WithSchema.`ViewC With Space`.

AutoCache

Data Type

bool

Default Value

false

Remarks

When AutoCache = true, the driver automatically maintains a cache of your table's data in the database of your choice. By default, the driver incrementally updates the cache, retrieving only changes since the last SELECT query was run if the length of time since the last run has exceeded the CacheTolerance. After the cache is updated, the query is executed against the cached data.

Setting the Caching Database

When AutoCache = true, the driver caches to a simple, file-based cache. You can configure its location or cache to a different database with the following properties:

CacheLocation: Specifies the path to the file store.
CacheDriver and CacheConnection: Specifies a driver to a database and the connection string.

CacheDriver

Data Type

string

Default Value

Remarks

You can cache to any database for which you have a JDBC driver, including CData JDBC drivers.

The cache database is determined based on the CacheDriver and CacheConnection properties. The CacheDriver is the name of the JDBC driver class that you want to use to cache data.

Note that you must also add the CacheDriver JAR file to the classpath.

The following examples show how to cache to several major databases. Refer to CacheConnection for more information on the JDBC URL syntax and typical connection properties.

Derby and Java DB

The driver simplifies Derby configuration. Java DB is the Oracle distribution of Derby. The JAR file is shipped in the JDK. You can find the JAR file, derby.jar, in the db subfolder of the JDK installation. In most caching scenarios, you need to specify only the following, after adding derby.jar to the classpath:

jdbc:oracleeloqua:CacheLocation='c:/Temp/cachedir';User=user;Password=password;Company=MyCompany

To customize the Derby JDBC URL, use CacheDriver and CacheConnection. For example, to cache to an in-memory database, use a JDBC URL like the following:

jdbc:oracleeloqua:CacheDriver=org.apache.derby.jdbc.EmbeddedDriver;CacheConnection='jdbc:derby:memory';User=user;Password=password;Company=MyCompany

SQLite

The following is a JDBC URL for the SQLite JDBC driver:

jdbc:oracleeloqua:CacheDriver=org.sqlite.JDBC;CacheConnection='jdbc:sqlite:C:/Temp/sqlite.db';User=user;Password=password;Company=MyCompany

MySQL

The following is a JDBC URL for the included CData JDBC Driver for MySQL:

  jdbc:oracleeloqua:Cache Driver=cdata.jdbc.mysql.MySQLDriver;Cache Connection='jdbc:mysql:Server=localhost;Port=3306;Database=cache;User=root;Password=123456';User=user;Password=password;Company=MyCompany

SQL Server

The following JDBC URL uses the Microsoft JDBC Driver for SQL Server:

jdbc:oracleeloqua:Cache Driver=com.microsoft.sqlserver.jdbc.SQLServerDriver;Cache Connection='jdbc:sqlserver://localhost\sqlexpress:7437;user=sa;password=123456;databaseName=Cache';User=user;Password=password;Company=MyCompany

Oracle

The following is a JDBC URL for the Oracle Thin Client:

jdbc:oracleeloqua:Cache Driver=oracle.jdbc.OracleDriver;CacheConnection='jdbc:oracle:thin:scott/tiger@localhost:1521:orcldb';User=user;Password=password;Company=MyCompany

NOTE: If using a version of Oracle older than 9i, the cache driver will instead be oracle.jdbc.driver.OracleDriver .

PostgreSQL

The following JDBC URL uses the official PostgreSQL JDBC driver:

jdbc:oracleeloqua:CacheDriver=cdata.jdbc.postgresql.PostgreSQLDriver;CacheConnection='jdbc:postgresql:User=postgres;Password=admin;Database=postgres;Server=localhost;Port=5432;';User=user;Password=password;Company=MyCompany

CacheConnection

Data Type

string

Default Value

Remarks

The cache database is determined based on the CacheDriver and CacheConnection properties. Both properties are required to use the cache database. Examples of common cache database settings can be found below. For more information on setting the caching database's driver, refer to CacheDriver.

The connection string specified in the CacheConnection property is passed directly to the underlying CacheDriver. Consult the documentation for the specific JDBC driver for more information on the available properties. Make sure to include the JDBC driver in your application's classpath.

Derby and Java DB

The driver simplifies caching to Derby, only requiring you to set the CacheLocation property to make a basic connection.

Alternatively, you can configure the connection to Derby manually using CacheDriver and CacheConnection. The following is the Derby JDBC URL syntax:

jdbc:derby:[subsubprotocol:][databaseName][;attribute=value[;attribute=value] ... ]

For example, to cache to an in-memory database, use the following:

jdbc:derby:memory

SQLite

To cache to SQLite, you can use the SQLite JDBC driver. The following is the syntax of the JDBC URL:

jdbc:sqlite:dataSource

Data Source: The path to an SQLite database file. Or, use a value of :memory to cache in memory.

MySQL

The installation includes the CData JDBC Driver for MySQL. The following is an example JDBC URL:

jdbc:mysql:User=root;Password=root;Server=localhost;Port=3306;Database=cache

The following are typical connection properties:

Server: The IP address or domain name of the server you want to connect to.
Port: The port that the server is running on.
User: The user name provided for authentication to the database.
Password: The password provided for authentication to the database.
Database: The name of the database.

SQL Server

The JDBC URL for the Microsoft JDBC Driver for SQL Server has the following syntax:

jdbc:sqlserver://[serverName[\instance][:port]][;database=databaseName][;property=value[;property=value] ... ]

For example:

jdbc:sqlserver://localhost\sqlexpress:1433;integratedSecurity=true

The following are typical SQL Server connection properties:

Server: The name or network address of the computer running SQL Server. To connect to a named instance instead of the default instance, this property can be used to specify the host name and the instance, separated by a backslash.
Port: The port SQL Server is running on.
Database: The name of the SQL Server database.
Integrated Security: Set this option to true to use the current Windows account for authentication. Set this option to false if you are setting the User and Password in the connection.
To use integrated security, you will also need to add sqljdbc_auth.dll to a folder on the Windows system path. This file is located in the auth subfolder of the Microsoft JDBC Driver for SQL Server installation. The bitness of the assembly must match the bitness of your JVM.
User Id: The user name provided for authentication with SQL Server. This property is only needed if you are not using integrated security.
Password: The password provided for authentication with SQL Server. This property is only needed if you are not using integrated security.

Oracle

The following is the conventional JDBC URL syntax for the Oracle JDBC Thin driver:

jdbc:oracle:thin:[userId/password]@[//]host[[:port][:sid]]

For example:

jdbc:oracle:thin:scott/tiger@myhost:1521:orcl

The following are typical connection properties:

Data Source: The connect descriptor that identifies the Oracle database. This can be a TNS connect descriptor, an Oracle Net Services name that resolves to a connect descriptor, or, after version 11g, an Easy Connect naming (the host name of the Oracle server with an optional port and service name).
Password: The password provided for authentication with the Oracle database.
User Id: The user Id provided for authentication with the Oracle database.

PostgreSQL

The following is the JDBC URL syntax for the official PostgreSQL JDBC driver:

jdbc:postgresql:[//[host[:port]]/]database[[?option=value][[&option=value][&option=value] ... ]]

For example, the following connection string connects to a database on the default host (localhost) and port (5432):

jdbc:postgresql:postgres

The following are typical connection properties:

Host: The address of the server hosting the PostgreSQL database.
Port: The port used to connect to the server hosting the PostgreSQL database.
Database: The name of the database.
User name: The user Id provided for authentication with the PostgreSQL database. You can specify this in the JDBC URL with the "user" parameter.
Password: The password provided for authentication with the PostgreSQL database.

CacheLocation

Data Type

string

Default Value

"%APPDATA%\\CData\\OracleEloqua Data Provider"

Remarks

The CacheLocation is a simple, file-based cache. The driver uses Java DB, Oracle's distribution of the Derby database. To cache to Java DB, you will need to add the Java DB JAR file to the classpath. The JAR file, derby.jar, is shipped in the JDK and located in the db subfolder of the JDK installation.

If left unspecified, the default location is "%APPDATA%\\CData\\OracleEloqua Data Provider" with %APPDATA% being set to the user's configuration directory:


Platform	%APPDATA%
Windows	The value of the APPDATA environment variable
Mac	~/Library/Application Support
Linux	~/.config

CacheTolerance

Data Type

int

Default Value

600

Remarks

The tolerance for stale data in the cache specified in seconds. This only applies when AutoCache is used. The driver checks with the data source for newer records after the tolerance interval has expired. Otherwise, it returns the data directly from the cache.

Offline

Data Type

bool

Default Value

false

Remarks

When Offline = true, all queries execute against the cache as opposed to the live data source. In this mode, certain queries like INSERT, UPDATE, DELETE, and CACHE are not allowed.

CacheMetadata

Data Type

bool

Default Value

false

Remarks

As you execute queries with this property set, table metadata in the Oracle Eloqua catalog are cached to the file store specified by CacheLocation if set or the user's home directory otherwise. A table's metadata will be retrieved only once, when the table is queried for the first time.

When to Use CacheMetadata

The driver automatically persists metadata in memory for up to two hours when you first discover the metadata for a table or view and therefore, CacheMetadata is generally not required. CacheMetadata becomes useful when metadata operations are expensive such as when you are working with large amounts of metadata or when you have many short-lived connections.

When Not to Use CacheMetadata

When you are working with volatile metadata: Metadata for a table is only retrieved the first time the connection to the table is made. To pick up new, changed, or deleted columns, you would need to delete and rebuild the metadata cache. Therefore, it is best to rely on the in-memory caching for cases where metadata changes often.
When you are caching to a database: CacheMetadata can only be used with CacheLocation. If you are caching to another database with the CacheDriver and CacheConnection properties, use AutoCache to cache implicitly. Or, use REPLICATE Statements or CACHE Statements to cache explicitly.

BatchSize

Data Type

int

Default Value

Remarks

When BatchSize is set to a value greater than 0, the batch operation will split the entire batch into separate batches of size BatchSize. The split batches will then be submitted to the server individually. This is useful when the server has limitations on the size of the request that can be submitted.

Setting BatchSize to 0 will submit the entire batch as specified.

BulkPollingInterval

Data Type

string

Default Value

"200"

Remarks

The time interval between requests that check the availability of the bulk query response. When UseBulkAPI is set, the driver requests Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. This property controls the frequency of polling.

BulkQueryTimeout

Data Type

string

Default Value

"25"

Remarks

The timeout in minutes for which the driver will wait for a bulk query response. The default value is 25 minutes. When UseBulkAPI is set, the driver requests Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. This property controls the total time the driver will wait for a response.

Note that this property is very different from Timeout. The Timeout is an inactivity timeout that controls the time to wait for any response. This property controls the total length of time to wait for a bulk query to execute. ;

ConnectionLifeTime

Data Type

int

Default Value

Remarks

The maximum lifetime of a connection in seconds. Once the time has elapsed, the connection object is disposed. The default is 0 which indicates there is no limit to the connection lifetime.

ConnectOnOpen

Data Type

bool

Default Value

false

Remarks

When set to true, a connection will be made to Oracle Eloqua when the connection is opened. This property enables the Test Connection feature available in various database tools.

This feature acts as a NOOP command as it is used to verify a connection can be made to Oracle Eloqua and nothing from this initial connection is maintained.

Setting this property to false may provide performance improvements (depending upon the number of times a connection is opened).

DataRetentionDuration

Data Type

string

Default Value

"24"

Remarks

The length of time (in hours) that bulk data is stored on the server. Valid values are from 1 hour to 2 weeks. The default value is 24 hours.

DisplayColumnName

Data Type

string

Default Value

Remarks

The response data Oracle Eloqua Bulk API Fields contains three kinds of displayName: "name","statement",and "internalName" for the same field.

The display name type chosen is simply a matter of visual preference.

As an example, suppose you have the following JSON response for an EmailAddress item.

{

    "items":[

        {

            "name":"Email Address",

            "internalName":"C_EmailAddress",

            "dataType":"emailAddress",

            "hasReadOnlyConstraint":false,

            "hasNotNullConstraint":false,

            "hasUniquenessConstraint":true,

            "statement":"{{Contact.Field(C_EmailAddress)}}",

            "uri":"/contacts/fields/100001",

            "createdAt":"1900-01-01T05:00:00.0000000Z",

            "updatedAt":"1900-01-01T05:00:00.0000000Z"

        },

       ......

    ]

}

The column name listed upon metadata discovery from the driver will be one of the following.

Empty String: The default value is empty string. The means the "name" of the field will be regarded as the display column name: EmailAddress.
internal: This means the "internalName" of the field will be regarded as the display column name: C_EmailAddress.
statement: It means the "statement" of the field will be regarded as the display column name: {{Contact.Field(C_EmailAddress)}}.

MapDataCardsCaseSensitiveMatch

Data Type

bool

Default Value

false

Remarks

Whether or not to use case sensitive match in data card mapping. Only has an effect if MapDataCardsRelationship is set.

MapDataCardsRelationship

Data Type

string

Default Value

Remarks

Comma-separated list of the relationships between the Custom Object tables and the Entity tables. The format of these relationships is '<custom_object>.<source_field>=<entity_type>.<entity_field>'. For example: Custom_MyCustomObject.Email_Address=Contact.C_EmailAddress

MaxRows

Data Type

int

Default Value

-1

Remarks

Limits the number of rows returned rows when no aggregation or group by is used in the query. This helps avoid performance issues at design time.

Other

Data Type

string

Default Value

Remarks

The properties listed below are available for specific use cases. Normal driver use cases and functionality should not require these properties.

Specify multiple properties in a semicolon-separated list.

Caching Configuration


CachePartial=True	Caches only a subset of columns, which you can specify in your query.
QueryPassthrough=True	Passes the specified query to the cache database instead of using the SQL parser of the driver.

Integration and Formatting


DefaultColumnSize	Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000.
ConvertDateTimeToGMT	Determines whether to convert date-time values to GMT, instead of the local time of the machine.
RecordToFile=filename	Records the underlying socket data transfer to the specified file.

Pagesize

Data Type

int

Default Value

500

Remarks

The Pagesize property affects the maximum number of results to return per page from Oracle Eloqua. Setting a higher value may result in better performance at the cost of additional memory allocated per page consumed.

PoolIdleTimeout

Data Type

int

Default Value

Remarks

The allowed idle time a connection can remain in the pool until the connection is closed. The default is 60 seconds.

PoolMaxSize

Data Type

int

Default Value

100

Remarks

The maximum connections in the pool. The default is 100. To disable this property, set the property value to 0 or less.

PoolMinSize

Data Type

int

Default Value

Remarks

The minimum number of connections in the pool. The default is 1.

PoolWaitTime

Data Type

int

Default Value

Remarks

The max seconds to wait for a connection to become available. If a new connection request is waiting for an available connection and exceeds this time, an error is thrown. By default, new requests wait forever for an available connection.

PseudoColumns

Data Type

string

Default Value

Remarks

This setting is particularly helpful in Entity Framework, which does not allow you to set a value for a pseudo column unless it is a table column. The value of this connection setting is of the format "Table1=Column1, Table1=Column2, Table2=Column3". You can use the "*" character to include all tables and all columns; for example, "*=*".

Readonly

Data Type

bool

Default Value

false

Remarks

If this property is set to true, the driver will allow only SELECT queries. INSERT, UPDATE, DELETE, and stored procedure queries will cause an error to be thrown.

RetryCount

Data Type

string

Default Value

"5"

Remarks

When UseBulkAPI is set to "Auto" or "True", the driver will attempt to retry any requests that fail due to an HTTP 500 status code (Internal Server Error). This property defintes maximum number of time the driver will retry a Bulk API request that failed. By default the driver will retry the request 5 times.

RetryInterval

Data Type

string

Default Value

"200"

Remarks

When UseBulkAPI is set to "Auto" or "True", the driver will attempt to retry any requests that fail due to an HTTP 500 status code (Internal Server Error). This property defines the time interval between attempts to retry a Bulk API request that failed. The default value is 200 ms.

RTK

Data Type

string

Default Value

Remarks

The RTK property may be used to license a build. See the included licensing file to see how to set this property. The runtime key is only available if you purchased an OEM license.

SupportEnhancedSQL

Data Type

bool

Default Value

true

Remarks

When SupportEnhancedSQL = true, the driver offloads as much of the SELECT statement processing as possible to Oracle Eloqua and then processes the rest of the query in memory. In this way, the driver can execute unsupported predicates, joins, and aggregation.

When SupportEnhancedSQL = false, the driver limits SQL execution to what is supported by the Oracle Eloqua API.

Execution of Predicates

The driver determines which of the clauses are supported by the data source and then pushes them to the source to get the smallest superset of rows that would satisfy the query. It then filters the rest of the rows locally. The filter operation is streamed, which enables the driver to filter effectively for even very large datasets.

Execution of Joins

The driver uses various techniques to join in memory. The driver trades off memory utilization against the requirement of reading the same table more than once.

Execution of Aggregates

The driver retrieves all rows necessary to process the aggregation in memory.

Timeout

Data Type

int

Default Value

Remarks

If Timeout = 0, operations do not time out. The operations run until they complete successfully or until they encounter an error condition.

If Timeout expires and the operation is not yet complete, the driver throws an exception.

UseBulkAPI

Data Type

string

Default Value

"Auto"

Remarks

Whether or not the bulk API is used for retrieving data. When UseBulkAPI is set to "True", the driver will always attempt to use the bulk API. However, there are several restrictions to accessible tables and columns. See Data Model for more information.

When set to "False", the driver will use the REST API for all requests. When set to "Auto", the driver will use whichever API is most appropriate for the request. For example, consider the following query:

SELECT * FROM Activity_EmailOpen

In this case, the driver will use the Bulk API (because the ContactId is not specified), whereas the following query will use the REST API:

SELECT * FROM Activity_EmailOpen ContactId='...'

Using the Bulk API starts with the driver sending a request to Eloqua to prepare a response to the query. It then waits for the response to be ready by periodically polling the server to check status. BulkPollingInterval and BulkQueryTimeout control the frequency and duration of polling respectively.

UseConnectionPooling

Data Type

bool

Default Value

false

Remarks

This property enables connection pooling. The default is false. See Connection Pooling for information on using connection pools.

UseSimpleNames

Data Type

bool

Default Value

false

Remarks

Oracle Eloqua tables and columns can use special characters in names that are normally not allowed in standard databases. UseSimpleNames makes the driver easier to use with traditional database tools.

Setting UseSimpleNames to true will simplify the names of tables and columns returned. It will enforce a naming scheme such that only alphanumeric characters and the underscore are valid for the displayed table and column names. Any nonalphanumeric characters will be converted to an underscore.

TablesBack To Top

Account
AccountGroup
Campaign
CampaignResponses
Contact
ContactEmailSubscription
ContactSegment
ContentSection
Custom
Email
EmailFooter
EmailGroup
EmailHeader
Event
ExternalActivity
ExternalAsset
Folder
Form
Hyperlink
LandingPage
Microsite
OptionList

Account

Create, update, delete, and query Accounts. This table is supported in bulk mode.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the account.
Company Name	String	False	The Name of the account.
Country	String	False	The country of the account.
Address	String	False	The address of the account.
City	String	False	The city of the address for the account.
State or Province	String	False	The state or province of the address for the account.
Zip or Postal Code	String	False	The zip or postal code of the address for the account.
Business Phone	String	False	The business phone number of the account.
Eloqua Company ID	String	True	The Eloqua company Id of the account
Date Created	Datetime	True	Date and time the account was created.
Date Modified	Datetime	True	Date and time the account was last updated.
Company Category	Double	False	The category of the company
SFDC Account ID	String	False	The Salesforce Id of the account
Last Modified by CRM System	Datetime	True	Date and time the account was last updated by the CRM system.
Address 2	String	False	The second address of the account.
Address 3	String	False	The third address of the account.
Industry	String	False	The industry of the account.
PURL Name (Default Hypersite)	String	True	The URL of the account.
Annual Revenue	String	False	The annual revenue of the account.
Fax	String	False	The fax number of the account.
Employees	Double	False	The number of employees of the account
Website	String	False	The website of the account.
Account Rating	String	False	The account rating of the account.

AccountGroup

Retrieve Account group.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the account group.
Name	String	False	The name of the account group.
Type	String	False	The type of the account group.
Permissions	String	False	The permissions of the account group.
CreatedAt	Datetime	True	Date the account group was created.
IsArchived	String	False	The Id of the user who created the account group.
FolderId	String	True	The folderId of the account group.
UpdatedAt	Datetime	True	Date the account group was updated.
Description	String	True	The description of the accountgroup.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Campaign

Create, update, delete, and query Campaigns.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the campaign.
Name	String	False	The name of the campaign.
ActualCost	Double	False	The actual cost of the campaign.
BudgetedCost	Double	False	The budgeted cost for the Campaign.
CrmId	String	False	The unique Id of the campaign in your CRM.
EndAt	Datetime	False	The campaign's end date.
EndValues	String	False	The end values of the campaign.
IsMemberAllowedReEntry	Boolean	False	Determines whether a member can reenter the campaign.
IsReadOnly	Boolean	False	Whether the campaign is read-only.
StartAt	Datetime	False	The campaign's start date.
CreatedAt	Datetime	False	The date and time the campaign was created.
CreatedBy	String	False	The Id of the user who created the Campaign.
AccessedAt	Datetime	False	Date the campaign was accessed.
CurrentStatus	String	False	The current status of the campaign.
Depth	String	False	The depth of the campaign.
UpdatedAt	Datetime	False	Date the campaign was updated.
UpdatedBy	String	False	The Id of the user who last updated the Campaign.
Permissions	String	False	The permissions of the campaign.
ScheduledFor	Datetime	False	The date and time scheduled for the campaign.
SourceTemplatedId	String	False	The Id of the source template for the campaign.
FolderId	Long	False	The Id of the folder for the campaign.
Campaign Type	String	False	The type of campaign.
Product	String	False	The product of the campaign.
Region	String	False	The region of the campaign.
Five	String	False	The fifth value for the campagin.
Four	String	False	The fourth value for the campagin.
Three	String	False	The third value for the campagin.
Two	String	False	The second value for the campagin.
CLR End Date	Datetime	False	The CLR end date.

CampaignResponses

Create, delete, and query Campaign Responses. This table is only supported in bulk mode.

Columns


Name	Type	ReadOnly	Description
ID	Long	False	The unique identifier for the campaign responses.
Member Status	String	False	The status of the campaign member.
Integration Return Value	String	False	The return value of the campaign responses.
Created At	Long	False	The created time of the campaign responses.
Add At	String	False	The added time of the campaign responses.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ServiceInstanceId	String	The AppCloud action service instance ID. It is necessary to insert or select this table
ExecutionId	String	The execution ID of service instance.It is necessary to select this table

Contact

Create, update, delete, and query Contacts. This table is supported in bulk mode.

Table Specific Information

The EmailAddress column is required for inserts and updates.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the contact.
Email Address [KEY]	String	False	The Email Address of the contact.
First Name	String	False	The First Name of the contact.
Last Name	String	False	The Last Name of the contact.
Company	String	False	The Company of the contact.
Email Display Name	String	False	The Email Display Name of the contact.
Address 1	String	False	The Address 1 of the contact.
Address 2	String	False	The Address 2 of the contact.
Address 3	String	False	The Address 3 of the contact.
City	String	False	The City of the contact.
State or Province	String	False	The State or Province of the contact.
Zip or Postal Code	String	False	The Zip or Postal Code of the contact.
Country	String	False	The Country of the contact.
Business Phone	String	False	The Business Phone of the contact.
Mobile Phone	String	False	The Mobile Phone of the contact.
Fax	String	False	The Fax of the contact.
Title	String	False	The Title of the contact.
Salutation	String	False	The Salutation of the contact.
Salesperson	String	False	The Salesperson of the contact.
SFDC Contact ID	String	False	The SFDC Contact ID of the contact.
SFDC Lead ID	String	False	The SFDC Lead ID of the contact.
Date Created	Date	True	The Date Created of the contact.
Date Modified	Date	True	The Date Modified of the contact.
Eloqua Contact ID	String	True	The Eloqua Contact ID of the contact.
SFDC Account ID	String	False	The SFDC Account ID of the contact.
Last Modified by CRM System	Date	True	The Last Modified by CRM System of the contact.
Last SFDC Campaign ID	String	False	The Last SFDC Campaign ID of the contact.
Last SFDC Campaign Status	String	False	The Last SFDC Campaign Status of the contact.
Company Revenue	String	False	The Company Revenue of the contact.
SFDC Email Opt Out	String	False	The SFDC Email Opt Out of the contact.
Lead Source - Most Recent	String	False	The Lead Source - Most Recent of the contact.
Lead Source - Original	String	False	The Lead Source - Original of the contact.
Industry	String	False	The Industry of the contact.
Annual Revenue	String	False	The Annual Revenue of the contact.
Lead Status	String	False	The Lead Status of the contact.
Job Role	String	False	The Job Role of the contact.
Lead Score - High Value Website Content	Double	False	The Lead Score - High Value Website Content of the contact.
Lead Score Date - Engagement - Most Recent	Date	False	The Lead Score Date - Engagement - Most Recent of the contact.
Integrated Marketing and Sales Funnel Stage	String	False	The Integrated Marketing and Sales Funnel Stage of the contact.
Product/Solution of Interest	String	False	The Product/Solution of Interest of the contact.
Region	String	False	The Region of the contact.
PURL Name (Default Hypersite)	String	True	The PURL Name (Default Hypersite) of the contact.
Lead Rating - Combined	String	False	The Lead Rating - Combined of the contact.
Email Address Domain	String	True	The Email Address Domain of the contact.
First and Last Name	String	True	The First and Last Name of the contact.
Company Size	String	False	The Company Size of the contact.
Lead Score - Last High Touch Event Date	Date	False	The Lead Score - Last High Touch Event Date of the contact.
Lead Rating - Profile (Explicit)	String	False	The Lead Rating - Profile (Explicit) of the contact.
Lead Rating - Engagement (Implicit)	String	False	The Lead Rating - Engagement (Implicit) of the contact.
Lead Score - Profile (Explicit)	Double	False	The Lead Score - Profile (Explicit) of the contact.
Lead Score - Engagement (Implicit)	Double	False	The Lead Score - Engagement (Implicit) of the contact.
Lead Score Date - Profile - Most Recent	Date	False	The Lead Score Date - Profile - Most Recent of the contact.
Employees	Double	False	The Employees of the contact.
Territory	String	False	The Territory of the contact.
Lead Score	String	False	The Lead Score of the contact.
PURL Name	String	True	The PURL Name of the contact.
MD5 Hashed Email Address	String	True	The MD5 Hashed Email Address of the contact.
SHA256 Hashed Email Address	String	True	The SHA256 Hashed Email Address of the contact.
MD5 Hashed Business Phone	String	True	The MD5 Hashed Business Phone of the contact.
SHA256 Hashed Business Phone	String	True	The SHA256 Hashed Business Phone of the contact.
MD5 Hashed Mobile Phone	String	True	The MD5 Hashed Mobile Phone of the contact.
SHA256 Hashed Mobile Phone	String	True	The SHA256 Hashed Mobile Phone of the contact of the contact.

ContactEmailSubscription

Retrieve all email group subscription status for the specific contact.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for Email Group.
ContactID [KEY]	Long	False	The unique identifier for the contact.
Name	String	True	The name of the email group.
Description	String	True	The description of the email group.
IsSubScribed	Boolean	False	The subscribed status. The default value is false.
Permissions	String	True	The permissions of the email group.

ContactSegment

Create, update, delete, and query Contact Segments.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the contact segment.
Name	String	False	The name of the contact segment.
Description	String	False	The description of the contact segment.
FolderId	Long	False	The Id of the folder for the contact segment.
ScheduledFor	Datetime	False	The date and time scheduled for the contact segment.
SourceTemplatedId	Long	False	The Id of the source template of the contact segment.
Permissions	String	False	The permissions of the contact segment.
CreatedAt	Datetime	True	Date the contact segment was created.
CreatedBy	String	True	The Id of the user who created the contact segment.
AccessedAt	Datetime	False	Date the contact segment was accessed.
CurrentStatus	String	False	The current status of the contact segment.
UpdatedAt	Datetime	True	Date the contact segment was last updated.
UpdatedBy	String	True	The Id of the user who last updated the contact segment.
LastCalculatedAt	Datetime	False	Date the contact segment was last calculated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContentSection

Create, update, delete, and query Content Sections.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the content section.
Name	String	False	The name of the content section.
Description	String	False	The description of the content section.
FolderId	Long	False	The Id of the folder for the content section.
ScheduledFor	Datetime	False	The date and time scheduled for the content section.
SourceTemplatedId	Long	False	The Id of the source template of the content section.
Permissions	String	False	The permissions of the content section.
CreatedAt	Datetime	True	Date the content section was created.
CreatedBy	String	True	The Id of the user who created the content section.
AccessedAt	Datetime	False	Date the content section was accessed.
CurrentStatus	String	False	The current status of the content section.
UpdatedAt	Datetime	True	Date the content section was updated.
UpdatedBy	String	True	The Id of the user who last updated the content section.
ContentHtml	String	False	The content HTML of the content section.
ContentText	String	False	The content text of the data lookup for the content section.
Scope	String	False	A list of contact Ids to be removed from the content section.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Custom

Create and delete custom.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The id of the custom.
Name	String	False	The name of the custom.
EmailAddressFieldId	String	False	The field id that contains the Email Address. Use the desired custom object field's negative id as the value for this parameter.
EventGroupByFieldId	String	False	The id of the field used to organize multiple sessions. Use the desired custom object field's negative id as the value for this parameter.
FolderId	String	True	The folder id of the folder which contains the custom.
Fields	String	False	Array consisting of custom field properties
Description	String	False	The description of the custom.
RecordCount	Integer	True	The amount of records within the custom.
CreatedAt	Datetime	True	Date the custom was created.
CreatedBy	String	True	The Id of the user who created the custom.
UpdatedAt	Datetime	True	Date the custom was last updated.
UpdatedBy	String	True	The Id of the user who last updated the custom.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Email

Create, update, delete, and query Emails.

Table Specific Information

Select

The following limitation exists for filtering on datetime columns: The "=" operator cannot be used with datetime columns in the WHERE clause. However, the "<", ">", ">=", and "<=" operators can be used to filter on datetime columns.

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Oracle Eloqua also has limited support on multiple conditions. In many tables the AND condition between filters is not supported. If AND is included the server might not return any results, nor will it throw an error.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the email.
Name	String	False	The name of the email.
EmailGroupId	Long	False	The Id of the email group.
HtmlContent_ContentSource	String	False	The raw HTML contentSorce for the content of the email.
HtmlContent_CssHeader	String	False	The raw HTML cssHeader for the content of the email.
HtmlContent_DocType	String	False	The raw HTML docType for the content of the email.
HtmlContent_DocumentDescription	String	False	The raw HTML documentDescription for the content of the email.
HtmlContent_HtmlBody	String	False	The raw HTML Body for the content of the email.
HtmlContent_MetaTags	String	True	The raw HTML metaTags for the content of the email.
HtmlContent_Root	String	False	The raw HTML root for the content of the email.
HtmlContent_SystemHeader	String	False	The raw HTML systemHeader for the content of the email.
HtmlContent_Type	String	False	The raw HTML type for the content of the email.
IsPlainTextEditable	Boolean	False	Identifies whether the email is plaintext editable.
IsTracked	Boolean	False	Identifies whether the email is tracked.
PlainText	String	False	The plaintext version of the email.
BouncebackEmail	String	False	The bounce-back email address.
ReplyToEmail	String	False	The email address in the reply-to line of the email.
ReplyToName	String	False	The name in the reply-to line of the email.
SenderEmail	String	False	The email address of the sender.
SenderName	String	False	The name of the sender.
SenderPlainTextOnly	Boolean	False	Identifies whether the plaintext version should be sent.
Subject	String	False	The subject of the email.
Description	String	False	The description of the email.
FolderId	Long	False	The Id of the folder for the email.
Permissions	String	False	The permissions of the email.
CreatedAt	Datetime	True	Date the email was created.
CreatedBy	String	True	The Id of the user who created the email.
AccessedAt	Datetime	False	Date the email was accessed.
CurrentStatus	String	False	The current status of the email.
Depth	String	False	The depth of the email.
UpdatedAt	Datetime	True	Date the email was updated.
UpdatedBy	String	True	The Id of the user who last updated the email.

EmailFooter

Create, update, delete, and query Email Footers.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the email footer.
Name	String	False	The name of the email footer.
Body	String	False	The body of the email footer.
Hyperlinks	String	True	A list of hyperlinks.
FieldMerges	String	True	A list of field merges.
Text	String	False	The text of the email footer.
Permissions	String	False	The permissions of the email footer.
Description	String	False	The description of the email footer.
FolderId	Long	False	The Id of the folder for the email footer.
CreatedAt	Datetime	True	Date the email footer was created.
CreatedBy	String	True	The Id of the user who created the email footer.
AccessedAt	Datetime	False	Date the email footer was accessed.
CurrentStatus	String	False	The current status of the email footer.
Depth	String	False	The depth of the email footer.
UpdatedAt	Datetime	True	Date the email footer was updated.
UpdatedBy	String	True	The Id of the user who last updated the email footer.
PlainText	String	True	The plain text of the email footer.

EmailGroup

Create, update, delete, and query Email Groups.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the email group.
Name	String	False	The name of the email.
DisplayName	String	False	The display name of the email group.
EmailFooterId	Long	False	The Id of the email footer of the email group.
EmailIds	String	False	The Ids of the emails in the email group.
IsVisibleInOutlookPlugin	Boolean	False	Identifies whether the email group is visible in the Outlook plugin.
IsVisibleInPublicSubscriptionList	Boolean	False	Identifies whether the email group is visible in public subscription list.
SubscriptionLandingPageId	Long	False	The Id of the landing page used to subscribe to the email group.
SubscriptionListId	Long	False	The Id of the subscription list for the email group.
UnsubscriptionLandingPageId	Long	False	The Id of the landing page used to unsubscribe for the email group.
UnsubscriptionListId	Long	False	The Id of the unsubscription list for the email group.
UnsubscriptionListDataLookupId	String	False	The Id of the data lookup for the unsubscription list for the email group.
Description	String	False	The description of the email group.
FolderId	Long	False	The folder Id for the email group.
Permissions	String	False	The permissions list of the email group.
CreatedAt	Datetime	True	Date the email group was created.
CreatedBy	String	True	The Id of the user who created the email group.
AccessedAt	Datetime	False	Date the email group was accessed.
CurrentStatus	String	False	The current status of the email group.
Depth	String	False	The depth of the email group.
UpdatedAt	Datetime	True	Date the email group was updated.
UpdatedBy	String	True	The Id of the user who last updated the email group.

EmailHeader

Create, update, delete, and query Email Headers.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the email header.
Name	String	False	The name of the email header.
Body	String	False	The body of the email header.
Hyperlinks	String	True	A list of hyperlinks.
FieldMerges	String	True	A list of field merges.
Text	String	False	The text of the email header.
Permissions	String	False	The permissions of the email header.
Description	String	False	The description of the email header.
FolderId	Long	False	The Id of the folder for the email header.
CreatedAt	Datetime	True	Date the email header was created.
CreatedBy	String	True	The Id of the user who created the email header.
AccessedAt	Datetime	False	Date the email header was accessed.
CurrentStatus	String	False	The current status of the email header.
Depth	String	False	The depth of the email header.
UpdatedAt	Datetime	True	Date the email header was updated.
UpdatedBy	String	True	The Id of the user who last updated the email header.

Event

Create and delete Event.

Columns


Name	Type	ReadOnly	Description
Id [KEY]	String	False	The Id of the event.
Name	String	False	The name of the event.
EmailAddressFieldId	String	False	The field Id that contains the Email Address. Use the negative id of the desired custom object field as the value for this parameter.
EventGroupByFieldId	String	False	The Id of the field used to organize multiple sessions. Use the negative Id of the desired custom object field as the value for this parameter.
FolderId	String	True	The folder Id of the folder which contains the event.
Fields	String	False	Array consisting of event field properties.
Description	String	False	The description of the event.
RecordCount	Integer	True	The amount of records within the event.
CreatedAt	Datetime	True	Date the event was created.
CreatedBy	String	True	The Id of the user who created the event.
UpdatedAt	Datetime	True	Date the event was last updated.
UpdatedBy	String	True	The Id of the user who last updated the event.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ExternalActivity

Create and query External Activities. This table is not supported in bulk mode.

Table Specific Information

Select

This table requires that either Id or ContactId be specified to retrieve data:

SELECT * FROM ExternalActivity WHERE Id= '1111'

SELECT * FROM ExternalActivity WHERE ContactId = '11'

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the external activity.
Type	String	False	The type of the external activity.
Name	String	False	The Name of the external activity.
ActivityType	String	False	The Type of external activity.
ContactId	Long	False	The Id of the contact who performed the external activity.
CampaignId	Long	False	The Id of the campaign associated with this external activity.
AssetName	String	False	The AssetName of the external activity.
AssetType	String	False	The AssetType of the external activity.
AssetId	Long	False	The AssetId of the external activity.
ActivityDate	Datetime	False	The Date of the external activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ExternalAsset

Create, update, delete, and query External Assets.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the external asset.
Name	String	False	The name of the external asset.
CreatedAt	Datetime	True	Date the external asset was created.
CreatedBy	String	True	The Id of the user who created the external asset.
Depth	String	False	The depth of the external asset.
UpdatedAt	Datetime	True	Date the external asset was updated.
UpdatedBy	String	True	The Id of the user who last updated the external asset.

Folder

Create, update, delete, and query Folders.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the folder.
Name	String	False	The name of the folder.
IsSystem	Boolean	False	Identifies a system-generated folder.
Description	String	False	The description of the folder.
CreatedAt	Datetime	True	Date the folder was created.
UpdatedAt	Datetime	True	Date the folder was last updated.
UpdatedBy	String	True	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Form

Create, update, delete, and query Forms.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the form.
Name	String	False	The name of the form.
FolderId	Long	False	The Id of the folder for the form.
SourceTemplatedId	Long	False	The Id of the source template of the form.
Permissions	String	False	The permissions of the form.
CreatedAt	Datetime	True	Date the form was created.
CreatedBy	String	True	The Id of the user who created the form.
CurrentStatus	String	False	The current status of the form.
UpdatedAt	Datetime	True	Date the form was last updated.
UpdatedBy	String	True	The Id of the user who last updated the form.
HtmlName	String	False	The HTML name of the form.
ProcessingType	String	False	The processing type of the data lookup for the form.
SubmitFailedLandingPageId	Long	False	The submit failed landing page Id of the form.
Html	String	False	The HTML of the form.
Style	String	False	The style of the form.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Hyperlink

Create, update, delete, and query Hyperlinks.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the hyperlink.
Name	String	False	The name of the hyperlink.
IsSystem	Boolean	False	Identifies a system-generated hyperlink.
UpdatedAt	Datetime	True	Date the hyperlink was updated.
UpdatedBy	String	True	The Id of the user who last updated the hyperlink.
FolderId	Long	False	The folder Id of the hyperlink.
CreatedAt	Datetime	True	Date the hyperlink was created.
CreatedBy	String	True	The Id of the user who created the hyperlink.
Href	String	False	The href of the hyperlink.
HyperlinkType	String	False	The type of the hyperlink.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

LandingPage

Create, update, delete, and query Landing Pages.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier for the landing page.
Name	String	False	The name of the landing page.
DeployedAt	Datetime	False	Date the landing page was deployed.
HtmlContent	String	False	The raw HTML for the content of the landing page.
MicrositeId	Long	False	The unique identifier for this page's microsite.
RefreshedAt	Datetime	False	Date the landing page was refreshed.
RelativePath	String	False	The relative path to the landing page.
Style	String	False	The style of the landing page.
Description	String	False	The description of the landing page.
FolderId	Long	False	The Id of the folder for the landing page
Permissions	String	False	The permissions list for the landing page.
CreatedAt	Datetime	True	Date the landing page was created.
CreatedBy	String	True	The Id of the user who created the landing page.
AccessedAt	Datetime	False	Date the landing page was accessed.
CurrentStatus	String	False	The current status of the landing page.
Depth	String	False	The depth of the landing page.
UpdatedAt	Datetime	True	Date the landing page was updated.
UpdatedBy	String	True	The Id of the user who last updated the landing page.

Microsite

Create, update, delete, and query Microsites.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique identifier of the microsite.
Name	String	False	The name of the microsite.
Domains	String	False	A list of domains for this micosite.
ScheduledFor	Datetime	False	The date and time scheduled for the microsite.
SourceTemplatedId	Long	False	The Id of the source template for the microsite.
DefaultLandingPageId	Long	False	The Id of the default landing page for the microsite.
Description	String	False	The description of the microsite.
FolderId	Long	False	The Id of the folder for the microsite
Permissions	String	False	The permissions of the microsite.
CreatedAt	Datetime	True	Date the microsite was created.
CreatedBy	String	True	The Id of the user who created the microsite.
AccessedAt	Datetime	False	Date the microsite was accessed.
CurrentStatus	String	False	The current status of the microsite.
Depth	String	False	The depth of the microsite.
UpdatedAt	Datetime	True	Date the microsite was updated.
UpdatedBy	String	True	The Id of the user who last updated the microsite.

OptionList

Create, update, delete, and query Option Lists.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	ReadOnly	Description
ID [KEY]	Long	True	The unique Id of the option list.
Name	String	False	The name of the option list item.
Depth	String	False	The depth of the option list item.
Permissions	String	False	The permissions of the option list item.

ViewsBack To Top

AccountField
AccountView
Activity_Bounceback
Activity_CampaignMembership
Activity_EmailClickThrough
Activity_EmailOpen
Activity_EmailSend
Activity_EmailSubscribe
Activity_EmailUnsubscribe
Activity_FormSubmit
Activity_PageView
Activity_WebVisit
CampaignElement
CampaignField
CampaignFolder
ContactField
ContactFilter
ContactFilterFolder
ContactList
ContactListFolder
ContactScoringModelFolder
ContactSegmentData
ContactSegmentFolder
ContactView
ContentSectionFolder
Dependencies
DynamicContent
DynamicContentFolder
EmailDeployment
EmailFolder
EmailFooterFolder
EmailHeaderFolder
ExternalType
FieldMerge
FieldMergeFolder
FormElement
FormFolder
FormProcessingStep
HyperlinkFolder
Image
ImageFolder
ImportedFile
ImportedFileFolder
LandingPageFolder
LeadScoringModel
PageTag
PageTagGroup
Program
Style
Template
TemplateCategory
TrackedUrl
User
Visitor
VisitorProfileField

AccountField

Retrieve Account Fields.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the account field.
Name	String	The name of the account field.
DataType	String	The data type of the account field.
DisplayType	String	The display type of the account field.
InternalName	String	The country of the account field.
IsReadOnly	Boolean	Identifies whether the account field is read-only.
IsRequired	Boolean	Identifies whether the account field is required.
IsStandard	Boolean	Identifies whether the account field is standard.
OptionListId	Long	The Id of the option list for the account field.
OutputFormatId	Long	The Id of the output format for the account field.
CreatedAt	Datetime	Date the account field was created.
CreatedBy	String	The Id of the user who created the account field.
Depth	String	The depth of the account field.
UpdatedAt	Datetime	Date the account field was updated.
UpdatedBy	String	The Id of the user who last updated the account field.

AccountView

Retrieve Account Views.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the account view.
Name	String	The name of the account view.
Description	String	The description of the account view.
Permissions	String	The permissions of the account view.
CreatedAt	Datetime	Date the account view was created.
CreatedBy	String	The Id of the user who created the account view.
AccessedAt	Datetime	Date the account view was accessed.
UpdatedAt	Datetime	Date the account view was updated.
UpdatedBy	String	The Id of the user who last updated the account view.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Activity_Bounceback

Retrieve Bounceback Activities. This table is only supported in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the bounceback activity.
CreatedAt	Datetime	The date and time the bounceback activity was created.
Type	String	The type of the activity associated with the bounceback activity.
AssetName	String	The name of the asset associated with the bounceback activity.
AssetId	Long	The Id of the asset associated with the bounceback activity.
AssetType	String	The type of the asset associated with the bounceback activity.
CampaignId	Long	The Id of the campaign associated with the bounceback activity.
EmailAddress	String	The address of the email.
ExternalId	String	The ExternalId associated with the email activity. Only supported in bulk mode.
EmailRecipientId	String	The Email Recipient Id associated with the email activity. Only supported in bulk mode.
SmtpErrorCode	String	The Smtp Error Code associated with the email activity. Only supported in bulk mode.
SmtpStatusCode	String	The Smtp Status Code associated with the email activity. Only supported in bulk mode.
SmtpMessage	String	The Smtp Message associated with the email activity. Only supported in bulk mode.
DeploymentId	String	The email deployment Id associated with the email activity. Only supported in bulk mode.
ContactId	Long	The Id of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the bounceback activity.
LastName	String	The LastName of the contact associated with the bounceback activity.
Company	String	The Company of the contact associated with the bounceback activity.
City	String	The City of the contact associated with the bounceback activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the bounceback activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the bounceback activity was created.
Address1	String	The first line address of the contact associated with the bounceback activity.
Address2	String	The second line address of the contact associated with the bounceback activity.
Title	String	The Title of the contact associated with the bounceback activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_CampaignMembership

Retrieve Campaign Membership Activities.

Table Specific Information

This table is the only activity table not available in the Bulk API.

Select

ContactId is required to query Activity tables.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the campaign membership activity.
Name	String	The name of the campaign membership activity.
CreatedAt	Datetime	The date and time the campaign membership activity was created.
Type	String	The type of campaign membership activity.
AssetId	Long	The Id of the asset associated with the campaign membership activity.
AssetType	String	The type of the asset associated with the campaign membership activity.
AssetName	String	The name of the asset associated with the email campaign membership activity.
ContactId	Long	The Id of the contact who performed the campaign membership activity.
Responded	String	Whether the campaign membership activity has been responded to.
CampaignName	String	The campaign name of the campaign membership activity.
LeadStage	String	The lead stage of the campaign membership activity.
CampaignId	Long	The campaignId of the campaign membership activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_EmailClickThrough

Retrieve Email Click Through Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the email click-through activity.
Name	String	The name of the email click-through activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email click-through activity was created.
Type	String	The type of the email click-through activity.
AssetId	Long	The Id of the asset associated with the email click-through activity.
AssetName	String	The name of the asset associated with the email click-through activity.
AssetType	String	The type of the asset associated with the email click-through activity.
ContactId	Long	The Id of the contact who performed the email click-through activity.
EmailClickedThruLink	String	The click-through link in the email.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
SubjectLine	String	The subject line of the email.
EmailRecipientId	String	The Id of the recipient of the email.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
EmailAddress	String	The address of the email. Only supported in bulk mode.
IpAddress	String	The IP address of the email activity. Only supported in bulk mode.
CampaignId	Long	The Id of the campaign associated with the email click-through activity. Only supported in bulk mode.
DeploymentId	Long	The deployment Id associated with the email open activity. Only supported in bulk mode.
VisitorId	Long	The Id of the visitor associated with the email open activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the email open activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email open activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email click-through activity.
LastName	String	The LastName of the contact associated with the email click-through activity.
Company	String	The Company of the contact associated with the email click-through activity.
City	String	The City of the contact associated with the email click-through activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email click-through activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email click-through activity was created.
Address1	String	The first line address of the contact associated with the email click-through activity.
Address2	String	The second line address of the contact associated with the email click-through activity.
Title	String	The Title of the contact associated with the email click-through activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_EmailOpen

Retrieve Email Open Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the email open activity.
Name	String	The name of the email open activity. Not supported in bulk mode.
EmailAddress	String	The email address of the contact.
CreatedAt	Datetime	The date and time the email open activity was created.
Type	String	The type of the activity associated with the email open activity.
AssetName	String	The name of the asset associated with the email open activity.
AssetId	Long	The Id of the asset associated with the email open activity.
AssetType	String	The type of the asset associated with the email open activity.
ContactId	Long	The Id of the contact who performed the email open activity.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
EmailRecipientId	String	The Id of the recipient of the email.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
IPAddress	String	The IP address of the sender.
SubjectLine	String	The subject line of the email.
CampaignId	Long	The Id of the campaign associated with the email open activity. Only supported in bulk mode.
DeploymentId	Long	The deployment Id associated with the email open activity. Only supported in bulk mode.
VisitorId	Long	The Id of the visitor associated with the email open activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the email open activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email open activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email open activity.
LastName	String	The LastName of the contact associated with the email open activity.
Company	String	The Company of the contact associated with the email open activity.
City	String	The City of the contact associated with the email open activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email open activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email open activity was created.
Address1	String	The first line address of the contact associated with the email open activity.
Address2	String	The second line address of the contact associated with the email open activity.
Title	String	The Title of the contact associated with the email open activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_EmailSend

Retrieve Email Send Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ExternalId [KEY]	String	The ExternalId associated with the email send activity. Only supported in bulk mode.
ID	Long	The identifier of the email send activity. This is not unique.
Name	String	The name of the email send activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time when the email send activity was created.
Type	String	The activity type of the email send activity.
AssetName	String	The name of the asset associated with the email send activity.
AssetId	Long	The Id of the asset associated with the email send activity.
AssetType	String	The type of the asset associated with the email send activity.
ContactId	Long	The Id of the contact who performed the email send activity.
EmailName	String	The name of the email. Not supported in bulk mode.
EmailWebLink	String	The Web link of the email.
EmailRecipientId	String	The Id of the recipient of the email.
SubjectLine	String	The subject line of the email.
EmailAddress	String	The address of the email. Only supported in bulk mode.
EmailSendType	String	The send type of the email. Only supported in bulk mode.
CampaignId	Long	The Id of the campaign associated with the email send activity. Only supported in bulk mode.
DeploymentId	Long	The deployment Id associated with the email send activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the email send activity.
LastName	String	The LastName of the contact associated with the email send activity.
Company	String	The Company of the contact associated with the email send activity.
City	String	The City of the contact associated with the email send activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email send activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email send activity was created.
Address1	String	The first line address of the contact associated with the email send activity.
Address2	String	The second line address of the contact associated with the email send activity.
Title	String	The Title of the contact associated with the email send activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_EmailSubscribe

Retrieve Email Subscribe Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the email subscribe activity.
Name	String	The name of the email subscribe activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email subscribe activity was created.
Type	String	The activity type of the email subscribe activity.
AssetName	String	The name of the asset associated with the email subscribe activity.
AssetId	Long	The Id of the asset associated with the email subscribe activity.
AssetType	String	The type of the asset associated with the email subscribe activity.
CampaignName	String	The name of the campaign associated with the email subscribe activity. Not supported in bulk mode.
EmailCampaignId	String	The Id of the email campaign associated with the email subscribe activity. Not supported in bulk mode.
EmailAddress	String	The address of the email. Only supported in bulk mode.
EmailRecipientId	String	The Id of the recipient of the email.
CampaignId	Long	The Id of the campaign associated with the email subscribe activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email subscribe activity. Only supported in bulk mode.
ContactId	Long	The Id of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the email subscribe activity.
LastName	String	The LastName of the contact associated with the email subscribe activity.
Company	String	The Company of the contact associated with the email subscribe activity.
City	String	The City of the contact associated with the email subscribe activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email subscribe activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email subscribe activity was created.
Address1	String	The first line address of the contact associated with the email subscribe activity.
Address2	String	The second line address of the contact associated with the email subscribe activity.
Title	String	The Title of the contact associated with the email subscribe activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_EmailUnsubscribe

Retrieve Email Unsubscribe Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the email unsubscribe activity.
Name	String	The name of the email unsubscribe activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the email unsubscribe activity was created.
Type	String	The type of email unsubscribe activity.
AssetName	String	The name of the asset associated with the email unsubscribe activity.
AssetId	Long	The Id of the asset associated with the email unsubscribe activity.
AssetType	String	The type of the asset associated with the email unsubscribe activity.
CampaignName	String	The name of the campaign associated with the email unsubscribe activity. Not supported in bulk mode.
EmailCampaignId	String	The Id of the email campaign associated with the email unsubscribe activity. Not supported in bulk mode.
EmailRecipientId	String	The Id of the recipient of the email.
EmailAddress	String	The address of the email. Only supported in bulk mode.
CampaignId	Long	The Id of the campaign associated with the email unsubscribe activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the email unsubscribe activity. Only supported in bulk mode.
ContactId	Long	The Id of the contact associated with the bounceback activity.
FirstName	String	The FirstName of the contact associated with the email unsubscribe activity.
LastName	String	The LastName of the contact associated with the email unsubscribe activity.
Company	String	The Company of the contact associated with the email unsubscribe activity.
City	String	The City of the contact associated with the email unsubscribe activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the email unsubscribe activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the email unsubscribe activity was created.
Address1	String	The first line address of the contact associated with the email unsubscribe activity.
Address2	String	The second line address of the contact associated with the email unsubscribe activity.
Title	String	The Title of the contact associated with the email unsubscribe activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_FormSubmit

Retrieve Form Submit Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the form submit activity.
Name	String	The name of the form submit activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the form submit activity was created.
Type	String	The activity type of the form submit activity.
AssetName	String	The name of the asset associated with the form submit activity.
AssetId	Long	The Id of the asset associated with the form submit activity.
AssetType	String	The type of the asset associated with the form submit activity.
ContactId	Long	The Id of the contact who performed the form submit activity.
Collection	String	The collection of the form submit activity. Not supported in bulk mode.
FormName	String	The name of the form associated with the form submit activity. Not supported in bulk mode.
FormData	String	The data of the form associated with the form submit activity. Not supported in bulk mode.
RawData	String	The raw data of the form submit activity. Only supported in bulk mode.
CampaignId	Long	The Id of the campaign associated with the form submit activity. Only supported in bulk mode.
VisitorId	Long	The Id of the visitor associated with the form submit activity. Only supported in bulk mode.
VisitorExternalId	String	The ExternalId of the visitor associated with the form submit activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the form submit activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the form submit activity.
LastName	String	The LastName of the contact associated with the form submit activity.
Company	String	The Company of the contact associated with the form submit activity.
City	String	The City of the contact associated with the bounceback activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the form submit activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the form submit activity was created.
Address1	String	The first line address of the contact associated with the form submit activity.
Address2	String	The second line address of the contact associated with the form submit activity.
Title	String	The Title of the contact associated with the form submit activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_PageView

Retrieve Page View Activities. This table is only supported in bulk mode.

Table Specific Information

Select

COUNT is supported for this table.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier of the page view activity.
CreatedAt	Datetime	The date and time the page view activityactivity was created.
Type	String	The type of the activity associated with the page view activity.
ContactId	Long	The Id of the contact who performed the page view activity.
IPAddress	String	The IP address of the sender.
Url	String	The URL of the page view activity.
CampaignId	Long	The Id of the campaign associated with the page view activity.
ReferrerUrl	String	The referrer URL of the page view activity.
VisitorId	Long	The visitor Id of the page view activity.
VisitorExternalId	String	The visitor external Id of the page view activity.
WebVisitId	Long	The Web visit Id of the page view activity.
IsWebTrackingOptedIn	Boolean	Whether the visitor who performed the page view activity has opted into Web tracking.
ExternalId	String	The ExternalId associated with the page activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the page view activity.
LastName	String	The LastName of the contact associated with the page view activity.
Company	String	The Company of the contact associated with the page view activity.
City	String	The City of the contact associated with the page view activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the page view activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the page view activity was created.
Address1	String	The first line address of the contact associated with the page view activity.
Address2	String	The second line address of the contact associated with the page view activity.
Title	String	The Title of the contact associated with the page view activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

Activity_WebVisit

Retrieve Web Visit Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns


Name	Type	Description
ID [KEY]	Long	The Id of the Web visit activity.
Name	String	The name of the Web visit activity. Not supported in bulk mode.
CreatedAt	Datetime	The date and time the Web visit activity was created.
Type	String	The type of Web visit activity.
AssetId	Long	The Id of the asset associated with the Web visit activity. Not supported in bulk mode.
AssetType	String	The type of the asset associated with the Web visit activity. Not supported in bulk mode.
ContactId	Long	The Id of the contact who performed the Web visit activity. Not supported in bulk mode.
Duration	String	The duration of the Web visit activity.
QueryString	String	The query string of the Web visit activity. Not supported in bulk mode.
QueryStringDisplay	String	The query string display of the Web visit activity. Not supported in bulk mode.
Thread	String	The thread of the Web visit activity. Not supported in bulk mode.
URL	String	The URL of the Web visit activity. Not supported in bulk mode.
ReferrerUrl	String	The Referrer URL of the Web visit activity. Only supported in bulk mode.
VisitorId	Long	The Id of the visitor associated with the Web visit activity. Only supported in bulk mode.
VisitorExternalId	String	The visitor external Id of the Web visit activity. Only supported in bulk mode.
ExternalId	String	The ExternalId associated with the Web visit activity. Only supported in bulk mode.
NumberOfPages	String	The number of pages of the Web visit activity. Only supported in bulk mode.
IpAddress	String	The IP address of the Web visit activity. Only supported in bulk mode.
FirstPageViewUrl	String	The first page view URL of the Web visit activity. Only supported in bulk mode.
FirstName	String	The FirstName of the contact associated with the Web visit activity.
LastName	String	The LastName of the contact associated with the Web visit activity.
Company	String	The Company of the contact associated with the Web visit activity.
City	String	The City of the contact associated with the Web visit activity.
ContactCreatedAt	Datetime	The date and time the contact associated with the Web visit activity was created.
ContactModifiedAt	Datetime	The date and time the contact associated with the Web visit activity was created.
Address1	String	The first line address of the contact associated with the Web visit activity.
Address2	String	The second line address of the contact associated with the Web visit activity.
Title	String	The Title of the contact associated with the Web visit activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ExportToken	String	The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth	String	The depth of information requested from Eloqua.

CampaignElement

Retrieve Campaign Elements.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the campaign element.
Name	String	The name of the campaign element.
Type	String	The type of the campaign element.
FolderId	Long	The folder Id of the campaign element.
FormId	String	The form Id of the campaign element.
EmailId	String	The email Id of the campaign element.
LandingPageId	String	The landing page Id of the campaign element.
SegmentId	String	The segment Id of the campaign element.
ListId	String	The list Id of the campaign element.
CampaignId	String	The campaign Id of the campaign element.
memberCount	Integer	The member count of the campaign element.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

CampaignField

Retrieve Campaign Fields.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the campaign field.
Name	String	The name of the campaign field.
DataType	String	The data type of the campaign field.
Description	String	The description of the campaign field.
DisplayType	String	The display type of the campaign field.
DisplayIndex	String	The display index of the campaign field.
FolderId	Long	The folder Id of the campaign field.
IsReadOnly	Boolean	Identifies whether the campaign field is read-only.
IsRequired	Boolean	Identifies whether the campaign field is required.
CreatedAt	Datetime	Date the campaign field was created.
CreatedBy	String	The Id of the user who created the campaign field.
Depth	String	The depth of the campaign field.

CampaignFolder

Retrieve Campaign Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContactField

Retrieve Contact Fields.

Table Specific Information

The EmailAddress column is required to insert into or to update the Contact table. For example,

UPDATE [Contact] SET emailAddress='example@test.com',firstName='test' WHERE ID = ?

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact field.
Name	String	The name of the contact field.
UpdateType	String	The update rule for when to update this field.
CheckedValue	String	The checked value of the contact field.
DataType	String	The data type of the contact field.
DefaultValue	String	The default value for the contact field.
Description	String	The description of the contact field.
DisplayType	String	The display type of the contact field.
FolderId	Long	The folder Id of the contact field.
InternalName	String	The country of the contact field.
IsReadOnly	Boolean	Identifies whether the contact field is read-only.
IsRequired	Boolean	Identifies whether the contact field is required.
IsStandard	Boolean	Identifies whether the contact field is standard.
OptionListId	Long	The Id of the option list for the contact field.
OutputFormatId	Long	The Id of the output format for the contact field.
ScheduledFor	String	The date and time scheduled for the contact field.
SourceTemplatedId	Long	The Id of the source template for the contact field
UncheckedValue	String	The unchecked value of the contact field.
Permissions	String	The permissions of the contact field.
CreatedAt	Datetime	Date the contact field was created.
CreatedBy	String	The Id of the user who created the contact field.
AccessedAt	Datetime	Date the contact field was accessed.
CurrentStatus	String	The current status of the contact field.
Depth	String	The depth of the contact field.
UpdatedAt	Datetime	Date the contact field was updated.
UpdatedBy	String	The Id of the user who last updated the contact field.

ContactFilter

Retrieve Contact Filters.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact filter.
Name	String	The name of the contact filter.
Type	String	The type of the contact filter.
FolderId	Long	The folder Id of the contact filter.
Description	String	The description of the contact filter.
ScheduledFor	String	The date and time scheduled for the contact filter.
Scope	String	The scope of the contact filter.
Statement	String	The statement of the contact filter.
Permissions	String	The permissions of the contact filter.
CreatedAt	Datetime	Date the contact filter was created.
CreatedBy	String	The Id of the user who created the contact filter.
AccessedAt	Datetime	Date the contact filter field was accessed.
CurrentStatus	String	The current status of the contact filter.
Depth	String	The depth of the contact filter.
UpdatedAt	Datetime	Date the contact filter was updated.
UpdatedBy	String	The Id of the user who last updated the contact filter.

ContactFilterFolder

Retrieve Contact Filter Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContactList

Create, update, delete, and query Contact Lists.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact list.
Name	String	The name of the contact list.
Count	String	The count of the contact list.
DataLookupId	String	The Id of the data lookup for the contact list.
MembershipAdditions	String	The number of contact membership additions in the contact list.
Scope	String	The contact list's scope: either local or global.
Description	String	The description of the contact list.
FolderId	Long	The Id of the folder for the contact list.
ScheduledFor	Datetime	The date and time scheduled for the contact list.
SourceTemplatedId	Long	The Id of the source template of the contact list.
Permissions	String	The permissions of the contact list.
CreatedAt	Datetime	Date the contact list was created.
CreatedBy	String	The Id of the user who created the contact list.
AccessedAt	Datetime	Date the contact list was accessed.
CurrentStatus	String	The current status of the contact list.
Depth	String	The depth of the contact list.
UpdatedAt	Datetime	Date the contact list was updated.
UpdatedBy	String	The Id of the user who created the contact list.

ContactListFolder

Retrieve Contact List Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContactScoringModelFolder

Retrieve Contact Scoring Model Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContactSegmentData

Retrieve Contact Segment Data. Note: The pseudo column SegmentID must be specified to retrieve the data of this table. This SegmentID can be retrieved from the ContactSegment table's ID column.

Columns


Name	Type	Description
ID [KEY]	Int64	The unique identifier of the content segment data.
AccountName	String	This field is generated dynamically and corresponds to the AccountName field in the API.
BouncebackDate	String	This field is generated dynamically and corresponds to the BouncebackDate field in the API.
IsBounceback	Boolean	This field is generated dynamically and corresponds to the IsBounceback field in the API.
IsSubscribed	Boolean	This field is generated dynamically and corresponds to the IsSubscribed field in the API.
SubscriptionDate	Datetime	This field is generated dynamically and corresponds to the SubscriptionDate field in the API.
UnsubscriptionDate	Datetime	This field is generated dynamically and corresponds to the UnsubscriptionDate field in the API.
CreatedAt	Datetime	This field is generated dynamically and corresponds to the CreatedAt field in the API.
CreatedBy	String	This field is generated dynamically and corresponds to the CreatedBy field in the API.
AccessedAt	Datetime	This field is generated dynamically and corresponds to the AccessedAt field in the API.
CurrentStatus	String	This field is generated dynamically and corresponds to the CurrentStatus field in the API.
Depth	String	This field is generated dynamically and corresponds to the Depth field in the API.
UpdatedAt	Datetime	This field is generated dynamically and corresponds to the UpdatedAt field in the API.
UpdatedBy	String	This field is generated dynamically and corresponds to the UpdatedBy field in the API.
Email Address	String	This field is generated dynamically and corresponds to the Email Address field in the API.
First Name	String	This field is generated dynamically and corresponds to the First Name field in the API.
Last Name	String	This field is generated dynamically and corresponds to the Last Name field in the API.
Company	String	This field is generated dynamically and corresponds to the Company field in the API.
Email Display Name	String	This field is generated dynamically and corresponds to the Email Display Name field in the API.
Address 1	String	This field is generated dynamically and corresponds to the Address 1 field in the API.
Address 2	String	This field is generated dynamically and corresponds to the Address 2 field in the API.
Address 3	String	This field is generated dynamically and corresponds to the Address 3 field in the API.
City	String	This field is generated dynamically and corresponds to the City field in the API.
State or Province	String	This field is generated dynamically and corresponds to the State or Province field in the API.
Zip or Postal Code	String	This field is generated dynamically and corresponds to the Zip or Postal Code field in the API.
Country	String	This field is generated dynamically and corresponds to the Country field in the API.
Business Phone	String	This field is generated dynamically and corresponds to the Business Phone field in the API.
Mobile Phone	String	This field is generated dynamically and corresponds to the Mobile Phone field in the API.
Fax	String	This field is generated dynamically and corresponds to the Fax field in the API.
Title	String	This field is generated dynamically and corresponds to the Title field in the API.
Salutation	String	This field is generated dynamically and corresponds to the Salutation field in the API.
Salesperson	String	This field is generated dynamically and corresponds to the Salesperson field in the API.
SFDC Contact ID	String	This field is generated dynamically and corresponds to the SFDC Contact ID field in the API.
SFDC Lead ID	String	This field is generated dynamically and corresponds to the SFDC Lead ID field in the API.
Date Created	Datetime	This field is generated dynamically and corresponds to the Date Created field in the API.
Date Modified	Datetime	This field is generated dynamically and corresponds to the Date Modified field in the API.
Eloqua Contact ID	String	This field is generated dynamically and corresponds to the Eloqua Contact ID field in the API.
SFDC Account ID	String	This field is generated dynamically and corresponds to the SFDC Account ID field in the API.
Last Modified by CRM System	Datetime	This field is generated dynamically and corresponds to the Last Modified by CRM System field in the API.
Last SFDC Campaign ID	String	This field is generated dynamically and corresponds to the Last SFDC Campaign ID field in the API.
Last SFDC Campaign Status	String	This field is generated dynamically and corresponds to the Last SFDC Campaign Status field in the API.
Company Revenue	String	This field is generated dynamically and corresponds to the Company Revenue field in the API.
SFDC Email Opt Out	String	This field is generated dynamically and corresponds to the SFDC Email Opt Out field in the API.
Lead Source - Most Recent	String	This field is generated dynamically and corresponds to the Lead Source - Most Recent field in the API.
Lead Source - Original	String	This field is generated dynamically and corresponds to the Lead Source - Original field in the API.
Industry	String	This field is generated dynamically and corresponds to the Industry field in the API.
Annual Revenue	String	This field is generated dynamically and corresponds to the Annual Revenue field in the API.
Lead Status	String	This field is generated dynamically and corresponds to the Lead Status field in the API.
Job Role	String	This field is generated dynamically and corresponds to the Job Role field in the API.
Lead Score - High Value Website Content	Double	This field is generated dynamically and corresponds to the Lead Score - High Value Website Content field in the API.
Lead Score Date - Engagement - Most Recent	Datetime	This field is generated dynamically and corresponds to the Lead Score Date - Engagement - Most Recent field in the API.
Integrated Marketing and Sales Funnel Stage	String	This field is generated dynamically and corresponds to the Integrated Marketing and Sales Funnel Stage field in the API.
Product/Solution of Interest	String	This field is generated dynamically and corresponds to the Product/Solution of Interest field in the API.
Region	String	This field is generated dynamically and corresponds to the Region field in the API.
PURL Name (Default Hypersite)	String	This field is generated dynamically and corresponds to the PURL Name (Default Hypersite) field in the API.
Lead Rating - Combined	String	This field is generated dynamically and corresponds to the Lead Rating - Combined field in the API.
Email Address Domain	String	This field is generated dynamically and corresponds to the Email Address Domain field in the API.
First and Last Name	String	This field is generated dynamically and corresponds to the First and Last Name field in the API.
Company Size	String	This field is generated dynamically and corresponds to the Company Size field in the API.
Lead Score - Last High Touch Event Date	Datetime	This field is generated dynamically and corresponds to the Lead Score - Last High Touch Event Date field in the API.
Lead Rating - Profile (Explicit)	String	This field is generated dynamically and corresponds to the Lead Rating - Profile (Explicit) field in the API.
Lead Rating - Engagement (Implicit)	String	This field is generated dynamically and corresponds to the Lead Rating - Engagement (Implicit) field in the API.
Lead Score - Profile (Explicit)	Double	This field is generated dynamically and corresponds to the Lead Score - Profile (Explicit) field in the API.
Lead Score - Engagement (Implicit)	Double	This field is generated dynamically and corresponds to the Lead Score - Engagement (Implicit) field in the API.
Lead Score Date - Profile - Most Recent	Datetime	This field is generated dynamically and corresponds to the Lead Score Date - Profile - Most Recent field in the API.
Employees	Double	This field is generated dynamically and corresponds to the Employees field in the API.
Territory	String	This field is generated dynamically and corresponds to the Territory field in the API.
Lead Score	String	This field is generated dynamically and corresponds to the Lead Score field in the API.
PURL Name	String	This field is generated dynamically and corresponds to the PURL Name field in the API.
MD5 Hashed Email Address	String	This field is generated dynamically and corresponds to the MD5 Hashed Email Address field in the API.
SHA256 Hashed Email Address	String	This field is generated dynamically and corresponds to the SHA256 Hashed Email Address field in the API.
MD5 Hashed Business Phone	String	This field is generated dynamically and corresponds to the MD5 Hashed Business Phone field in the API.
SHA256 Hashed Business Phone	String	This field is generated dynamically and corresponds to the SHA256 Hashed Business Phone field in the API.
MD5 Hashed Mobile Phone	String	This field is generated dynamically and corresponds to the MD5 Hashed Mobile Phone field in the API.
SHA256 Hashed Mobile Phone	String	This field is generated dynamically and corresponds to the SHA256 Hashed Mobile Phone field in the API.
onlineInsertTest	String	This field is generated dynamically and corresponds to the onlineInsertTest field in the API.
Survey Initial Meeting Date & Time	Datetime	This field is generated dynamically and corresponds to the Survey Initial Meeting Date & Time field in the API.
TestColumn1	String	This field is generated dynamically and corresponds to the TestColumn1 field in the API.
TestColumn2	String	This field is generated dynamically and corresponds to the TestColumn2 field in the API.
TestColumn3	String	This field is generated dynamically and corresponds to the TestColumn3 field in the API.
TestColumn4	String	This field is generated dynamically and corresponds to the TestColumn4 field in the API.
TestColumn5	String	This field is generated dynamically and corresponds to the TestColumn5 field in the API.

ContactSegmentFolder

Retrieve Contact Segment Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContactView

Retrieve Contact Views.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the contact view.
Name	String	The name of the contact view.
Description	String	The description of the contact view.
Permissions	String	The permissions of the contact view.
CreatedAt	Datetime	Date the contact view was created.
CreatedBy	String	The Id of the user who created the contact view.
AccessedAt	Datetime	Date the contact view was accessed.
UpdatedAt	Datetime	Date the contact view was updated.
UpdatedBy	String	The Id of the user who last updated the contact view.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ContentSectionFolder

Retrieve Content Section Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Dependencies

Retrieve Dependencies.

Columns


Name	Type	Description
ID [KEY]	Long	TBD.
Name	String	TBD.
Permissions	String	The permissions of the contact list.
Depth	String	The depth of the field.
Type	String	The type of the field.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
ObjectName	String	TDB
ObjectId	String	TBD

DynamicContent

Retrieve Dynamic Contents.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the dynamic content.
Name	String	The name of the dynamic content.
Description	String	The description of the dynamic content.
FolderId	Long	The Id of the folder for the dynamic content.
ScheduledFor	Datetime	The date and time scheduled for the dynamic content.
SourceTemplatedId	Long	The Id of the source template of the dynamic content.
Permissions	String	The permissions of the dynamic content.
CreatedAt	Datetime	Date the dynamic content was created.
CreatedBy	String	The Id of the user who created the dynamic content.
AccessedAt	Datetime	Date the dynamic content was accessed.
CurrentStatus	String	The current status of the dynamic content.
UpdatedAt	Datetime	Date the dynamic content was last updated.
UpdatedBy	String	The Id of the user who last updated the dynamic content.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

DynamicContentFolder

Retrieve Dynamic Content Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

EmailDeployment

Retrieve email deployments.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the email deployment.
Name	String	The name of the email deployment.
CurrentStatus	String	The current status of the email deployment.
SuccessfulSendCount	Int	The successful send count of the email deployment.
FailedSendCount	Int	The failed send count of the email deployment.
ContactId	String	The contact ID of the email deployment.
SendFromUserId	String	The sent user ID of the email deployment.
EndAt	Datetime	Date the email deployment ended.
Permissions	String	The permissions of the email deployment.
Email_ID	Long	The unique identifier of the email.
Email_Name	String	The name of the email.
Email_EmailGroupId	Long	The Id of the email group.
Email_IsPlainTextEditable	Boolean	Identifies whether the email is plaintext editable.
Email_IsTracked	Boolean	Identifies whether the email is tracked.
Email_PlainText	String	The plaintext version of the email.
Email_BouncebackEmail	String	The bounce-back email address.
Email_ReplyToEmail	String	The email address in the reply-to line of the email.
Email_ReplyToName	String	The name in the reply-to line of the email.
Email_SenderEmail	String	The email address of the sender.
Email_SenderName	String	The name of the sender.
Email_SendPlainTextOnly	Boolean	Identifies whether the plaintext version should be sent.
Email_Subject	String	The subject of the email.
Email_Description	String	The description of the email.
Email_FolderId	Long	The Id of the folder for the email.
Email_Permissions	String	The permissions of the email.
Email_CreatedAt	Datetime	Date the email was created.
Email_CreatedBy	String	The Id of the user who created the email.
Email_CurrentStatus	String	The current status of the email.
Email_UpdatedAt	Datetime	Date the email was updated.
Email_UpdatedBy	String	The Id of the user who last updated the email.
Email_HtmlContent_Type	String	The type for the content of the email.
Email_HtmlContent_ContentSource	String	The content source for the content of the email.
Email_HtmlContent_DocType	String	The doc type for the content of the email.
Email_HtmlContent_HTMLBody	String	The HTML body for the content of the email.
Email_HtmlContent_Root	String	The root for the content of the email.
Email_HtmlContent_MetaTags	String	The meta tags for the content of the email.
Email_HtmlContent_SystemHeader	String	The system header for the content of the email.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

EmailFolder

Retrieve Email Folders.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

EmailFooterFolder

Retrieve Email Footer Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

EmailHeaderFolder

Retrieve Email Header Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ExternalType

Retrieve External Types.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the external type.
Name	String	The name of the external type.
Description	String	The description of the external type.
FolderId	Long	The Id of the folder for the external type.
ScheduledFor	Datetime	The date and time scheduled for the external type.
SourceTemplatedId	Long	The Id of the source template of the external type.
Permissions	String	The permissions of the external type.
CreatedAt	Datetime	Date the external type was created.
CreatedBy	String	The Id of the user who created the external type.
AccessedAt	Datetime	Date the external type was accessed.
CurrentStatus	String	The current status of the external type.
UpdatedAt	Datetime	Date the external type was updated.
UpdatedBy	String	The Id of the user who last updated the external type.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

FieldMerge

Retrieve Field Merges.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the field merge.
Name	String	The name of the field merge.
Description	String	The description of the field merge.
FolderId	Long	The Id of the folder for the field merge.
ScheduledFor	Datetime	The date and time scheduled for the field merge.
SourceTemplatedId	Long	The Id of the source template of the field merge.
Permissions	String	The permissions of the field merge.
CreatedAt	Datetime	Date the field merge was created.
CreatedBy	String	The Id of the user who created the field merge.
AccessedAt	Datetime	Date the field merge was accessed.
CurrentStatus	String	The current status of the field merge.
UpdatedAt	Datetime	Date the field merge was updated.
UpdatedBy	String	The Id of the user who last updated the field merge.
Syntax	String	The syntax of the field merge.
DefaultValue	String	The default value of the data lookup for the field merge.
ContactFieldId	Long	The contact field Id of the field merge.
AccountFieldId	Long	The account field Id of the field merge.
EventId	Long	The event Id of the field merge.
EventFieldId	Long	The event field Id of the field merge.
EventSessionFieldId	Long	The event session field Id of the field merge.
MergeType	String	The merge type of the field merge.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

FieldMergeFolder

Retrieve Field Merge Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

FormElement

Retrieve Form Elements.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the form element.
CreatedFromContactFieldId	Long	The contact field Id which created the form element.
Name	String	The name of the form element.
Type	String	The type of the form element.
DataType	String	The data type of the form element.
HTMLName	String	The HTML name of the form element.
Style	String	The style of the form element.
Instructions	String	The instructions of the form element.
Validations	String	The validations of the form element.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
FormId	String	TBD
Depth	String	The depth of information requested from Eloqua.

FormFolder

Retrieve Form Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

FormProcessingStep

Retrieve Form Processing Steps.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the form processing step.
Name	String	The name of the form processing step.
Type	String	The type of the form processing step.
Condition	String	The condition of the form processing step.
execute	String	The execute of the form processing step.
Mappings	String	The mappings of the form processing step.
keyFieldMapping	String	The key field mapping of the form processing step.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
FormId	String	TBD
Depth	String	The depth of information requested from Eloqua.

HyperlinkFolder

Retrieve Hyperlink Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Image

Retrieve Image.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the image.
Name	String	The name of the image.
Permissions	String	The permissions of the image.
Description	String	The description of the image.
FolderId	Long	The folder Id of the image.
CreatedAt	Datetime	Date the image was created.
CreatedBy	String	The Id of the user who created the image.
UpdatedAt	Datetime	Date the image was last updated.
UpdatedBy	String	The Id of the user who last updated the image.
FullImageUrl	String	The full image URL of the image.
ThumbNailUrl	String	The thumb nail URL of the image.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ImageFolder

Retrieve Image Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

ImportedFile

Retrieve Imported Files.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the imported file.
Name	String	The name of the imported file.
Type	String	The type of the imported file.
FolderId	Long	The folder Id of the imported file.
FileName	String	The file name of the imported file.
Link	String	The link of the imported file.
TrackedLink	String	The tracked link of the imported file.
Permissions	String	The permissions of the imported file.
CreatedAt	Datetime	Date the imported file was created.
CreatedBy	String	The Id of the user who created the imported file.
AccessedAt	Datetime	Date the imported file was accessed.
Depth	String	The depth of the imported file.
UpdatedAt	Datetime	Date the imported file was updated.
UpdatedBy	String	The Id of the user who last updated the imported file.

ImportedFileFolder

Retrieve Imported File Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

LandingPageFolder

Retrieve Landing Page Folders.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the folder.
Name	String	The name of the folder.
IsSystem	Boolean	Identifies a system-generated folder.
Description	String	The description of the folder.
Permissions	String	The permissions of the folder.
CreatedAt	Datetime	Date the folder was created.
CreatedBy	String	The Id of the user who created the folder.
AccessedAt	Datetime	Date the folder was accessed.
CurrentStatus	String	The current status of the folder.
UpdatedAt	Datetime	Date the folder was last updated.
UpdatedBy	String	The Id of the user who last updated the folder.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

LeadScoringModel

Query Lead Scoring Models.

Columns


Name	Type	Description
ID [KEY]	Integer	The unique identifier for the landing page.
Name	String	The name of the landing page.
Status	String	The status of the lead scoring model.
Rating	String	The rating of the lead scoring model.
ProfileScore	String	The profiles core of the lead scoring model.
EngagementScore	String	The engagement score of the lead scoring model.
Uri	String	The URI of the lead scoring model.
CreatedBy	String	The Id of the user who created the lead scoring model.
UpdatedBy	String	The Id of the user who updated the lead scoring model.
CreatedAt	Timestamp	Date the lead scoring model was created.
UpdatedAt	Timestamp	Date the lead scoring model was updated.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

PageTag

Retrieve Page Tags.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the page tag.
Name	String	The name of the page tag.
Description	String	The description of the page tag.
Permissions	String	The permissions of the page tag.
CreatedAt	Datetime	Date the page tag was created.
CreatedBy	String	The Id of the user who created the page tag.
AccessedAt	Datetime	Date the page tag was accessed.
CurrentStatus	String	The current status of the page tag.
UpdatedAt	Datetime	Date the page tag was updated.
UpdatedBy	String	The Id of the user who last updated the page tag.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

PageTagGroup

Retrieve Page Tag Groups.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the page tag group.
Name	String	The name of the page tag group.
Description	String	The description of the page tag group.
Permissions	String	The permissions of the page tag group.
CreatedAt	Datetime	Date the page tag group was created.
CreatedBy	String	The Id of the user who created the page tag group.
AccessedAt	Datetime	Date the page tag group was accessed.
CurrentStatus	String	The current status of the page tag group.
UpdatedAt	Datetime	Date the page tag group was updated.
UpdatedBy	String	The Id of the user who last updated the page tag group.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Program

Retrieve Programs.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the program.
Name	String	The name of the program.
Description	String	The description of the program.
FolderId	Long	The Id of the folder for the program.
ScheduledFor	Datetime	The date and time scheduled for the program.
SourceTemplatedId	Long	The Id of the source template of the program.
Permissions	String	The permissions of the program.
CreatedAt	Datetime	Date the program list was created.
CreatedBy	String	The Id of the user who created the program.
AccessedAt	Datetime	Date the program was accessed.
UpdatedAt	Datetime	Date the program was updated.
UpdatedBy	String	The Id of the user who last updated the program.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Style

Retrieve Styles.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the style.
Name	String	The name of the style.
Description	String	The description of the style.
UpdatedAt	Datetime	Date the style was last updated.
CreatedAt	Datetime	Date the style was created.
Body	String	The body of the style.
Column1	String	Column 1 of the style.
Column2	String	Column 2 of the style.
Column3	String	Column 3 of the style.
Footer	String	The footer of the style.
Header	String	The header of the style.
Headline	String	The headline of the style.
Icon	String	The icon of the style.
Page	String	The page of the style.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Template

Retrieve Templates.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the template.
Name	String	The name of the template.
Description	String	The description of the template.
FolderId	Long	The Id of the folder for the template.
ScheduledFor	Datetime	The date and time scheduled for the template.
SourceTemplateId	Long	The source template Id of the template.
Permissions	String	The permissions of the template.
CreatedAt	Datetime	Date the template was created.
CreatedBy	String	The Id of the user who created the template.
AccessedAt	Datetime	Date the template was accessed.
CurrentStatus	String	The current status of the template.
UpdatedAt	Datetime	Date the template was last updated.
UpdatedBy	String	The Id of the user who last updated the template.
AssetType	String	The asset type of the template.
AssetId	Long	The asset Id of the template.
CategoryId	Long	The category Id of the template.
DocumentAtionTitle	String	The documentation title of the template.
DocumentAtionUrl	String	The documentation URL of the template.
IsContentProtected	Boolean	Identifies whether the template is content protected.
UseThumbnail	Boolean	Identifies whether the template uses a thumbnail.
IconUrl	String	The icon URL of the template.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

TemplateCategory

Retrieve Template Categories.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the template category.
Name	String	The name of the template.
Description	String	The description of the template category.
FolderId	Long	The Id of the folder for the template category.
ScheduledFor	Datetime	The date and time scheduled for the template category.
SourceTemplateId	Long	The source template Id of the template category.
Permissions	String	The permissions of the template category.
CreatedAt	Datetime	Date the template category was created.
CreatedBy	String	The Id of the user who created the template category.
AccessedAt	Datetime	Date the template category was accessed.
CurrentStatus	String	The current status of the template category.
UpdatedAt	Datetime	Date the template category was updated.
UpdatedBy	String	The Id of the user who last updated the template category.
SiteId	Long	The site Id of the template category.
DefaultTemplateIconUrl	String	The default template icon URL of the template category.
IconUrl	String	The icon URL of the template category.
Publisher	String	The publisher of the template category.
Campaigns	Int	The campaigns of the template category.
ContactSegments	Int	The contact segments of the template category.
Forms	Int	The forms of the template category.
LandingPages	Int	The landing pages of the template category.
Emails	Int	The emails of the template category.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

TrackedUrl

Retrieve Tracked Urls.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for the tracked URL.
Name	String	The name of the tracked URL.
Description	String	The description of the tracked URL.
FolderId	Long	The Id of the folder for the tracked URL.
ScheduledFor	Datetime	The date and time scheduled for the tracked URL.
SourceTemplatedId	Long	The Id of the source template of the tracked URL.
Permissions	String	The permissions of the tracked URL.
CreatedAt	Datetime	Date the tracked URL was created.
CreatedBy	String	The Id of the user who created the tracked URL.
AccessedAt	Datetime	Date the tracked URL was accessed.
CurrentStatus	String	The current status of the tracked URL.
Depth	String	The depth of the tracked URL.
UpdatedAt	Datetime	Date the tracked URL was last updated.
UpdatedBy	String	The Id of the user who last updated the tracked URL.
Url	String	The URL of the tracked URL.

User

Retrieve Users.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	Description
ID [KEY]	Long	The unique identifier for this user.
Name	String	The name of the user.
Company	String	The company of the user.
Capabilities	String	The capabilities of the user.
BetaAccess	String	The beta access flag for the user.
DefaultAccountViewId	Long	The Id of the default account view for the user.
DefaultContactViewId	Long	The Id of the default contact view for the user.
EmailAddress	String	The email address of the user.
LoggedInAt	String	When the user last logged in.
LoginName	String	The login name of the user.
Preferences	String	The preferences for the user.
ProductPermissions	String	The product permissions for the user.
TypePermissions	String	The type permissions for the user.
ScheduledFor	Datetime	The date and time scheduled for the user.
SourceTemplatedId	Long	The Id of the source template for the user.
Description	String	The description of the user.
FolderId	Long	The Id of the folder for the user.
Permissions	String	The permissions of the user.
CreatedAt	Datetime	Date the user was created.
CreatedBy	String	The Id of the user that created the user.
AccessedAt	Datetime	Date the user was accessed.
CurrentStatus	String	The current status of the user.
Depth	String	The depth of the user.
UpdatedAt	Datetime	Date the user was updated.
UpdatedBy	String	The Id of the user who last updated the user.

Visitor

Retrieve Visitors.

Table Specific Information

Select

Additionally, the UpdatedAt column only supports filtering with the '>' operator.

Columns


Name	Type	Description
VisitorId [KEY]	Long	The Id of the visitor profile.
CreatedAt	Datetime	Date the visitor profile was created.
V_IPAddress	String	IP address of the visitor.
V_LastVisitDateAndTime	Datetime	Date of last visit to an Eloqua asset for this profile.
ExternalId	String	Customer GUID for this visitor profile.
ContactId	Long	The Id of the contact associated with this profile, if any.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

VisitorProfileField

Retrieve all of the visitor profile fields.

Columns


Name	Type	Description
Id [KEY]	Long	The Id of the visitor profile field.
Type	String	The type of the visitor profile field.
name	String	The name of the visitor profile field.
DataType	String	The datatype of the visitor profile field.
InternalName	String	The internal name of the visitor profile field.
Length	Long	The length of the visitor profile field.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.


Name	Type	Description
Depth	String	The depth of information requested from Eloqua.

Matillion Data Model for Oracle EloquaVersion - 21.0.8123.0

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Authentication on Headless Machines

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Data Type

Default Value

Remarks

Matillion Data Model for Oracle Eloqua
Version - 21.0.8123.0