search:
Search support.sas.com
KNOWLEDGE BASE
System Requirements
Install Center
Product Documentation
Papers
Samples & SAS Notes
Focus Areas
SUPPORT
License Assistance
Administrator Services
Downloads & Hot Fixes
LEARNING CENTER
Bookstore
Training
Certification
SAS Learning Edition
Higher Education Resources
SAS OnDemand For Academics
COMMUNITY
User Groups
Events
E-Newsletters
Advanced Search
support.sas.com
KNOWLEDGE BASE
SUPPORT
LEARNING CENTER
COMMUNITY
Product Documentation
>
SAS 9.2 Documentation
Print
|
E-mail
|
Bookmark
|
Feedback
SAS(R) 9.2 Intelligence Platform: Data Administration Guide
PDF
|
Purchase
Contents
About
What's New in Data Administration for the SAS 9.2 Intelligence Platform
Overview of Common Data Sources
Overview
Accessibility Features in the SAS Intelligence Platform Products
SAS Data Sets
Shared Access to SAS Data Sets
Local and Remote Access to Data
External Files
XML Data
Message Queues
Relational Database Sources
Scalable Performance Data Server and Scalable Performance Data Engine
ERP and CRM Systems
Change Data Capture
DataFlux Integration Server and SAS Data Quality Server
Connecting to Common Data Sources
Overview of Connecting to Common Data Sources
Overview of SAS/ACCESS Connections to RDBMS
Establishing Connectivity to a Library of SAS Data Sets
Establishing Shared Access to SAS Data Sets
Establishing Connectivity to a Composite Information Server
Establishing Connectivity to an Excel File
Establishing Connectivity to a Flat File
Establishing Connectivity to XML Data
Establishing Connectivity to a SAS Information Map
Establishing Connectivity to an Oracle Database
Establishing Connectivity to an Oracle Database by Using ODBC
Establishing Connectivity to a Microsoft Access Database by Using ODBC
Establishing Connectivity to a Scalable Performance Data Server
Establishing Connectivity to an SAP Server
Registering and Verifying Tables
Read-only Access for Reporting Libraries
Setting UNIX Environment Variables for SAS/ACCESS
Troubleshooting SAS/ACCESS Connections to RDBMS
Assigning Libraries
Overview of Assigning Libraries
Using Libraries That Are Not Pre-assigned
Pre-assigning Libraries Using Engines Other Than the Metadata Engine
Pre-assigning Libraries to Use the Metadata Engine
Verifying Pre-assignments by Reviewing the Logs
Managing Table Metadata
Overview of Managing Table Metadata
Creating Table Metadata for a New Library
Assessing Potential Changes in Advance
Updating Your Table Metadata to Match Data in Your Physical Tables
Optimizing Data Storage
Overview of Optimizing Data Storage
Compressing Data
Indexing Data
Sorting Data
Buffering Data for Base SAS Tables
Buffering Data for DB2 (UNIX and PC), ODBC, OLE DB, Oracle, SQL Server, and Sybase Tables
Using Threaded Reads
Validating SPD Engine Hardware Configuration
Setting LIBNAME Options That Affect Performance of SAS Tables
Setting LIBNAME Options That Affect Performance of SAS/ACCESS Databases
Setting LIBNAME Options That Affect Performance of SPD Engine Tables
Grid Computing Data Considerations
Application Response Monitoring
Managing OLAP Cube Data
Introduction to Managing OLAP Cube Data
Data Storage and Access
Exporting and Importing Cubes
About OLAP Schemas
Create or Assign an OLAP Schema
Building a Cube
Making Detail Data Available to a Cube for Drill-Through
Making Detail Data Available to an OLAP Server for Drill-Through
Making Detail Data Available to an Information Map for Drill-Through
Display Detail Data for a Large Cube
Recommended Reading
Glossary
Index here
Product
Release
SAS Data Surveyor Composite Server
4.6
DataFlux Integration Server
8.1
Scalable Performance Data Server
4.5
SAS OLAP Cube Studio
4.2
Type
Administration and Configuration
Copyright Date
February 2009
Last Updated
27Mar2009
SAS 9.2 Intelligence Platform: Data Administration Guide
