Skip to content

platformadmin.com

Paul Homes blogging on SASĀ® platform administration topics

  • Home
  • Reading List
  • About / Contact
  • RSS Feed
  • LinkedIn
  • GitHub
  • LinkedIn (Metacoda)
  • YouTube (Metacoda)
platformadmin.com

Tag: Metadata Promotion

Farewell to the SAS 9.2 Replication Wizard

It looks like the SAS® 9.2 Replication Wizard has recently been deprecated. I spotted a new SAS usage note about it the other day: Usage Note 40834: The Replication Wizard in SASĀ® 9.2 has been deprecated.

The Replication Wizard is, or perhaps I should now say was, a feature available in the SAS 9.2 Management Console (via Metadata Manager > Metadata Utilities > Replication) that could be used to completely replicate metadata from a source environment into a target environment (such as Development to Test , Lev3 to Lev2 etc). The alternative to replication is to promote selected subsets of metadata using the import/export wizards and SAS package (.SPK) files. This selective promotion method is sometimes known as partial promotion. Although replication might sound tempting initially, in practice the import/export methods are much more versatile (as long as they support the metadata you want to promote – significant improvements with SAS 9.2).

Unlike import/export where you promote a subset of metadata, with replication you were promoting all of the metadata in one hit (with optional substitution of things like host names, ports, paths etc), completely discarding any existing metadata in the target environment. You had to configure a fair bit of infrastructure in order to use replication, perform a few manual steps and then manually promote any associated physical (non-metadata) content. It seemed like a lot of work (and knowledge) for something you would probably only ever use once or twice (if ever), so I think it’s understandable why SAS Institute would retire this feature. I don’t imagine it got used enough to warrant continued development and testing. I suspect that most people used import/export (partial) promotion almost exclusively, even for the initial promotion into a newly installed environment.

I was always a little bit worried with replication that someone might accidentally get the 2 environments reversed and totally wipe out their source environment, overwriting it with metadata from their old or empty target environment! Another good reason to backup both environments before replicating :)

One of the benefits to replication was that it allowed you to promote portal pages (which are not currently supported with import/export as far as I know). Although it sounds like a good reason to use replication, you could only ever realistically use it once due to the all-or-nothing nature of replication. After the first replication any portal changes in the target environment (e.g. Production/Lev1) would be lost on subsequent replications. I had heard a rumour that promotion of portal pages was in the pipeline but haven’t heard anything more since. Does anyone reading this know what the current status of support for portal promotion is?

I personally hope that the list of supported metadata objects for the import/export promotion facility is extended in future to include things like ACTs, Users, Groups, Roles, Servers and Portal Pages – things that don’t reside in folders. That would round it out very nicely I think.

Updated 30Sep2010: I just spotted some information about portal content promotion in the SAS® 9.2 Intelligence Platform: Web Application Administration Guide, Third Edition. You can find it in Chapter 20 Introduction to SAS Information Delivery Portal Administration under Main Tasks for Administering the Portal in the section named Promote Portal Content. It states (in part) “Beginning with SAS Information Delivery Portal 4.3, a content promotion tool is available. This tool consists of stand-alone batch scripts, shell scripts, and metadata extraction templates.”

Updated 08Oct2010: In this SAS Discussion Forum comment Technolero mentions that it may be possible to get an early (potentially unsupported) version of the portal content promotion tool by contacting SAS Technical Support.

Updated 16Dec2010: SAS Information Delivery Portal 4.3 was recently released and the SAS documentation updated. There is a link to documentation for the new portal promotion facilities in the post Updated SAS Admin Docs (inc Portal Promotion).

Author Paul HomesPosted on 29 September 201020 September 2024Categories Interesting SAS Usage NotesTags Metadata Migration, Metadata Promotion, SAS, SAS 9.2, SAS Information Delivery Portal, SAS Management Console, SAS Usage Notes6 Comments on Farewell to the SAS 9.2 Replication Wizard

Promoting Job Flows

I am occasionally asked whether it is possible to promote job flows between metadata repositories (e.g. DEV to TEST to PROD) using the SAS package file (SPK) import/export promotion feature. In past consulting work I have needed to promote job flows containing hundreds of jobs all interlinked with dependencies, so this is a topic close to my heart :)

In the early days of SAS 9.1.3 import/export of job flows was not supported and so the only choices availably back then were to either manually reconstruct the jobs flows in the target environment or do a full replication/promotion (what used to be called full promotion in SAS 9.1.3 is now called replication in SAS 9.2). Manually reconstructing jobs flows was a tedious and error-prone process especially with large and complicated job flows. Full replication/promotion was often not appropriate because it would overwrite the target environment completely. But that’s all history (and has been for a while) …

With SAS 9.2 there is no question about it – import and export of job flows is standard with SAS 9.2 so I will ignore it for the rest of this post and concentrate on SAS 9.1.3 instead.

Since the import/export of job flows was not initially supported in SAS 9.1.3, I occasionally talk to people who assume it’s still the case now (which is understandable). It’s great to see the smile spread across their faces when they find out it is actually possible with SAS 9.1.3 today – I remember back to how I felt when I first found out. I was faced with the prospect of manually reconstructing some awe-inspiring job flows and contacted SAS on the off-chance that someone might know a better way – which is how I was lucky enough to get to try out an early version. You can imagine how happy I was.

The ability to perform partial promotion of job flows crept relatively quietly into SAS 9.1.3 with a couple of hotfixes some time back. There is a usage note about it now too: Usage Note 31008: Hot Fixes 913SMC04 and 14JPS02 provide the capability to add job flows using partial promotion

So if you need to promote job flows between SAS 9.1.3 environments here are some pointers that you might find useful:

  • Promote the job flows using the SAS Management Console 9.1 BI Manager plug-in. Last time I tried I couldn’t export job flows from SAS Data Integration Studio 3.4 (even with the latest hotfixes at the time). I last looked many months ago though, so happy to be corrected if that has changed since.
  • Make sure the SAS Management Console 9.1 client installation you will be using (most likely your workstation) has been updated to at least the level of hotfix 913SMC04. I would tend to install the most recent SAS Management Console 9.1 hotfix 913SMC08 instead.
  • This is already in the instructions for 913SMC08, but you also need to ensure the client installation you will be using (most likely your workstation) has been updated to the level of SAS Foundation Services 1.4 hotfix 14JPS02. You might recognize SAS Foundation Services 1.4 from mid-tier installations, but it also contributes the BI Manager plug-in to SAS Management Console 9.1 client installations.
  • Using BI Manager in the source repository track down the folder containing the job flows you want to export and export them into a SAS package (SPK) file. If you can’t find the job flows try looking in the /Shared Data folder. Here is a screenshot showing job flows being exported from SAS Management Console 9.1:
  • Using BI Manager in the target repository import the job flows from the previously exported SAS package (SPK) file. Once imported you will need to re-schedule the flows.
Author Paul HomesPosted on 29 July 201020 September 2024Categories GeneralTags Metadata Promotion, SAS, SAS 9.1, SAS Management Console, Scheduling

Posts pagination

Previous page Page 1 Page 2
RSS Feed Follow me on Mastodon View my LinkedIn® profile Send me a message   Vertical separator   Visit the Metacoda web site

Metacoda - productivity through metadata visibility

Horizontal separator

Tags

  • Accounts/Logins
  • ACT
  • Active Directory
  • Base SAS
  • Best Practices
  • Blogging
  • Identity Sync
  • IWA
  • Kerberos
  • Linux
  • Logging
  • Metacoda Plug-ins
  • Metacoda Plug-ins Tip
  • Metacoda Security Plug-ins
  • Metadata API
  • Metadata Migration
  • Metadata Promotion
  • Metadata Security Testing
  • Mid-Tier
  • PAM
  • platformadmin.com
  • Roles & Capabilities
  • SAS
  • SAS 9.1
  • SAS 9.2
  • SAS 9.3
  • SAS 9.4
  • SAS Architecture
  • SAS Configuration
  • SAS Enterprise Guide
  • SAS Global Forum
  • SAS Information Delivery Portal
  • SAS Installation
  • SAS Management Console
  • SAS Metadata
  • SAS Metadata Security
  • SAS Papers
  • SAS Training
  • SAS Usage Notes
  • SAS Viya
  • SPN
  • Ubuntu
  • UNIX
  • Windows
  • Windows 2008 R2

Blog Roll [ ... and links to blog rolls]

  • [ … blogs.sas.com]
  • [ … SAS RSS Feeds]
  • NOTE: The blog of RTSL.eu
  • The SAS Dummy

Metacoda Links

  • Metacoda
  • Metacoda Security Plug-ins
  • Metacoda Support

SAS Communities

  • SAS Communities
  • Stack Overflow / SAS tag
  • Super User / SAS tag

SAS Institute Links

  • SAS
  • SAS Australia
  • SAS Customer Support

SAS User Groups

  • [ … other SAS user groups]
  • SAS Global Forum
  • SUGA

Categories

  • General
  • Guest Posts
  • Interesting SAS Usage Notes
  • Linux
  • Metacoda
  • Metacoda Custom Tasks
  • Metacoda Plug-ins
  • Metacoda Security Plug-ins
  • SAS Architecture
  • SAS Books
  • SAS Configuration
  • SAS Documentation
  • SAS Enterprise Guide
  • SAS Environment Manager
  • SAS Installation
  • SAS Management Console
  • SAS Metadata
  • SAS Metadata Security
  • SAS Open Metadata API
  • SAS Software
  • SAS Support Resources
  • SAS Training
  • SAS User Groups
  • SAS Viya
  • Solaris
  • VirtualBox
  • Windows

Archives

  • October 2023
  • September 2023
  • August 2023
  • March 2023
  • February 2023
  • March 2022
  • July 2021
  • May 2021
  • March 2021
  • October 2020
  • March 2020
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • October 2018
  • September 2018
  • August 2018
  • May 2018
  • February 2018
  • September 2017
  • August 2017
  • June 2017
  • April 2017
  • January 2017
  • July 2016
  • April 2016
  • March 2016
  • November 2015
  • September 2015
  • July 2015
  • June 2015
  • March 2015
  • February 2015
  • January 2015
  • October 2014
  • May 2014
  • March 2014
  • February 2014
  • December 2013
  • October 2013
  • September 2013
  • August 2013
  • July 2013
  • June 2013
  • May 2013
  • April 2013
  • March 2013
  • February 2013
  • January 2013
  • December 2012
  • November 2012
  • October 2012
  • August 2012
  • July 2012
  • June 2012
  • May 2012
  • April 2012
  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • November 2011
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • May 2011
  • April 2011
  • March 2011
  • February 2011
  • January 2011
  • December 2010
  • November 2010
  • October 2010
  • September 2010
  • August 2010
  • July 2010
  • June 2010
  • May 2010
  • April 2010
  • Home
  • Reading List
  • About / Contact
  • RSS Feed
  • LinkedIn
  • GitHub
  • LinkedIn (Metacoda)
  • YouTube (Metacoda)

Copyright © 2010-2025 Paul Homes. All rights reserved. | Legal Notices | Admin