SAS OLAP connection strings

SAS OLAP Data Provider

Bridge protocol

Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;

Corba protocol

Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=1;SAS Port=1359;

Com protocol

Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=0;SAS Port=1359;

SAS Service Name instead of port number

Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=2;SAS Service Name=sasobjspawn;

Make sure that "SAS Port" isn't defined in the connection string as it will override the "SAS Service Name" value.

Login required by server

Provider=sas.OLAPProvider;Data Source=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;User ID=myUser;Password=myPassword;

Bridge protocol using the "Data Source URI Format"

NOTE! Using the "Data Source URI Format" requires SAS version 9.2 or later!

Provider=sas.OLAPProvider;Data Source=iom-bridge://example.com:1234;

Port number 1234 assumed in the above example string.

Com protocol using the "Data Source URI Format"

Provider=sas.OLAPProvider;Data Source=iom-com://example.com;

The com protocol does not use a port number.

Extract name from the metadata server using the "Data Source URI Format"

Provider=sas.OLAPProvider;Data Source=iom-name://My Logical Name;

Use the SAS Integration Technologies configuration utility (ITConfig) to create a configuration file that contains information about how the provider can access the metadata server.

Extract name from a metadata server defined in connection using the "Data Source URI Format"

Provider=sas.OLAPProvider;Data Source=iom-name://OLAP Server - Logical Server Name;SAS Metadata Location=iom-bridge://metadata.example.com:8561;

Extract name from the metadata server require host authentication using the "Data Source URI Format"

Provider=sas.OLAPProvider;Data Source=iom-name://OLAP Server - Logical Server Name;SAS Metadata Location=iom-bridge://metadata.example.com:8561;SAS Metadata User ID=myUsername;
SAS Metadata Password=myPassword;

Extract name from the metadata server require IWA (Integrated Windows Authentication) using the "Data Source URI Format"

Provider=SAS.OLAPProvider;Data Source=iom-name://OLAP Server - Logical Server Name;SAS Metadata Location="iom://metadata.example.com:8561;Bridge;SECURITYPACKAGE=Negotiate";

Be careful with the extra quotation marks around the SAS Metadata Location value (needed because of the semicolon used inside the value).