P
Prasanna Anireddy
Guest
Eloqua does not require any Views to support “SELECT *” operations. However it requires that Eloqua data source be configured with Custom Property FailOnIncompleteData=0. Eloqua driver uses standard API(non-Bulk) or Bulk API of Eloqua to access the data. The Bulk API only supports reading less than 100 columns in each query but returns complete data. The Standard API supports reading all the fields but has a limitation of not returning data for few of the columns (For example, Contact.AccountId). If you need to run “select *” query on Account or Contact tables (these tables have more than 100 columns), you need to set the FailOnIncompleteData=0 option. This will result in any columns that cannot be retrieved in the non-bulk API to be returned as NULL. If user wants to get complete data for each column in the query, the query needs to be rewritten to include less than 100 columns. Thanks Prasanna
Continue reading...
Continue reading...