Remote Servers (IQ)

Sybase IQ v15.0 and higher supports remote servers, which define where remote objects mapped to a local proxy table are located. PowerDesigner models remote servers as extended objects with a stereotype of <<RemoteServer>>.

Creating a Remote Server

You can create a remote server in any of the following ways:

Select Model > Remote Servers to access the List of Remote Servers, and click the Add a Row tool.
Right-click the model (or a package) in the Browser, and select New > Remote Server.

Remote Server Properties

You can modify an object's properties from its property sheet. To open a remote server property sheet, double-click its Browser entry in the Multiplex Servers folder.

The following extended attributes are available on the General tab:

Name	Description
Class	Specifies the remote server class. Scripting name: Class
Read-only	Specifies that the remote server is a read-only data source. Any update request is rejected by Sybase IQ. Scripting name: ReadOnly
Connection	Specifies the connection string in the format `machine-name:port-number [ /dbname ]` or as a data source name Scripting name: ConnectionInfo

Name

Description

Class

Specifies the remote server class.

Scripting name: Class

Read-only

Specifies that the remote server is a read-only data source. Any update request is rejected by Sybase IQ.

Scripting name: ReadOnly

Connection

Specifies the connection string in the format machine-name:port-number [ /dbname ] or as a data source name

Scripting name: ConnectionInfo