Architecting, installing and maintaining your SAS environment

DataFlux Data Management Studio can't see Data Management Servers in metadata

Accepted Solution Solved
Reply
Regular Contributor
Posts: 174
Accepted Solution

DataFlux Data Management Studio can't see Data Management Servers in metadata

Hello all!  We recently got a trial license for Data Administration suite of tools.  I'm new to this suite of tools (DataFlux Data Management Studio and DI Studio), but am slowly figuring them out.

 

One thing I've noticed so far when testing Data Management Studio is that when I'm logged in as a typical user I cannot see the Data Management Data Server on the "Data Management Servers" riser.  However, if I log in as the admin account (sasadm@saspw) I can then see it.

 

If I look at the authorization tab for the server objects all those in SASUSERS group has RM privileges, so I'm not sure why I can't see them when logged in as regular user.  

 

For refence, see the attached screenshots.AdminUserView.pngRegularUserView.png

 

Thanks!


Accepted Solutions
Solution
‎08-14-2017 12:39 PM
Regular Contributor
Posts: 174

Re: DataFlux Data Management Studio can't see Data Management Servers in metadata

Posted in reply to JuanS_OCS
I figured this out with TS's help. It looks like when you log in to DM Studio and authenticate to the metadata server it doesn't pass on the typed user ID to the host authentication provide (in our case it's PAM), but rather uses the value that is stored in metadata as the user's external account ID. In our case, all users are entered into LDAP in lowercase (which is how I type it into applications) but the external ID in metadata was all upper case, so it wasn't recognizing the ID being passed on for authentication. I could change the external account to all lowercase in metadata and then it worked fine. A strange quirk of DM studio.

View solution in original post


All Replies
Regular Contributor
Posts: 174

Re: DataFlux Data Management Studio can't see Data Management Servers in metadata

Posted in reply to JuanS_OCS
Yea, I've been digging through the documentation and haven't found anything that works yet. It would seem that since I'm authenticating with the metadata server that it's a metadata permissions issue, but I'm sure there's some other piece of this that I'm missing. Thank you!
Trusted Advisor
Posts: 1,326

Re: DataFlux Data Management Studio can't see Data Management Servers in metadata

Posted in reply to Timmy2383

Indeed, in your case, metadata permissions is part of it, and you need to ensure also that the Data Management Server has permissions as well.

 

Problem is that, unless you have a Consultant connected to your system, it is not easy to support you on this question. It is required to check and validate each component and authorizations.

 

If you do not manage to make it work in short term, perhaps it would be an idea to involve SAS Technical Support or SAS Consulting Services.

Solution
‎08-14-2017 12:39 PM
Regular Contributor
Posts: 174

Re: DataFlux Data Management Studio can't see Data Management Servers in metadata

Posted in reply to JuanS_OCS
I figured this out with TS's help. It looks like when you log in to DM Studio and authenticate to the metadata server it doesn't pass on the typed user ID to the host authentication provide (in our case it's PAM), but rather uses the value that is stored in metadata as the user's external account ID. In our case, all users are entered into LDAP in lowercase (which is how I type it into applications) but the external ID in metadata was all upper case, so it wasn't recognizing the ID being passed on for authentication. I could change the external account to all lowercase in metadata and then it worked fine. A strange quirk of DM studio.
☑ This topic is solved.

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

Discussion stats
  • 4 replies
  • 268 views
  • 0 likes
  • 2 in conversation