This version
of the
Advanced tab is designed specifically
for you to enter connection information when you are performing one
of these actions:
-
using the SAS IOM provider for
OLE DB to access a SAS Workspace Server
-
using the SAS OLAP provider for
OLE DB to access a SAS OLAP Server
Tip
As a best practice,
use this tab only when you must specify a SAS Metadata Server that
has not been configured by using the SAS Integration Technologies
configuration utility (ITConfig). If the metadata server that you
need to use has been configured by using ITConfig, then enter connection
information on the
Connection tab.
The customized
Advanced tab has these items:
Enter Metadata Server information
You can use this option
only if you are connecting to a SAS Workspace or SAS OLAP server that
is defined in a SAS Metadata Server that has been configured by using
ITConfig. If this configuration exists, then you should use the
Connection tab to enter the connection information.
To display that tab, click
Connection.
Use the Data Source
URI format to identify the SAS Metadata Server. For example, you might
enter this code:
iom-bridge://metadata.example.com:8561
Type your user ID for
logging on to the SAS Metadata Server.
Type the password for
the user ID that you entered.
Select or enter SAS Server information
Use the Data Source
URI format to specify the location of the SAS Workspace or SAS OLAP
server that you want to access. The URI should reference the logical
name of the workspace or OLAP server that is defined in the SAS Metadata
Server that you are using. For example, you might enter this URI.:
iom-name://Logical Workspace Server
Click this button in
order to test the connection.
For more
information about completing the
Advanced tab, contact your system administrator.