Planning Your Hardware and Software

General Software Requirements

Software Required by SAS/Warehouse Administrator describes the SAS software that you must have in order to use SAS/Warehouse Administrator.

Software Required by SAS/Warehouse Administrator
Product		Purpose	Where Installed
Base SAS		Manages SAS data sets; provides many data management functions; supports other SAS products.	Administrator's workstation(s); any warehouse host or source data host that requires Base SAS functionality or SAS product support.
SAS/Warehouse Administrator		Automates data warehouse creation and maintenance.	Administrator's workstation(s).

Note: Release 2.0 of SAS/Warehouse Administrator requires Version 8.0 or later of SAS, but data sources and warehouse data stores can be managed by any currently supported release of SAS. [cautionend]

Software Required for Special Tasks lists other software that you must have if your project requires support for the tasks described in the Purpose column.

Software Required for Special Tasks
Product	Purpose	Where Installed
SAS/CONNECT	Supports connections to files, hardware resources, and SAS software on various remote hosts to use with a SAS session on a local host.	On both the local and remote hosts.
SAS/SHARE	Controls concurrent access to metadata libraries by multiple SAS/Warehouse Administrator users. Controls concurrent access to Jobs Information libraries by Jobs and SAS/Warehouse Administrator users.	Server is installed on host where the libraries to be controlled are stored. Licensed on any remote hosts that access these libraries.
SAS/ACCESS	Provides a set of individual interfaces between SAS and proprietary DBMSs.	On host(s) where DBMS data resides.
DBMS client software	Manages connections to proprietary DBMSs. Required by Version 7 and 8 SAS/ACCESS engines.	On host(s) where SAS/ACCESS LIBNAME statements are executed.
SAS/MDDB server	Creates Multidimensional databases. Required for OLAP MDDBs.	On host where OLAP MDDB is created.
SPDS	Scalable Performance Data Server creates, appends, and retrieves remote SAS tables faster than other methods.	Host(s) where remote SAS tables reside.
SAS/AF	SAS application development environment. Required to modify or write SAS/Warehouse Administrator metadata API applications. See Note below about Information Mart Items.	Metadata API development host(s). See Note below about Information Mart Items.
SAS/GRAPH	SAS graphics support. Required to modify or write add-in software that includes a GUI.	Add-in software development host(s).
Other SAS products	Exploit warehouse data.	Depends on the product.

Note: If you create any Information Mart Items, you must either install SAS/AF on the host where the Information Mart Item is located, or replace the default "open" command with a command that does not require SAS/AF software. For details, see Example: Creating an Information Mart Item. [cautionend]

Your SAS installation coordinator will help you select appropriate software for your project. The configuration sections in this chapter show some typical software configurations.

Top of Page