Skip to Content

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Dec 31, 2011 at 08:49 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 31, 2011 at 11:09 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • Posted on Jan 03, 2012 at 04:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.