The OLAPOPERATE Procedure

Connection Options

The CONNECT statement enables you to connect to a SAS OLAP Server.
CONNECT <connection options>;
The following server connection options in the OLAPOPERATE statement establish communication with a SAS OLAP Server.
HOST=
specifies the host name or network IP address of the computer hosting the SAS OLAP Server (for example, HOST=d1234.na.sas.com). The value localhost can be used if the SAS session is connecting to a server on the same computer.
PORT=
specifies the TCP port to which the SAS OLAP Server listens for connections (for example PORT= 5451). This option is not required if the COM protocol is specified.
Note: COM connection support was discontinued in SAS 9.3.
USERID=
specifies a user ID to be used to connect to the SAS OLAP server. The user must have Administer privileges for the OLAP Server in order to execute statements of the OLAPOPERATE procedure.
PASSWORD= | PW=
specifies the password that corresponds to the user ID.
PROTOCOL=
specifies the network protocol for communicating with the SAS OLAP Server. Valid values are COM or BRIDGE. The default value is BRIDGE. When COM is specified, then all other options are unnecessary and are ignored.
Note: COM connection support was discontinued in SAS 9.3.
SSPI
(Security Support Provider Interface) specifies that the identity of the user running the SAS session will be used to establish the connection. The USERID and PASSWORD options are unnecessary and are ignored when SSPI is specified.
Restriction:This connection option is used only when connecting to an OLAP server running on a Windows machine.
SPN=
specifies the Service Principal Name of the connection destination. This option is optional even if SSPI is specified. When SPN is not specified, one is created using the HOST= and PORT= values.
Restriction:This connection option is used only when connecting to an OLAP Server running on a Windows machine.