Last updated on OCTOBER 09, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.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 220.127.116.11 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=18.104.22.168, 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms