Resources

• Products & Solutions
• System Requirements
• Samples
• Install Center
• Third-Party Software Reference
• Documentation
  • What's New in SAS
  • Product Index A-Z
  • SAS Viya
  • SAS 9.4
  • SAS 9.3 and Earlier
• Papers
• Focus Areas

Data Source Enhancements for Integration

Third-party applications often supply customized interfaces for entering connection properties. However, some of these interfaces allow users to specify only the Data Source property; they do not allow users to enter all of the property information that is required for a connection. To resolve this conflict, the IOM and OLAP data providers support a mechanism for including all of the required connection information by using just the Data Source property.

To use the Data Source property to specify all connection-related properties, you enter the properties as one string separated by an ampersand (&). Each delimited section is a Name=Value pair. This is similar to the way ADO connection strings are formatted. For example:

cn.Properties("Data Source") = "Location=server.example.com& SAS Port=5555&" & _
                               "SAS Protocol=2& User ID=myuserid& Password=********"
      

You also can use an abbreviated syntax in the Data Source string to specify the "SAS Protocol," "Location," and "SAS Port" properties as [protocol]://[server id]:[server port]. The prototols are:

• iom-bridge and iom-com—after the two slashes (//), specify a server IP address. For example, you could use the following Data Source string to connect to a bridge IOM Server running on the machine
  server.example.com on port 5555:
  
  

  cn.Properties("Data Source") = "iom-bridge://server.example.com:5555&" & _
                                 "User ID=myuserid& Password=********"
        

• iom-name—after the two slashes (//), specify a logical server name that can be found in the SAS Metadata Repository. The SAS Integration Technologies installation process provides a way to define where your SAS Metadata Repository is located. See the SAS Integration Technologies installation documentation for more information.
• iom-id—after the two slashes (//), specify the ID of an existing IOM Workspace Server. See Reusing an Existing IOM Workspace for more information.