• 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


ProductRelease
SAS Enterprise BI Server4.2
SAS BI Server4.2
SAS Data Surveyor Composite Server4.6
DataFlux Integration Server8.1
SAS Enterprise Data Integration Server4.2
SAS Data Integration Server4.2
SAS OLAP Cube Studio4.2
Type
Administration
Copyright Date
February 2009
Last Updated
27Mar2009