topic Re: DataFlux Data Management Studio can't see Data Management Servers in metadata in Administration and Deployment

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

Timmy2383 — Fri, 28 Jul 2017 20:19:32 GMT

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.

Thanks!

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

JuanS_OCS — Thu, 03 Aug 2017 12:28:56 GMT

Hello @Timmy2383,

please give a look into this documentation, perhaps it can help:

http://support.sas.com/software/products/dfdmstudioserver/#s1=2

http://support.sas.com/documentation/cdl/en/dmpdmsrvag/68260/HTML/default/viewer.htm#p1h6cuatyqm9kqn1rx5t3k4suau7.htm

http://support.sas.com/documentation/cdl/en/dmpdmsrvag/68260/HTML/default/viewer.htm#n0jk8ge485f094n112mpr4mi0v3f.htm

http://support.sas.com/documentation/cdl/en/dmpdmsicg/68221/HTML/default/viewer.htm#p0e4ih8iz0c84qn1kcqf8snf0n26.htm

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

Timmy2383 — Thu, 03 Aug 2017 18:55:35 GMT

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!

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

JuanS_OCS — Fri, 04 Aug 2017 08:34:36 GMT

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.

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

Timmy2383 — Mon, 14 Aug 2017 16:37:59 GMT

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.