SSIS Components for Oracle Eloqua

Build 24.0.8963

UseBulkAPI

Whether or not the bulk API is used for retrieving data.

Possible Values

Auto, False, True

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 component 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 component will use the REST API for all requests. When set to "Auto", the component will use whichever API is most appropriate for the request. For example, consider the following query:

SELECT * FROM Activity_EmailOpen
In this case, the component 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 component 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963