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.