Error : Failed to browse HANA datasources

[former_member188030]

Dear Experts,

I am relatively new to Design Studio and facing an issue with connectivity.

I am using Design studio 15.0.6, connecting to HANA datasurce.

I have installed both 32 and 64 bit versions of HDBODBC driver and I could create DSNs connecting to both.

32 bit DSN is created successfully.

When I try to add a datasource in DS (Data sources - Right Click - Add Data source), I could browse my 32 bit connection and add it.

It does show that the connection is active. However, when i try to browse the Datasource it is throwing and error as shown in attached snapshots.

"Browsing failed : Failed to browse HANA data sources".

Please help.

Thanks,

Bhushan

[TammyPowlas · Accepted solution]

Hi - please see this thread with some helpful answers by Henrique; also check your HANA privileges https://scn.sap.com/thread/3287934

If that doesn't help, please share the version of HANA you are using.

Also see this blog by Victor:

[former_member188030 · Accepted solution]

Hi Tammy,

Thanks for your quick reply as always.

I suspect that this issue is related to privileges on HANA side because when I use the HANA admin account to connect, everything works fine.

So I am working with HANA Admin to gradually increase the access to my account.

A list of required privileges for DS for browsing HANA views would be good to have.

I would surely go through the links you have provided.

Appreciate your help,

Bhushan

[skotti · Accepted solution]

Hi Bhushan,

I am facing the same Problem as you.

Since I couldnt find a solution, would you care to offer your findings?

Kind regards

Sven