Suppose that you are using SAS
Data Integration Studio to process a large amount of data that resides
on a machine different from the workspace server to which the application
submits its code, as shown in the following figure.
One way to execute such
a job efficiently is to define two application servers. One is the
default application server for SAS Data Integration Studio and contains
the workspace server to which the application submits its generated
code. The other application server contains a
SAS/CONNECT server (which
is collocated with the data), and the library of data to be processed
is assigned to this application server. See the following figure.
If you choose for the
transformations in the job to be executed on the remote host, then
SAS Data Integration Studio generates the code that is necessary for
the transformations to be executed by the
SAS/CONNECT server. The
overall job is submitted to the workspace server. However, the workspace
server then submits the code for each transformation to the remote
server.
The generation of this
type of code is made possible by the definitions of the two application
servers, one of which is the default application server for SAS Data
Integration Studio and the other the application server to which the
data library is assigned.