• Contents
  • About
  • Title Page
  • What's New in Data Administration for the SAS 9.3 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 Data Management 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 DataFlux Federation Server
    • Establishing Connectivity to a Scalable Performance Data Server
    • Establishing Connectivity to an SAP Server
    • Establishing Connectivity to Hadoop
    • 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
    • What Does It Mean to Assign a Library?
    • How Do the Different Platform Clients Assign Libraries?
    • Understanding Pre-Assigned Libraries
    • Understanding Native Engines and the Metadata LIBNAME Engine
    • Considerations for SAS Stored Process and SAS Pooled Workspace Servers
    • Pre-assigning a Library
    • 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 Server9.3
SAS BI Server9.3
SAS Enterprise Data Integration Server9.3
SAS Data Integration Server9.3
Type
Administration
Copyright Date
August 2012
Last Updated
28Aug2012