Databases Reference
In-Depth Information
Table 6.2 Main Servers for the Example Data Warehouse
Software
Required in Order to Perform
These Tasks
Where Metadata Is Specified
SAS Metadata Server
Read and write metadata in a SAS
Metadata Repository.
Specified in the metadata profiles
for administrators and users.
Administrators should see
“Creating a Metadata Profile (for
Administrators)” on page 58. Users
should see “Creating a Metadata
Profile (for Users)” on page 94.
SAS Workspace Server
Access data and execute SAS code.
Can be specified as one component
of the default SAS application
server for SAS Data Integration
Studio. See “Default SAS
Application Server” on page 57.
SAS OLAP Server
Create cubes and process queries
against cubes.
Can be specified as one component
of the default SAS application
server for SAS Data Integration
Studio.
For details about entering metadata for the SAS Data Quality Servers or job
scheduling servers from Platform Computing, see the appropriate sections in the SAS
Data Integration Studio chapter in the SAS Intelligence Platform: Administration
Guide .
For details about entering metadata for a SAS/SHARE server, a SAS Scalable
Performance Data (SPD) Server, a DBMS, or an enterprise application, see the
multi-tier environment section in SAS Data Integration Studio chapter and the
Connecting to Common Data Sources chapter in the SAS Intelligence Platform:
Administration Guide .
Default SAS Application Server
SAS Data Integration Studio enables users to select a default SAS application server.
The default SAS application server enables SAS Data Integration Studio to execute
SAS code, to access data, and to perform other tasks that require a SAS
server—without having to specify a server each time.
When you select a default SAS application server, you are actually selecting a
metadata object that can provide access to several servers, libraries, schemas,
directories, and other resources. Typically, a metadata administrator defines the
metadata for a SAS application server and tells users which object to select as the
default in SAS Data Integration Studio.
For the example data warehouse, assume the metadata object for the default SAS
application server is named SASMain. To support the example data warehouse,
SASMain must include the following components:
￿ a SAS Workspace Server component
￿ a SAS OLAP Server component
To enter metadata for SAS application servers, follow the instructions that are
provided by the SAS Configuration Wizard that is associated with the SAS Software
Navigator. See also the configuring your SAS servers chapter in the SAS Intelligence
Platform: Administration Guide . For more information about how the default SAS
application server affects data access, see “Supporting Multi-Tier (N-Tier)
Environments” on page 64.
 
 
Search WWH ::




Custom Search