SAS connection strings

SAS IOM Data Provider

• Local instance of the IOM server

  Provider=sas.IOMProvider;Data Source=_LOCAL_;

  The value of "_LOCAL_" is a keyword that indicates that a local instance of the IOM servers should be used.

  • SAS IOM

• Bridge protocol

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
  • SAS IOM

• Corba protocol

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=1;SAS Port=1359;
  • SAS IOM

• Com protocol

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=0;SAS Port=1359;
  • SAS IOM

• SAS Service Name instead of port number

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=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.

  • SAS IOM

• Login required by server

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
User ID=myUser;Password=myPassword;
  • SAS IOM

• Tabular Data server type

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Server Type=1;

  This is the default setting for server type.

  • SAS IOM

• OLAP server type

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Server Type=2;
  • SAS IOM

• Establish communication with an existing workspace

  Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359;
SAS Workspace ID=myWorkspaceUniqueIdentifier;

  Connects to a unique ID that was generated by the SAS Workspace Manager.

  • SAS IOM

• Bridge with host authentication

  NOTE! These connection strings are using the "Data Source URI Format" (the "iom-bridge://xx.com:8591" style) which requires SAS version 9.2 or later!

  Provider=SAS.IOMProvider;Data Source=iom-bridge://workspace.example.com:8591;
User ID=myUsername;Password=myPassword;
  • SAS Workspace

• COM with host authentication

  Provider=SAS.IOMProvider;Data Source=iom-com://workspace.example.com;
User ID=myUsername;Password=myPassword;
  • SAS Workspace

• Bridge with Integrated Windows Authentication (IWA)

  Provider=SAS.IOMProvider;Data Source="iom://workspace.example.com:8591;Bridge;
SECURITYPACKAGE=Negotiate";

  Be careful with the extra quotation marks around the Data Source value (needed because of the semicolon used inside the value).

  • SAS Workspace

• COM with Integrated Windows Authentication (IWA)

  Provider=SAS.IOMProvider;Data Source="iom://workspace.example.com;COM;
SECURITYPACKAGE=Negotiate";

  Be careful with the extra quotation marks around the Data Source value (needed because of the semicolon used inside the value).

  • SAS Workspace

• Bridge with a logical server name defined in a SAS Metadata Server and host authentication

  Provider=SAS.IOMProvider;
Data Source=iom-name://Workspace Server - Logical Server Name;
SAS Metadata Location=iom-bridge://metadata.example.com:8561;
SAS Metadata User ID=metauserid;SAS Metadata Password=metapassword;
  • SAS Workspace

• Bridge with a logical server name defined in a SAS Metadata Server and Integrated Windows Authentication (IWA)

  Provider=SAS.IOMProvider;
Data Source=iom-name://Workspace 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).

  • SAS Workspace

• Logical server name defined in a SAS Metadata Server that is configured via the SAS Integration Technologies configuration utility

  Provider=SAS.IOMProvider;
Data Source=iom-name://Workspace Server - Logical Server 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.

  • SAS Workspace

SAS OLAP Data Provider

• Bridge protocol

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

• Corba protocol

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

• Com protocol

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

• 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.

  • SAS OLAP

• Login required by server

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

• 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.

  • SAS OLAP

• 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.

  • SAS OLAP

• 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.

  • SAS OLAP

• 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;
  • SAS OLAP

• 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;
  • SAS OLAP

• 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).

  • SAS OLAP

• Reuse existing connection using the "Data Source URI Format"

  Provider=sas.OLAPProvider;Data Source=iom-id://myWorkspaceUniqueIdentifier;
  • SAS OLAP

• Bridge protocol with host authentication

  Provider=sas.OLAPProvider;Data Source=iom-bridge://olap.example.com:8591;
User ID=myUsername;Password=myPassword;
  • SAS OLAP

• Bridge protocol with Integrated Windows Authentication (IWA) using the "Data Source URI Format"

  Provider=sas.OLAPProvider;Data Source="iom://example.com:1234;Bridge;
SECURITYPACKAGE=Negotiate";

  Be careful with the extra quotation marks around the Data Source value (needed because of the semicolon used inside the value).

  • SAS OLAP

• Com protocol with Integrated Windows Authentication (IWA) using the "Data Source URI Format"

  Provider=sas.OLAPProvider;Data Source="iom://example.com;COM;
SECURITYPACKAGE=Negotiate";

  No port number to define when using COM protocol.

  • SAS OLAP

SAS/SHARE Data Provider

• Using Server ID

  Provider=sas.ShareProvider;Data Source=shr1;
  • SAS/SHARE

• Using Server ID and node (network name)

  Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
  • SAS/SHARE

• Specifying user and password

  Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
User ID=myUsername;Password=myPassword;
  • SAS/SHARE

• Server requires a password

  Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
User ID=myUsername;Password=myPassword;
SAS Server Access Password=myServerPassword;
  • SAS/SHARE

• Specify a server version

  Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
SAS Server Release=7;

  Default if omitted, the provider uses the SAS 9.1 server access method.

  • SAS/SHARE