It is platform designed for Business intelligence solution. It has got different parts or tiers. The metadata sits alongside these tiers and works as glue to stick all these layers together.

There are 4 different tiers; Data tier, Server tier, Client and Web tier.

All tiers can have been installed on the same machine or MIGHT be on different machines; however, it is common practise to have server tier and web tier on one machine and data tier and client tier on different machines.

Data tier – Is nothing but where the all Enterprise level data resides.

It includes SAS Datasets, OLAP cubes, SAS SPDS (Special Performance Data Server), SAS SPDE, Other RDBMS tables like oracle, ERP systems etc. Using SAS/ACCESS we can connect to external databases like Oracle; DB2 etc.

Server Tier – This includes all different types of SAS Servers. SAS Servers are similar to windows servers; which run in the background to serve the requests rose from client.

SAS servers are usually installed on different machines. Various SAS servers all listed as below;

SAS Workspace Server – The SAS Code generated by various client APPLICATIONS is sent to this server for execution. SAS Workspace server then access various datasets and libraries included in the code and executes them providing the output back to the end users. Each USER has individual process allocated on the server.

SAS Stored Process Server – This is place where all SAS Stored Process are executed. SAS stored processes are centrally stored SAS programs that can be accessed from different SAS client and web applications.

Object Spawner – Its part of Server tier which is RESPONSIBLE for START up of SAS Work space server and connect them with the Metadata Server.

SAS OLAP Server – This is used to access previously created OLAP cubes. It can read the cubes which have been created with other non-SAS applications. Process MDX queries. It is interesting to know that building the OLAP cubes is done by using SAS Workspace server while OLAP server can be used just for reading purpose.

SAS/Connect Server – It used to submit SAS code from one machine to be executed on another. Provides Remote Library Services, Data transfer services etc.

SAS/SHARE – Gives access to SAS files for multiple users at a time; and avoid connecting to the files thru different SAS/Connect remote logins.

Apart from this there are some additional SAS servers like Batch Server, Grid Server, Platform suit for SAS etc. However most important of all are SAS Workspace Server, SAS Stored Process Server, SAS OLAP server and Object Spwaner.

It is platform designed for Business intelligence solution. It has got different parts or tiers. The metadata sits alongside these tiers and works as glue to stick all these layers together.

There are 4 different tiers; Data tier, Server tier, Client and Web tier.

All tiers can have been installed on the same machine or might be on different machines; however, it is common practise to have server tier and web tier on one machine and data tier and client tier on different machines.

Data tier – Is nothing but where the all Enterprise level data resides.

It includes SAS Datasets, OLAP cubes, SAS SPDS (Special Performance Data Server), SAS SPDE, Other RDBMS tables like oracle, ERP systems etc. Using SAS/ACCESS we can connect to external databases like Oracle; DB2 etc.

Server Tier – This includes all different types of SAS Servers. SAS Servers are similar to windows servers; which run in the background to serve the requests rose from client.

SAS servers are usually installed on different machines. Various SAS servers all listed as below;

SAS Workspace Server – The SAS Code generated by various client applications is sent to this server for execution. SAS Workspace server then access various datasets and libraries included in the code and executes them providing the output back to the end users. Each user has individual process allocated on the server.

SAS Stored Process Server – This is place where all SAS Stored Process are executed. SAS stored processes are centrally stored SAS programs that can be accessed from different SAS client and web applications.

Object Spawner – Its part of Server tier which is responsible for start up of SAS Work space server and connect them with the Metadata Server.

SAS OLAP Server – This is used to access previously created OLAP cubes. It can read the cubes which have been created with other non-SAS applications. Process MDX queries. It is interesting to know that building the OLAP cubes is done by using SAS Workspace server while OLAP server can be used just for reading purpose.

SAS/Connect Server – It used to submit SAS code from one machine to be executed on another. Provides Remote Library Services, Data transfer services etc.

SAS/SHARE – Gives access to SAS files for multiple users at a time; and avoid connecting to the files thru different SAS/Connect remote logins.

Apart from this there are some additional SAS servers like Batch Server, Grid Server, Platform suit for SAS etc. However most important of all are SAS Workspace Server, SAS Stored Process Server, SAS OLAP server and Object Spwaner.