Skip to Content
Dec 30, 2011 at 08:12 PM

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



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.