HANA and OBIEE connectivity issue

[former_member186082]

Hi All,

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.

Regards,
Chandu.

[Former Member · Accepted solution]

Hi Chandu,

I worked on a POC that included HANA and OBIEE connectivity. We received the same error that you have above and it's to do with the way that OBIEE generates its SQL statements. It uses a feature, as indicated in your error message, of SCROLLABLE RESULT. This is not support in SAP HANA. We did manage a workaround but it is rather convoluted and may or may not help you.

It is possible to connect OBIEE to a Transient Provider in SAP BW on HANA. The Transient Provider on SAP BW on HANA is a direct connection to the Analytic View within SAP HANA. The connection from OBIEE to SAP BW is based on the standard SAP/BW 3.5/7.0 Data Source connection in OBIEE. This is an XMLA based connection which connects to SAP BW through a SOAP request.

Out of interest, what version of HANA are you running. We did forward our findings to SAP and were hopeful that the ability to support Scrollable Cursors would become available at some stage.

Regards,

Gary Elliott

[former_member186082 · Accepted solution]

Thanks Gary. This really helps and we have to work on this. But at present we need direct connection between OBIEE and HANA, without using BW in between. Currently we are using HANA 1.0 SP4.

Regards,

Chandu

[Former Member · Accepted solution]

Hello.

IMHO, better if you are trying on last  SP  -  SP5, and rev(49).

Does SAP certified OBIEE to work with HANA ?

[Former Member · Accepted solution]

Hi Chandra/Mikhail,

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.

Regards,

Gary

[former_member186082 · Accepted solution]

Thanks Gary. Yes, as you said, direct connectivity is not supported as of now from both Oracle & SAP. As workaround we have to use BW in between as said in your earlier post.

[rama_shankar3 · Accepted solution]

Instead of BW,  I suggest that you  use BODS as well !

[Former Member · Accepted solution]

As of HANA SP7, scrollable cursors has been implemented in HANA. You want to try this out again with SP7?

[former_member532630 · Accepted solution]

HI Sekhar,

We are currently planning a POC using OBIEE directly on HANA, version 1.0 Rev 73, since your post is close to 2 years old, have you ever succeeded in Connecting OBIEE directly on HANA?

If so, could you share your experience / other information with me?

Thanks in advance,

Peer.

[marcom · Accepted solution]

Hi Sekhar,

     I know that OBIEE direct connectivity is not supported. I don't know if now is working (using HANA ver 85 or later).

TIA and regards

Marco

[Former Member]

You get this error only in offline mode with the admintool, no ? (Ie with the windows odbc driver)

For me, it works perfectly when I query a table on Linux.

Message was edited by: Nicolas GERARD. Adding the OS diff.

[Former Member]

For everbody that search for this problem, this is due to the windows driver. You can force the use of a forward only cursor in the DSN options (first screen). If you check this option, your problem will vanish.

Cheers

Nico

[Former Member]

Hi Nicolas

any details for OS switch way? could you please share little more, coz currently our customer met the same issues for HANA with OBIEE in Windows.

[Former Member]

Here you are:

OBIEE - SAP Hana | GerardNico.com (BI, OBIEE, OWB, DataWarehouse)

[Former Member]

Hi Nicolas

thank you so much, I will check customer's setting for that.