Error using Analysis Office with HANA jDBC Conn: Unable to Open Datasource

[manish_umarwadia2]

HI,

I have created a HANA JDBC connection in IDT and it works fine when I create a UNX using that connection in Webi. However when I log into Analysis Office and use the BOE log on using the Web service url: http://<host>:8080/dswsbobje/services/Session, I run into the following issue:

-I am presented with my connection including the HANA JDBC connection

-I am presented with my Analytic view from HANA

-However when I select that view, I get the following error:

Unable to open data source: <Connection>, <Analytic View>

ERROR [S1000] [SAP AG][SDBODBC DLL][HDB] General error;258 insufficient privilege: Not authorized

I would prefer not using the ODBC connector since that would require DSN creation on client machines among other issues.

Thanks.

[TammyPowlas · Accepted solution]

Manish,

According to what I have read, Analysis Office does not support the JDBC connection to HANA

Only ODBC and BICS (later versions)

So for now it sounds like you can only use ODBC with Analysis Office.

Regards,

Tammy

[manish_umarwadia2]

Hi Tammy,

I was able to figure this one out. A JDBC conection on HANA created using IDT does work with Advanced Analysis Office 1.1. The missing autorization was select provilege on SYSBIC schema.

Manish

[manish_umarwadia2]

HI Tammy,

I have read your presentation on AAO (Analysis Office) with ODBC, however that is a local client-based approach requiring appropriate drivers and DSN creation. From a best practice standpoint, we would prefer managing the HANA connection as a common connection created through IDT and have users log into BOE when using AAO. I have also tried creating an ODBC connection to HANA in IDT (using the ODBC drivers) but that also fails with the following error:

ERROR [HY090] [SAP AG][SDBODBC DLL] Invalid string or buffer length

ERROR [08S01] [SAP AG][SDBODBC DLL][HDB] Communication link failure;-10709 Connection failed (RTE:[89006] System call 'connect' failed, rc=10061:No connection could be made be

[TammyPowlas]

Hello Manish,

I certainly understand.

However, right now (based on an ASUG November presentation I am looking at) SAP HANA IDT connections are not supported for Analysis Office

ODBC/JDBC connections with IDT/SAP HANA are only supported for Crystal for Enterprise, Dashboards, and Web Intelligence

Tammy