SAS IOM 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