|Architecture of the SAS Intelligence Platform|
The SAS Intelligence Platform architecture is designed to efficiently access large amounts of data, while simultaneously providing timely intelligence to a large number of users. The platform uses an n-tier architecture that enables you to distribute functionality across computer resources, so that each type of work is performed by the resources that are best suited to the job.
You can easily scale the architecture to meet the demands of your workload. For a large company, the tiers can be installed across a multitude of machines with different operating systems. For prototyping, demonstrations, or very small enterprises, all of the tiers can be installed on a single machine.
The architecture consists of the following four tiers:
Data sources store your enterprise data. All of your existing data assets can be used, whether your data is stored in third-party database management systems, SAS tables, or ERP system tables.
SAS servers perform SAS processing on your enterprise data. Several types of SAS servers are available to handle different workload types and processing intensities. The software distributes processing loads among server resources so that multiple client requests for information can be met without delay.
The middle tier enables users to access intelligence data and functionality via a Web browser. This tier provides Web-based interfaces for report creation and information distribution, while passing analysis and processing requests to the SAS servers.
The client tier provides users with desktop access to intelligence data and functionality through easy-to-use interfaces. For most information consumers, reporting and analysis tasks can be performed with just a Web browser. For more advanced design and analysis tasks, SAS client software is installed on users' desktops.
Note: The four tiers listed above represent categories of software that perform similar types of computing tasks and require similar types of resources. The tiers do not necessarily represent separate computers or groups of computers.
The following diagram shows how the tiers interact, and the sections that follow describe each tier in more detail.
Architecture of the SAS Intelligence Platform
The SAS Intelligence Platform includes the following options for data storage:
SAS data sets, which are analogous to relational database tables
SAS SPD Engine tables, which can be read or written by multiple threads
SAS SPD Server, which is available as a separate product
SAS OLAP cubes
In addition, SAS provides products that enable you to access data in your existing third-party DBMSs and ERP systems. The SAS/ACCESS interfaces provide direct access to DBMSs such as the following:
Microsoft SQL Server
The following SAS Data Surveyor products provide direct access to ERP systems:
SAS Data Surveyor for SAP enables you to consolidate and manage enterprise data from various SAP R/3 data sources.
SAS Data Surveyor for Composite-Accessed Data Sources enables you to use SAS with Composite Software to access and manipulate Oracle applications, PeopleSoft, Salesforce.com, and Siebel enterprise metadata.