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.