In this article it will provide a step-by-step guild on how to connect to an external HANA system from HANA studio. So that Project Shark HANADB on BW will connect to Project Clam HANA_SHR. Actually it has the ability to connect to all sort of data sources such as Oracle, SQL Server, Hadoop big data, etc as long as the client drivers are in place with the HANA DB server.

580a710068f39.jpg

580a7108402a2.jpg

580a7228369cd.jpg

580a7268cf082.jpg

580a711c2ba8a.jpg

In this article it will provide a step-by-step guild on how to connect to an external HANA system from HANA studio. So that Project Shark HANADB on BW will connect to Project Clam HANA_SHR. Actually it has the ability to connect to all sort of data sources such as Oracle, SQL Server, Hadoop big data, etc as long as the client drivers are in place with the HANA DB server. ================== ![580a710068f39.jpg](serve/attachment&path=580a710068f39.jpg) ![580a7108402a2.jpg](serve/attachment&path=580a7108402a2.jpg) ![580a7228369cd.jpg](serve/attachment&path=580a7228369cd.jpg) ![580a7268cf082.jpg](serve/attachment&path=580a7268cf082.jpg) ![580a711c2ba8a.jpg](serve/attachment&path=580a711c2ba8a.jpg)

Project 'Clam' founder

edited Oct 21 '16 at 8:54 pm

For better usage, we have defined an entry within Shark HANADB /etc/hosts file to point to ClamHDB, configuration see below

580a75d510457.jpg

For better usage, we have defined an entry within Shark HANADB /etc/hosts file to point to ClamHDB, configuration see below ================== ![580a75d510457.jpg](serve/attachment&path=580a75d510457.jpg)

Project 'Clam' founder

Hi Adam,
Few questions when try to connect to external Clam HANA system from HANA studio.
1). after login HANA studio, i only see HDB(SHARK), don't have HDB(SYSTEM) HANA Database. Is it ok?
2). I try to add new remote source under HDB(SHARK) Porovisioning, but it complained 'Not authorized', can you pls advice what may cause this error?

Thanks,
Meiping
581566370e297.jpg

Hi Adam, Few questions when try to connect to external Clam HANA system from HANA studio. 1). after login HANA studio, i only see HDB(SHARK), don't have HDB(SYSTEM) HANA Database. Is it ok? 2). I try to add new remote source under HDB(SHARK) Porovisioning, but it complained 'Not authorized', can you pls advice what may cause this error? Thanks, Meiping ![581566370e297.jpg](serve/attachment&path=581566370e297.jpg)

Hi Adam,
Few questions when try to connect to external Clam HANA system from HANA studio.
1). after login HANA studio, i only see HDB(SHARK), don't have HDB(SYSTEM) HANA Database. Is it ok?
2). I try to add new remote source under HDB(SHARK) Porovisioning, but it complained 'Not authorized', can you pls advice what may cause this error?

Thanks,
Meiping
581566370e297.jpg

Hi meiping,

This is because of lack of authorization of the target Hana SHR instance, since the DDIC is an user of SAP system, but not a DB user of HANA

To be able to have full access of HANA you'll have to join the BI team and have your ID created by the team leader David

Or, actually you can find a way to connect to any remote databases, such as your own SQL server instance in your VM. The HANA Smart Data Access is nothing new but just a method connecting to remote databases, via JDBC or ODBC. After that you can define any HANA virtual tables pointing to external DB's tables

58162977b037f.png

>Hi Adam, >Few questions when try to connect to external Clam HANA system from HANA studio. >1). after login HANA studio, i only see HDB(SHARK), don't have HDB(SYSTEM) HANA Database. Is it ok? >2). I try to add new remote source under HDB(SHARK) Porovisioning, but it complained 'Not authorized', can you pls advice what may cause this error? >Thanks, >Meiping >![581566370e297.jpg](serve/attachment&path=581566370e297.jpg) Hi meiping, This is because of lack of authorization of the target Hana SHR instance, since the DDIC is an user of SAP system, but not a DB user of HANA To be able to have full access of HANA you'll have to join the BI team and have your ID created by the team leader David Or, actually you can find a way to connect to any remote databases, such as your own SQL server instance in your VM. The HANA Smart Data Access is nothing new but just a method connecting to remote databases, via JDBC or ODBC. After that you can define any HANA virtual tables pointing to external DB's tables ![58162977b037f.png](serve/attachment&path=58162977b037f.png)

Project 'Clam' founder

edited Oct 30 '16 at 5:17 pm

I try to connect to my own sql server, but still encountered authorization problem, can you pls take a look? thanks, Meiping.
5816a30b919e8.jpg
5816a3145657a.jpg

I try to connect to my own sql server, but still encountered authorization problem, can you pls take a look? thanks, Meiping. ![5816a30b919e8.jpg](serve/attachment&path=5816a30b919e8.jpg) ![5816a3145657a.jpg](serve/attachment&path=5816a3145657a.jpg)
232
views
4
replies
2
followers
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft