The
SPD Server SQL proxy plans and executes SQL queries from SAS PROC SQL for implicit or explicit
SQL statements. The
SASSPDS engine can respond in two ways. The SASSPDS engine can request that the SPD Server
host create an SQL proxy, or the SASSPDS engine can use an existing user proxy as
the SQL proxy. (The user credentials of the SQL connection must be same as the credentials
for the user proxy for this to happen.) The SASSPDS engine then sends implicit or
explicit SQL statements to the SQL proxy on behalf of PROC SQL.