Accessing Data via the SAS Intelligence Platform

Classroom duration: 2.0 days Live Web duration: 3 half-day sessions Please note the System Requirements below. Course fee: $1,088 EPTO units: 2.2 CEUs: 1.2

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

Expand/Collapse All Expand All Collapse All Print version

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

This course addresses SAS Add-In for Microsoft Office, SAS Data Integration Studio, SAS Enterprise Guide, SAS Information Delivery Portal, SAS Information Map Studio.

Course Materials

Classroom: Students attend classroom courses in one of our public training centers. You receive a hardcopy of the course notes and, in some courses, can choose to take home a copy of the course data.

Live Web: 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. 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.

Share Your Thoughts

Not sure if this course suits your needs or which delivery method is right for you? Give us a call at 800-333-7660 or send us e-mail. If you have suggestions for this course or would like for it to be offered at another training facility, let us know by adding to our Interest List.

This page was created using SAS software.

Learning Center

Stay in Touch

Not sure what course to take?

Submit Your Course Requests

On-site Pricing