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

Providing Connection Information for a SAS IOM or SAS OLAP Server

The Connection tab in the Data Link Properties dialog box enables you to provide connection information that is specific to the SAS IOM Data Provider or to the SAS OLAP Data Provider. The IOM and OLAP providers use your connection information to access a SAS Integrated Object Model (IOM) server that is hosting either a SAS Workspace object or a SAS OLAP Server object.

Note: An IOM Server is a SAS object server that is launched to fulfill client requests for IOM services. A SAS IOM workspace represents a single session with SAS. A SAS OLAP server provides access to multidimensional data.

Complete the following steps to enter connection information for the server that you want to access:

Note: If you enter information that is not required for the type of connection that you are establishing, your additional information is ignored.

1. In the Data Source field, enter the server location.
   • If you want a new, locally instantiated IOM server connection, then set this property to _LOCAL_ .
   • If you are creating a remote IOM server connection, then set this property to any string (except _LOCAL_) that you want to associate with the connection.
   
   Note: If your local connection does not succeed, then your system administrator must check your installation and COM permissions.
   
   Note: If you do not complete the Data Source field, the IOM Data Provider assumes that you want to establish a local connection.
   
2. If you are establishing a local connection, then you are finished entering connection information. Click OK to make the connection. Otherwise, continue with Steps 3 through 10.
3. If you are connecting to a secure remote IOM server, then enter your log in identification in the User ID field.
4. In the Password field, enter the password for the user ID that you entered.
5. If the server that you are connecting to has a name that is defined in an LDAP (Lightweight Directory Access Protocol) server, then enter that name in the SAS Logical Name field. (LDAP is a protocol that is used by applications to store and retrieve information in a network directory (an LDAP server).)
6. If you entered a name in the SAS Logical Name field, then you are done entering connection information. Click OK to make the connection. Otherwise, continue with Steps 7 through 10 for servers that are not defined in an LDAP server.
7. In the SAS Machine DNS Name field, enter the network DNS name or the IP address of the IOM server. An example of a DNS name is sasserv.us.example.com. An example of an IP address is 127.0.0.1 .
8. If you are connecting via Corba or Bridge protocol (see Step 9), in the SAS Service Name/Port field, enter either the TCP/IP port number of the remote server, or the logical reference to the port that is associated with the remote server. An example of a port number is 5991. An example of a service name is SASService. If you are using the SAS OLAP Data Provider, the default port is 5451. If you are connecting via COM protocol, then leave this field blank.
9. In the SAS Protocol drop-down list, specify how to communicate with an IOM server. Your choices are ProtocolCom (the default for the IOM provider), ProtocolCorba, or ProtocolBridge (the default for the OLAP provider).
10. Click OK to make the connection.

For additional information about completing the Connection tab, contact your system administrator.

Note to application developers: For information about how you can write an application that gathers connection information using this customized Connection tab, see Making Connections by Using the Microsoft Data Link API.