Installing the Repository Proxy

The PowerDesigner repository proxy is an optional program that runs as a service on or near the repository server and translates SQL requests from client workstations into a more efficient proprietary format. The proxy can considerably improve performance, particularly if clients will be connecting over a WAN or complicated LAN environment or when dealing regularly with larger (15MB+) models, due to its client request pooling and sophisticated caching. It also simplifies the client connection to the repository, as users do not need to know details of the database hosting the repository.

1. Choose whether to install the repository proxy on the repository server, or on another windows machine on the same LAN.

   You should install the proxy on the same server as the repository, if possible, to optimize communication between the components. If the repository database server is not a Windows server or is unable to support the additional workload, then we recommend installing the proxy on another machine on the same LAN segment. We recommend as a minimum, a dual-core machine, with 2-4GB of RAM.

2. Create a system data source on the chosen machine to define the connection between the proxy and the repository database (see Creating a Data Source to Access the Database).
   Note The repository proxy is available in 32-bit and 64-bit versions, and both versions can support connections from 32-bit and 64-bit clients. If you upgrade a 32-bit proxy installation to 64-bit, then you must upgrade its ODBC or other connections to the repository from 32-bit to 64-bit as well (see Upgrading from 32-Bit to 64-Bit PowerDesigner).
3. Navigate to and double-click Autorun.exe in your PowerDesigner DVD to launch the installer, and click Install PowerDesigner Repository Proxy 16.6 (32-bit) or Install PowerDesigner Repository Proxy 16.6 (64-bit). Alternatively, if you have downloaded an install, double-click PowerDesigner166x86_Proxy.exe or PowerDesigner166x64_Proxy.exe.
4. Click Next to go to the license agreement page. Select the location where you are installing the software, read the License Agreement, and then click the I Agree radio button to accept its terms. If you click I Do Not Agree, you cannot proceed further.
   Note You can print the License Agreement from the Setup\Licenses directory on the product CD.
5. Click Next to go to the directory selection page. Accept the default installation directory or choose another by clicking the Browse button.
6. Click Next to go to the current settings page to review your choices, and then click Next to start copying files.

   When setup is complete, a page is displayed with two options selected by default, to let you start the proxy service and launch the configuration tool.

7. Click Finish to exit the wizard and open the Proxy Configuration dialog.
   Note You must have write access on HKEY_LOCAL_MACHINE to change proxy parameters. On a Windows 7 machine, you must launch the Proxy Configuration dialog by right-clicking its icon and selecting Run as administrator. You can open the configuration dialog at any time by navigating to the proxy installation directory and launching pdproxyconf16.exe.
8. Click New to create a new proxy connection instance, and enter the following parameters.

   Parameter	Value
   Instance name	Enter an appropriate name to identify the instance.
   Data source	Select the system data source you created for the repository from the list. Note that the proxy cannot access user data sources.
   User name	Enter the user name used to connect to the repository database.
   Password	Enter the password used to connect to the repository database.
   Bytes per char	For non-Oracle unicode or multi-byte character set databases, specify the bytes per character used by the database: 1-byte - For SBCS (Single-Byte Character Set) 2-byte - [default] For DBCS (Double-Byte Character Set) 3-byte - For Unicode or MBCS (Multi-Byte Character Set)
   Port	Enter the connection port of the server on which the proxy is installed and which allows the client to communicate with the server using TCP/IP protocol. The default port number is 32999.
   Log file	Select the level of logging that you want to perform and enter or browse to the path to the log file in the Name field.
   Cache	Enter or browse to the path to the cache, and specify its maximum size. The default is 300MB, which is generally sufficient for optimum proxy performance.

   Note A single proxy server can provide simultaneous connections to multiple PowerDesigner repositories of the same version. Click the New button to create an additional instance.
9. Click OK to complete your definition of proxy instances.

   Users can now connect to the repository via the proxy by specifying the server name, port number and instance name in a proxy repository definition (see Core Features Guide > Modeling with PowerDesigner > Getting Started with PowerDesigner > Accessing the Repository).