Remote Servers

A remote server allows you to set up access to remote database objects, using external logins, proxy tables and remote procedures.

For some systems, including SAP Sybase IQ and SQL Anywhere, each data source describes a database; therefore, you must define a separate remote server definition for each database.

• Creating a Remote Server
  Before you can map remote objects to a local proxy table, you must define the remote server where the remote object is located.
• Testing a Remote Server Connection
  Test the physical connection to one or more remote servers.
• Deleting a Remote Server
  Remove one or more existing Remote Server definitions, along with all associated proxy tables, remote procedures and external login definitions.
• Generating Remote Server DDL Commands
  Generate data description language for one or more remote servers. The DDL can be a useful resource and training tool.
• Viewing or Modifying Remote Server Properties
  Display or change the properties of the selected remote server definition.
• Remote Server Privilege Summary
  A list of the system privileges and object permissions required to complete the various remote server tasks