Viewing or Modifying Remote Server Properties

Display or change the properties of the selected remote server definition.

Prerequisites

Database Version	Remote Server Privileges
SAP Sybase IQ 15.3 and 15.4	View remote server properties – none. Modify remote server properties – you must have DBA authority.
SAP Sybase IQ 16.0	View any remote server property page – none. Modify any remote server property – you must have the SERVER OPERATOR system privilege.

Database Version

Remote Server Privileges

SAP Sybase IQ 15.3 and 15.4

View remote server properties – none.

Modify remote server properties – you must have DBA authority.

SAP Sybase IQ 16.0

View any remote server property page – none.

Modify any remote server property – you must have the SERVER OPERATOR system privilege.

The SAP Sybase IQ resource is authenticated and running.

Task

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Networks, and then select Remote Servers.
Select the remote server from the right pane and either:
- Click the arrow to the right of the name and select Properties, or
- From the Administration Console menu bar, select Resource > Properties
The Remote Server Properties view appears.

View the properties, including the defined proxy tables, remote procedures and external logins associated with the remote server, by navigating to the corresponding page on the Remote Server Properties view. On any page, by selecting a proxy table, remote procedure, or external login and clicking the corresponding button, you can Edit, Delete, Generate DDL or View Data in SQL.

When you are modifying properties, you need not click Apply before changing screens; however, doing so saves any changes.
If you do not have privileges to modify properties, SAP Control Center displays the properties view in read-only mode.

Area	Description
General	Name – (Read-only) The local name used for connecting to the server where the remote database is located, as specified when the remote server was created. Read-Only – (Read-only) Indicates whether the remote server is a read-only data source, as specified when the remote server was created. Server Type – The type of server where the remote database is located. Connection Type – The Remote Server Type you specify may limit the connection type. The only server types allowing a JDBC connection are SAP Sybase IQ, SAP® Sybase SQL Anywhere and SAP® Sybase® Adaptive Server Enterprise servers. However, for IQ server versions 16.0 and above, JDBC is not supported. Connection Information – Use the Test Connection button to validate the connection information.
Proxy tables	Name – The local name used for the object on the remote database Owner – The specified user ID owning the object. Location – The server on which the remote database resides. Comment – Additional description or information.
Remote procedures	Name – The local name used for the procedure on the remote database Owner – The specified user ID owning the procedure. Comment – Additional description or information
External logins	User – The defined local user for whom the alternate login name and password (external login) was created Login Name – The user ID used on the remote server by the User.

Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.