SAS® Platform Administration Fast Track

Description

This workshop is for System Managers and Administrators who will be supporting the use of SAS within their organisation on Windows, UNIX or mainframe platforms.

Prerequisite Skills

You should understand the file structure of your operating system and the systems used to store and share data within your organisation.

SAS Modules Used

Management Console is used extensively.
Other components which are covered in overview include Enterprise Guide, Data Integration Studio, Information Map Studio, Web Report Studio and the SAS Portal

Course Topics

Introduction to the SAS Intelligence Platform Architecture

• SAS Intelligence Platform Overview
• SAS Intelligence Architecture Overview
• Overview of the Server Tier
• SAS Metadata Server
• SAS Workspace Server
• SAS Stored Process Server
• SAS Foundation
• SAS OLAP Server
• Platform Suite for SAS

Overview of the Data Tier

• Introduction to the Data Tier
• Scalable Performance Data Files
• SAS Data Sets
• SAS OLAP Cubes
• RDBMS Tables
• ERP Structures and Other Data Sources

Overview of the Web Tier

• Introduction to the Web Tier
• SAS Web Applications and Java
• WebDAV

Overview of the Client Tier

• Introduction to the Client Tier
• Java Applications
• .NET Applications

Overview of the SAS Management Console

• Introduction to the SAS Management Console
• Introduction to the SAS Management Console Plug-Ins
• Working with the User Interface

Metadata Manager Plug-In

• Introduction to the Metadata Manager Plug-In
• Managing Metadata Servers
• Managing Metadata Repositories

BI Manager Plug-In

• Introduction to the BI Manager Plug-In
• Exploring the BI Manager Plug-In
• Managing Stored Process Metadata
• Managing Report Metadata
• Promoting Metadata

Introduction to Accessing Data via the SASŪ9 Intelligence Platform

• Overview of the Data Sources Accessible by the SASŪ9 Intelligence Platform
• How the SASŪ9 Intelligence Platform Accesses Data
• Connecting to SAS Data
• Overview of Connecting to Data
• Defining SAS Libraries in the Metadata
• Importing Table Metadata
• Updating Table Metadata

Connecting to RDBMS Data

• The Parts That Make It Work
• Database Connection Information
• The Database Client (Optional)
• Connecting to a Database via SAS Foundation
• Creating an RDBMS Library in Metadata

Using the Metadata LIBNAME Engine

• Introduction to the Metadata LIBNAME Engine
• Using the Metadata LIBNAME Engine

Pre-Assigning Libraries

• Introduction to Pre-Assigned Libraries
• Pre-Assigning Libraries without the Metadata LIBNAME Engine
• Pre-Assigning Libraries Using the Metadata LIBNAME Engine

Introduction to Security

• Introduction to the Basic Tenets of Security
• Introduction to Security in the SASŪ9 Intelligence Platform
• Initial Authentication
• Introduction to Authentication
• Initial Authentication
• Authentication Providers

Identification

• The Identification Process
• Metadata Identities and Groups
• Special Metadata Identities and Groups
• Creating Additional Metadata Identities and Groups

Additional Authentication

• Introduction to Additional Authentication
• Cached Credentials
• Retrieving Credentials from the Metadata
• Prompting

Authorization

• Introduction to Authorization
• Elements of an Authorization Decision
• How an Authorization Decision Is Made

Securing Metadata Objects

• Introduction to Metadata Permissions
• Securing Libraries and Tables
• Securing OLAP Cubes
• Securing Stored Processes
• Securing Information Maps
• Securing Reports
• Securing Servers
• Securing Metadata Identities

Developing a Security Plan

• General Guidelines for Developing a Security Plan
• Creating Additional Metadata Identities
• Repository ACT Settings
• Securing Root Folders
• Securing Root Folders for SAS Web Report Studio (Optional)
• Securing Root Folders for SAS Information Delivery Portal (Optional)
• Securing Root Folders for Other SAS Applications (Optional)
• Creating and Implementing a Security Plan

Additional items

• Connecting to IBM DB2 Data
• SAS Applications and Business Intelligence Objects
• Metadata for Authentication