Install SAS ETL Studio and Related Software

---

Use the SAS Software Navigator to install SAS ETL Studio and related software. For an overview of installation and setup, see the SAS ETL Studio chapter in the SAS Intelligence Platform: Planning and Administration Guide.

Your data warehouse project plan should identify the SAS software that is required for your data warehouse. For example, to answer the business questions that are described in Chapter 4, "Example Data Warehouse," on page 27, the software that is listed in the following table must be installed.

Note

The data sources and targets for the example warehouse are assumed to be local, and all are assumed to be in Base SAS format or in comma-delimited format.

Additional software would be required to access data that is under the control of SAS/ SHARE, a SAS Scalable Performance Data (SPD) Server, a data base management system (DBMS), or an enterprise application.

Required Servers

As a client, SAS ETL Studio must connect to a SAS Metadata Server to read or write metadata. It must connect to other servers to run SAS code, to connect to a third-party database management system, or to perform other tasks. Your data warehouse project plan should identify the servers that are required for your data warehouse. Table 5.1 on page 39 lists the minimum servers that must be installed to create the example data warehouse.

Table 5.1: Software Required to Create the Example Data Warehouse

Software	Required in Order to Perform These Tasks
SAS Management Console	Administer SAS software.
SAS ETL Studio	Build and maintain ETL process flows.
SAS Metadata Server	Read and write metadata in a SAS Metadata Repository.
SAS Workspace Server	Access data and execute SAS code.
SAS OLAP Server	Create cubes and process queries against cubes.

SAS/CONNECT Server

SAS ETL Studio uses a SAS/CONNECT server to submit generated SAS code to machines that are remote from the default SAS application server. A SAS/CONNECT server can also be used for interactive access to remote libraries. If your work in SAS ETL Studio requires either of these services, you should install SAS/CONNECT software. All of the data in the example data warehouse is assumed to be local, so SAS/CONNECT is not required.

---