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: 170
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
Monday
Regular Contributor
Posts: 170

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

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: 170

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

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,141

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

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
Monday
Regular Contributor
Posts: 170

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

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
  • 229 views
  • 0 likes
  • 2 in conversation