SAS connection strings
SAS IOM Data Provider
-
Local instance of the IOM server
Provider=sas.IOMProvider;Data Source=_LOCAL_;
-
Bridge protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=2;SAS Port=1359; -
Corba protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=1;SAS Port=1359; -
Com protocol
Provider=sas.IOMProvider;Data Source=myServerName;
SAS Machine DNS Name=lambchop.unx.sas.com;SAS Protocol=0;SAS Port=1359; -
-
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; -
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; -
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; -
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; -
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; -
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; -
COM with host authentication
Provider=SAS.IOMProvider;Data Source=iom-com://workspace.example.com;
User ID=myUsername;Password=myPassword; -
Bridge with Integrated Windows Authentication (IWA)
Provider=SAS.IOMProvider;Data Source="iom://workspace.example.com:8591;Bridge;
SECURITYPACKAGE=Negotiate"; -
COM with Integrated Windows Authentication (IWA)
Provider=SAS.IOMProvider;Data Source="iom://workspace.example.com;COM;
SECURITYPACKAGE=Negotiate"; -
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; -
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"; -
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;
↯ Problems connecting?
Get answer in the SAS Q & A forum
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; -
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;
-
Com protocol using the "Data Source URI Format"
Provider=sas.OLAPProvider;Data Source=iom-com://example.com;
-
Extract name from the metadata server using the "Data Source URI Format"
Provider=sas.OLAPProvider;Data Source=iom-name://My Logical Name;
-
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"; -
Reuse existing connection using the "Data Source URI Format"
Provider=sas.OLAPProvider;Data Source=iom-id://myWorkspaceUniqueIdentifier;
-
Bridge protocol with host authentication
Provider=sas.OLAPProvider;Data Source=iom-bridge://olap.example.com:8591;
User ID=myUsername;Password=myPassword; -
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"; -
Com protocol with Integrated Windows Authentication (IWA) using the "Data Source URI Format"
Provider=sas.OLAPProvider;Data Source="iom://example.com;COM;
SECURITYPACKAGE=Negotiate";
SAS/SHARE Data Provider
-
Using Server ID
Provider=sas.ShareProvider;Data Source=shr1;
-
Using Server ID and node (network name)
Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
-
Specifying user and password
Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
User ID=myUsername;Password=myPassword; -
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; -
Specify a server version
Provider=sas.ShareProvider;Data Source=shr1;Location=lambchop.unx.sas.com;
SAS Server Release=7;
Connect
Articlesread all »
- Formating Rules for Connection Strings
- Connection Strings Explained
- Store Connection String in Web.config
- Connection Pooling
- The Provider Keyword, ProgID, Versioning and COM CLSID Explained
- SQL Server Data Types Reference
- Network Protocol for SQL Server Connection
- All SQL Server SqlConnection Properties
- When to use the SQL Native Client
- Open a password-protected Excel workbook
Didn't find your connection string?
Start over from the connection string reference index - or try a search!
In the Q&A forums you can ask your own question and let somebody help you.
The knowledge articles contains solutions and guides.
The value of "_LOCAL_" is a keyword that indicates that a local instance of the IOM servers should be used.