Chapter 3 Installing the Repository

Installing the Repository Proxy

The Repository is as a client-server application, in which the Client issues SQL statements via an ODBC connection to be executed on the database server. While such a system provides acceptable performance on a Local Area Network (LAN), it may be less effective on a Wide Area Network (WAN).

SQL statements require several network packets, each of which must go back and forth before the next one is issued. While a LAN connection typically has a ping time of less than 10ms; a WAN connection (passing through the Internet via a Virtual Private Network (VPN) connection) has a typical ping of over 100ms.

The PowerDesigner repository proxy is intended to run on either the repository server (if it is a Windows machine) or on the same LAN. Clients connect to it from elsewhere in the WAN using a dedicated protocol, and it can pool client requests, and provides a metadata cache, all of which reduce network communication and improve client response times.

Before you set up the repository proxy, you must install the repository (see Installing SQL Anywhere).

Next you should choose whether to install the repository proxy on the repository server, or on another windows machine on the same LAN, and then accomplish the following steps:

After installation is complete, you can set up client machines to connect to the repository via the proxy. See the Getting Started with the Repository chapter in Working with the Repository .