Would it be possible to remind me of a SAS9 architecture question?
Does the SAS MS addin allows the use of a STP Server instead of a SAS Workspace server? I've just reviewed a few papers issued for SUGI and other users group.Reading them let me think that this should be feasible.
It's documented that the workspace server is used with the addin for data access , SAS tasks execution and of course it can execute a stored process program.
But what about the execution of a stored process program on a stored process server? In my current organisation , I'm just only proposed the SAS Workspace servers as execution server. I find it surprising and I am wondering if my IT department configured on purpose (acces restrictions in the SMC on the STP server).Many thanks for your highlights.
If you had the SAS Add-in for Microsoft Office and NEVER used a stored process, the Metadata server would use the Workspace server to authenticate/authorize user access to data and would use the Workspace server to "serve" data for Add-in tasks.
However, if you DO use stored processes, then when you register the stored process in the metadata, you have the choice to specify either the Workspace server or the Stored Process server as the server of choice for stored process execution.
There -are- differences in the type of results that can be generated and returned to client applications using each server type. There are also authentication/authorization differences with each server. These differences are outlined in the stored process documentation and in the Platform administration documentation.
You should ask your SAS administrator for more details about your site's configuration and their reasoning behind configuration decisions.