HANA and OBIEE connectivity issue
We are trying to connect OBIEE BI Admin tool with HANA DB. The connection is successful add a connection. But while fetching sample data from a table, we are facing an error as mentioned here below.
[nQSError: 16015] SQL statement execution failed.
[nQSError: 16001] ODBC error state : S1000 code : -10808 message: [SAP AG][LIBODBCHDB32 DLL][HDB] General error; -10808 Feature (SCROLLABLE RESULT) not implemented yet in function module: d:\depot\bas\IMP\NEWDB100_REL\src/sys/src.
Has anyone tried this already and achieved successfully?
Please advice, thanks in advance.
To my knowledge, OBIEE is not supported by SAP HANA. I've tested the connection with the latest versions of SAP HANA and OBIEE and the same error still exists.
I attempted to get this working last year and sought out ways of turning off Scrollable Results from OBIEE. I never received a response to questions I posed to Oracle and did not find any settings in OBIEE to do so either. In the end, either Oracle will need to provide the option to turn off scrollable results, or SAP will need to support this feature.