Location field not accessible when using the UseBulkAPI connection option in the CData Salesforce ODBC Driver

Question

We are using the CData Drivers to retrieve the Data from the Location Object in Salesforce. When we set the UseBulkAPI connection option to True in CData, the Location field in the Location Object is not accessible. If we set the UseBulkAPI connection option to False, the Location field in the Location object is accessible.

Please advise.

Location Object and the Location field is a standard object in Salesforce.

Answer 1

The Bulk API does not support compound fields, including geolocation fields and address fields:

Also, Bulk API can’t access or query compound address or compound geolocation fields.

You can't use the Bulk API with these fields. Your client may or may not be able to work around this limitation by directly accessing the constituent fields of a compound field.