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.

1. In the Perspective Resources view, select the resource, and select Resource > Administration Console.
2. In the left pane, expand IQ Servers > Networks, and then select Remote Servers.
3. Click the arrow next to Remote Servers and select New.
   The Create Remote Server wizard appears.
4. On the Name and Type page, specify:

   Option	Description
   Resource	The local server that will contain the remote server definition. (The resource from which you want to access the database housed on the remote server).
   Remote Server Name	The local name used for connecting to the server where the remote database is located.
   Type	The type of server where the remote database is located.

5. Click Next.
6. On the Connection Details page, specify:

   Option	Description
   Connection Type	Select Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC).
   Connection Information	Enter either the data source name (OBDC) or host:port/db connection string (JDBC).

   Note: The Remote Server Type you specified on the Name and Type page may limit the connection type. The only server types allowing a JDBC connection are SAP Sybase IQ, SQL Anywhere and Adaptive Server servers. However, for IQ server versions 16.0 and above, JDBC is not supported.
7. Click Next.
8. On the Read-Only Option page of the wizard, select the check-box if you want to define the remote server as a read-only data source. Click Next.
9. On the External Login page of the wizard, select the check-box if you want to enter an alternate login name and password for your user ID (recommended).

   Option	Description
   Login name	The alternate user ID to be used on the remote server.
   Password	The password for validating the alternate user ID on the remote server. The password is optional, but recommended.
   Confirm password	If you enter a password, re-type it as verification.

   Note: You can create external logins for other locally defined users with the Create External Login wizard.
10. Click Finish.