topic Re: Using SAP HANA connector - security in Administration and Deployment

Using SAP HANA connector - security

Filipvdr — Thu, 05 Sep 2019 09:50:26 GMT

Hello,

I was looking into some documentation about the SAP HANA connector but i couldn't find any answers to my question:

We have an active group of SAS eguide users (75 users) in our company, spreaded out over different departments. (to keep it simple: A , B and C all have 25 users).

Is it possible to set up the connection to SAP HANA so they can only read their data? And is it possible to set up they can only write to the schemes they are able to write to in SAP HANA? Is there any documentation available you can point me to?

Filip

Re: Using SAP HANA connector - security

alexal — Fri, 06 Sep 2019 12:18:12 GMT

@Filipvdr ,

Yes, you can install and configure SAS/ACCESS Interface to SAP HANA, but you have to control authorization level of your users on the SAS HANA server itself.

Re: Using SAP HANA connector - security

Filipvdr — Fri, 06 Sep 2019 12:18:00 GMT

so each enterprise guide user has to make a libname connection to hana using his own user and password?

Re: Using SAP HANA connector - security

alexal — Fri, 06 Sep 2019 12:18:45 GMT

@Filipvdr ,

That's correct.

Re: Using SAP HANA connector - security

alexal — Tue, 10 Sep 2019 15:55:10 GMT

On this page, I described how to do that in SAS Viya: How to configure SAS/ACCESS Interface to SAP HANA on SAS Viya?

Re: Using SAP HANA connector - security

Filipvdr — Fri, 06 Sep 2019 12:24:27 GMT

we're (actually SAS is coming) installing new servers 9.4M6 next week, and we will be testing out the hana connector. will we need to do something similar or will it be ready to use?

Re: Using SAP HANA connector - security

alexal — Fri, 06 Sep 2019 12:32:07 GMT

@Filipvdr ,

Similar. Please make sure that your license contains SAS/ACCESS Interface to SAP HANA and follow configuration instructions from page 68: Configuration Guide for SAS® 9.4 Foundation for UNIX Environments

Re: Using SAP HANA connector - security

Filipvdr — Fri, 06 Sep 2019 12:36:01 GMT

yes we got a trial license for 90 days to see if the SAS/ACCESS interface is sufficient for the things we want to achieve! thanks for the tips!

Re: Using SAP HANA connector - security

alexal — Fri, 06 Sep 2019 12:37:26 GMT

@Filipvdr ,

Sure, not a problem. Let me know if you need anything else.

Re: Using SAP HANA connector - security

Filipvdr — Mon, 07 Oct 2019 07:55:18 GMT

i'm testing out the connector and i manage to acces the hana database, though i can't see all the tables... all objects with "/BIC/" i'm not able to see.. probably because of the slashes.. any idea?

Re: Using SAP HANA connector - security

Filipvdr — Mon, 07 Oct 2019 08:03:26 GMT

PRESERVE_TAB_NAMES=YES would do the trick