TDV Adapter for FinancialForce

Build 22.0.8462

UseBulkAPI

Whether to use the synchronous SOAP API or the asynchronous Bulk API.

Data Type

bool

Default Value

false

Remarks

This property determines whether or not the asynchronous Bulk API is used for reads and writes to FinancialForce with SSO. For reads, the driver will automatically create bulk query jobs and start returning results as they are available. Note that queries using a JOIN or aggregation are not supported in the Bulk API and therefore the driver will fall back to using the SOAP API for these queries. Jobs are closed automatically once they are complete or if there is a failure.

For writes back to FinancialForce with SSO, up to 10000 records can be sent per batch. These requests will be processed asynchronously meaning the driver will not wait for FinancialForce to process the results fully. You can query the following table to get information about the jobs and batches that were created:

SELECT * FROM "Info#TEMP"

The ID values returned from this can be used with GetJob, GetBatch, and GetBatchResults to check the status of the job and batches.

Note that when this property is set to false, the default, you can still modify multiple records simultaneously: The adapter will perform batch processing through the Web Services API, which will synchronously return the status of your operations. When you invoke the JDBC Batch API, the adapter will batch multiple requests together in a single request to FinancialForce with SSO.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462