Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA User Authentication from Database

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 16
Accepted Solution

SAS VA User Authentication from Database

Hi Community,

 

I've all the users stored in the Database

How to Authenticate SAS VA Users with respect to users stored in Database?

How to Filter data based on the Logged In user?

 

Regards,

SASExplorer


Accepted Solutions
Solution
‎06-22-2017 07:55 AM
Regular Contributor
Posts: 191

Re: SAS VA User Authentication from Database

Posted in reply to SASExplorer

Hi!

As SASKiwi says you can import users from external sources, you have to transform data into a sepecific database format (canonical tables), see:

https://support.sas.com/rnd/papers/sgf07/sgf2007-syncmetadata.pdf
http://support.sas.com/documentation/cdl/en/bisecag/69827/HTML/default/viewer.htm#p1ar98lajfgm4jn1wa...

 

In VA you can filter data on groups or identities, this is a good start:

https://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

 

Good luck!

View solution in original post


All Replies
Super User
Posts: 3,260

Re: SAS VA User Authentication from Database

Posted in reply to SASExplorer

"I've all the users stored in the Database" - what database is that? SAS VA authenticates against users stored in SAS metadata. Each user will normally have an OS user account stored with it.

 

I'm not aware of any way you can automatically filter data based on the logged in user.   

Occasional Contributor
Posts: 16

Re: SAS VA User Authentication from Database

Hi @SASKiwi,

Users are stored in an external database i.e., PostgreSQL.

 

Is there any way to allow the Users stored in the Database for Authentication?

Once the Authentication is Successful, it should allow access SAS VA for that user.

Super User
Posts: 3,260

Re: SAS VA User Authentication from Database

Posted in reply to SASExplorer

Users have to be authenticated in the SAS metadata server. A common practice is to import user definitions into SAS metadata - for example OS AD accounts under Windows - via a daily synchronisation job. This is just a SAS program which can read the security data. I guess it is possible to also read user data in from another database, but you would have to make sure the user credentials match what is stored in the OS.  

Solution
‎06-22-2017 07:55 AM
Regular Contributor
Posts: 191

Re: SAS VA User Authentication from Database

Posted in reply to SASExplorer

Hi!

As SASKiwi says you can import users from external sources, you have to transform data into a sepecific database format (canonical tables), see:

https://support.sas.com/rnd/papers/sgf07/sgf2007-syncmetadata.pdf
http://support.sas.com/documentation/cdl/en/bisecag/69827/HTML/default/viewer.htm#p1ar98lajfgm4jn1wa...

 

In VA you can filter data on groups or identities, this is a good start:

https://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

 

Good luck!

Occasional Contributor
Posts: 16

Re: SAS VA User Authentication from Database

How to implement SSO when the users are stored in Database?

 

I've checked with SAML Shibboleth, but AD FS is Propritery.

Is there any other open source alternative by which I can implement SSO with my Portal and access SAS VA inside it?

 

Thank You

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 5 replies
  • 205 views
  • 0 likes
  • 3 in conversation