topic Re: Migrate Metadata from sas 903 (unix) to sas904 (Window) in Administration and Deployment

Migrate Metadata from sas 903 (unix) to sas904 (Window)

japsas100 — Wed, 01 Apr 2020 13:35:01 GMT

Dear All,

We would like to migrate the sas metadata including roles group and the user id from sas 903 (Unix) to sas904.

(Window).

One complex method is manually entered all the user and their group, roles.

Is there any best way to migrate the metadata?

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

Kurt_Bremser — Wed, 01 Apr 2020 13:37:31 GMT

You must have had a synchronization process between your authentication source (either the passwd/group files of UNIX, or a LDAP source) and SAS metadata. Implement the same process on the new platform, and you'll have your users and groups automatically.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

japsas100 — Wed, 01 Apr 2020 13:39:53 GMT

@Kurt_Bremser

Thanks for the prompt reply.

Is there we cant check the synchronization process? Please share the steps.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

Kurt_Bremser — Wed, 01 Apr 2020 13:55:35 GMT

Since using the metadata API is not that simple, I chose another approach: run the import as usual on the new platform, do a side-by-side check (eyeball Mk1) with SMC (9.3 for old, 9.4 for new) to see if there's an obvious discrepancy. Once it's confirmed there's none, let the users test the new platform, and wait for complaints. If such come, fix them. After a sufficient time, deactivate the old platform.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

japsas100 — Wed, 01 Apr 2020 13:59:32 GMT

@Kurt_Bremser

how to run the import as usual on the new platform?

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

Kurt_Bremser — Wed, 01 Apr 2020 14:03:13 GMT

@japsas100 wrote:

@Kurt_Bremser

how to run the import as usual on the new platform?

Just the way you ran it on the old. Unless there is also a change in authentication platform (like we had when we switched from UNIX-based authentication to AD as a LDAP source), then you need to modify your synchronization program.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

AnandVyas — Thu, 02 Apr 2020 02:28:19 GMT

Hi @japsas100

Any reason why not to use the promotion tools provided by SAS?

Here - https://documentation.sas.com/?docsetId=bisag&docsetTarget=p04l8c3fo8tpyhn103dps7pxvru2.htm&docsetVersion=9.4&locale=en

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

japsas100 — Thu, 02 Apr 2020 22:02:33 GMT

@AnandVyas @Kurt_Bremser

Is there any way to add multiple users into a group via SAS EG?

I have more than 5000 users to assign to the various groups. I know, manually it's very complex and changes of error are higher to assign the incorrect group.

I just google it and found PROC METADATA SERVER is a way to add the user into the group.

Can you please share the script to load the data into various groups.

Note All the users and groups already populated in the metadata and I need to just assign the correct group.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

SASKiwi — Thu, 02 Apr 2020 23:30:04 GMT

Under Windows, the easiest way is to define all of your SAS users with Windows accounts, defining which Windows AD groups each belongs to, then use the SAS AD synchronization tools to import them into SAS metadata. SAS provides the code to do this. You don't need to write your own.

Have you already set up your SAS users into Windows AD groups that mirror your SAS metadata groups? You need to do this so your OS and metadata permissions align.

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

japsas100 — Thu, 02 Apr 2020 23:37:23 GMT

Thanks @SASKiwi

Windows AD groups already sync in the metadata. we have some oracle specific users that we need to add manually.

I want to add below details like

Name | DisplayName | Email | Authorization domain under an account tab

someone posted below to add via xml

https://communities.sas.com/t5/Administration-and-Deployment/XML-Metadata-Interface-Adding-User-to-Group/m-p/441581#M12448

Could you please share the full script to load this data vis sas EG

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

SASKiwi — Fri, 03 Apr 2020 00:23:12 GMT

@japsas100 - Sorry, I don't have such a script. We don't do automated metadata loads apart from AD synchronization using the SAS-supplied tools

An alternative approach might be to look at the highly recommended Metacoda tools: www.metacoda.com .

Re: Migrate Metadata from sas 903 (unix) to sas904 (Window)

AnandVyas — Fri, 03 Apr 2020 02:58:46 GMT

I think you should involve your developer community at work to help you out here. Metadata programming could be quite complex based on the requirements at your site. Unfortunately I have very little programming background and I won't be able to assist on scripts. However once I had a similar task and I used sas available sample code that imports users in the format of /etc/passwd.

Here is the link for the details on this and it also points to the location where you can find the sample code.
https://documentation.sas.com/?docsetId=bisecag&docsetTarget=p1glo11igwrdcbn1nazawizho26e.htm&docsetVersion=9.4&locale=en

You can tweak this code as per your requirement and import bulk users into SMC. NOTE: This method is only for adding users and doesn't map them to SMC groups automatically.

Hope this helps!