Accessing Data via the SAS Intelligence Platform

Duration: 3 half-day session CEU: 0.9

This course is for those who will be involved in administering users, servers, and applications in the SAS Intelligence architecture.

Learn how to

describe how SAS servers access data
connect to SAS data
connect to RDBMS data
assign data with the metadata LIBNAME engine
describe how and when to pre-assign libraries.

Who should attend

Anyone tasked with making data available via the SAS Intelligence Platform

Prerequisites

Before attending this course, you should

read SAS Intelligence Platform: Overview (.pdf)
attend the Technical Overview of the SAS Intelligence Platform Architecture course.

Course Contents

Introduction to Accessing Data via the SAS 9 Intelligence Platform

introduction to 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
connecting to a database via SAS Foundation
creating a 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

Appendix: Making your database data available to your users for DB2

Software Addressed

This course addresses the following software product(s): SAS Add-In for Microsoft Office, SAS Data Integration Studio, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Information Map Studio.

Course Materials

Students attend Live Web classes using a Web browser and a telephone and interact with their instructor and fellow classmates in real time. Each student receives an e-mail with instructions on how to join the class three business days before the class begins. The instructions e-mail includes a link to download the course materials, including the exercise files. Students need to download and print the course materials prior to class.

System Requirements

For Live Web, you must

review and follow the general system requirements.
complete the course exercises through our virtual lab. The virtual lab allows you to access the software used in class over the Internet, so that you do not need this software on your local machine.
run this test to connect to a virtual lab session. If firewall problems prevent you from connecting to the virtual lab, then you will not be able to participate in the course exercises. Using your organization's BI environment is not an option for completing the course exercises.

U.S. Schedule

15DEC2008 Live Web,

Check for additional and updated schedule information online at support.sas.com/courses/lwpada.html.