Tools
The SAS Jedi: SAS Management Console
SAS Management Console Connection Profiles
Working in SAS Management Console
SAS Environment Manager
Monitoring your SAS Environment
Best Practices for Monitoring
Users, Groups and SAS Environment Manager
Administration Menu
SAS Management Console or SAS Environment Manager?
SAS Deployment Manager
Update Passwords
Rebuild Web Applications / Deploy Web Applications
Remove Existing Configuration
Renew SAS Software and Update SID File in Metadata
Manage SAS File Types
Update Host Name Reference
Apply Hot Fixes
Update Existing Configuration
Change Passphrase
Locale Setup manager
Uninstalling SAS Software
SAS Web Administration Console
Summary
Introduction
Now that you have the SAS architecture under your belt, you do need some administration tools to support your SAS deployment. In this chapter, I would like to share with you the how to use the four SAS administration tools, namely the SAS Management Console, SAS Environment Manager, SAS Deployment Manager and SAS Web Administration Console. SAS Management Console is a desktop client that provides you with control for your SAS deployment to create, manage and administer metadata, such as users, groups and roles, libraries, and more. SAS Environment Manager is a web client which can also be used to create, manage and administer metadata. In addition, it is a great monitoring and reporting tool for your SAS environment. It is a great tool for checking on the health of your environment. You can use the SAS Deployment Manager to manage your environment in such a way that it enables you to – for example – update your license file, add or remove products, backup, and so on. With the SAS Web Administration Console, you can monitor which users are logged on to SAS web applications, view audit reports of logon and logoff activities, manage web-layer authorization, and more.
Why did I choose to write a chapter about SAS admin tools where we have an abundance of documentation available, covering it all? Well, I believe that every newbie needs a sense of direction, info about the value a certain SAS tool provides, and to understand the purpose of the different SAS admin tool available to you. Enjoy the fact that there is one chapter covering the SAS tools that you need versus having to read through all the documentation. In the Appendix for this chapter, you will find some good supporting resources.
Let’s get started.
The SAS Jedi: SAS Management Console
Introduction
SAS Management Console is an admin desktop client – which, as the name suggests, is a client that is for admins, and should not be installed on users’ machines (except, of course, if they handle certain admin tasks). SAS Management Console enables you to create metadata and manage your SAS environment. As it is a desktop client, it requires that every admin has it installed.
| Note: Please consider carefully whether a user needs to have SAS Management Console installed. Always keep in mind that using SAS Management Console provides access to all your assets, such as users, groups, libraries, security, and so forth.If a user has some admin tasks, for example, creating certain libraries, then make sure you have the appropriate permissions in place to protect the rest of your SAS metadata. |
SAS Management Console consists of plug-ins, each of which has a different task. You have a User Manager plug-in to create users, groups and roles, a Library Manager to create libraries and register tables, and so forth.
The SAS Management Console plug-ins are:
Table 3.1 SAS Management Console plug-ins
| Plug-in Name | Plug-in Description |
| Authorization Manager | Define and maintain access rules to control how users and groups can access metadata definitions. |
| BI Lineage | Identify connections between BI objects in the SAS Folders tree. |
| Configuration Manager | View and modify configuration attributes for SAS applications including SAS Information Delivery Portal, SAS Web Report Studio, SAS Financial Management, and SAS Strategic Performance Management. |
| Data Library Manager | Create and maintain definitions for SAS libraries and database schemas. |
| Foundation Services Manager | View and modify deployment configurations for infrastructure and extension services that are used by applications such as SAS Information Delivery Portal, SAS BI Dashboard, and SAS Web Report Studio |
| Map Service Manager | Create and maintain map service definitions that link cubes to Esri ArcGIS map services so that Esri Geographic Information System (GIS) spatial map information can be accessed and returned by an OLAP server when the cubes are queried. |
| Metadata Manager | Perform administration tasks related to the SAS Metadata Server, including the following:stop, pause, resume, or reset the metadata servercheck the status of the metadata server and the metadata repositoriescreate and manage metadata repositoriesback up or restore your metadata repositoriesanalyze and repair metadata |
| Publishing Framework | Create and maintain definitions for channels, package subscribers, group subscribers, and event subscribers. |
| Schedule Manager | Create and maintain schedules for running jobs that are created in SAS Data Integration Studio and SAS Web Report Studio. |
| Server Manager | Perform administration tasks related to SAS servers, including the following:check the status of servers and validate them to ensure that they are configured correctlystop, pause, quiesce, resume, or refresh the SAS object spawner or the SAS/CONNECT spawner, and stop, pause, resume, or quiesce a process on a SAS OLAP Server, SAS Workspace Server, or SAS Stored Process Serverconnect to the metadata server, to components of SAS Application Servers, to the SAS object spawner, or to the SAS/CONNECT spawner to perform monitoring activities |
| User Manager | Create and maintain definitions for users, groups, and roles. |
SAS Management Console Connection Profiles
