Last updated on JUNE 11, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
You are unable to successfully connect to OBIEE 12.2.1 via the ODBC driver with Microsoft Excel 2013 Power Query/Power Pivot whether using the 126.96.36.199 32-bit or 64-bit ODBC driver or with the 12.2.1 64-bit ODBC driver.
You have been able to successfully use this ODBC connectivity with Spotfire and have validated it with Tableau and even with MS Query and pass though queries.
Error received from ODBC Log on client:
06T20:33:17.6291659Z","Action":"Engine/IO/Odbc/Connection/GetInfo32","InfoType":"SQL_SQL_CONFORMANCE","Exception":"Exception:\r\nExceptionType: Microsoft.Mashup.Engine1.Library.Odbc.Interop.OdbcException, Microsoft.MashupEngine, Version=188.8.131.52, Culture=neutral, PublicKeyToken=31bf3856ad364e35\r\nMessage: ERROR [IM001] [NQODBC] [SQL_STATE: IM001] [nQSError: 10039] The driver does not support this function.\r\n\r\nStackTrace:\n at
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms