All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo.
<Error Description when retrieving data from Denodo (6.0) to Microsoft Excel
using Excel Microsoft Query intermediated by ODBC connectivity>
'java.sql.SQLException: Field not found ...
in view ...
Error while excecuting the query'
<Root Cause Suggestion>
I have heard that the double quotes in Denodo view column names for handling Camel casing of name, using numbers and special characters in column names caused this error.
Firstly, using Microsoft Query and retrieve relatively compact Denodo views not including double quotes in column names to Excel.
Secondly, once the data retrieval established at any Denodo view, there appears [Query and Connection], so click on property of that.
Thirdly, [Data]-[Connection Property]-[Definition]-[CommandLine(SQL)] can be freely rewritten any query using once established same connectivity, so freely rewrite query even retrieving data from Denodo Views including double quoted column names.
Fouthly, data retrieval from Denodo view to Excel will automatically start without error.