topic Re: Allowable Oracle DB data types in QlikView

Allowable Oracle DB data types

Thu, 13 Jun 2013 16:20:31 GMT

Is it documented somewhere or can someone tell me what data types are not compatible with QlikView when reading from an oracle database? For instance, I have found out that SDO_GEOMETRY and XMLTYPE cannot simply be loaded via the script (or at least I have not figured out how to do it). Is there a list of database types fields that are acceptable or not? Thanks.

Re: Allowable Oracle DB data types

Gysbert_Wassenaar — Thu, 13 Jun 2013 17:00:26 GMT

The data type has to be supported by the driver. In case of the odbc driver you can find the data type mapping here. I think those kind of data types simply weren't taking into account when defining the odbc specification. The mapping for the oledb driver can be found here.

Re: Allowable Oracle DB data types

Thu, 13 Jun 2013 17:28:56 GMT

Thank you.