Chapter 3 Installing the Repository

Setting up a Repository

The PowerDesigner repository can be used to store your PowerDesigner models and other files relating to your design projects.

An administrator must set up the repository, which is stored in a database on a server. The repository can be created with the authenticated copy of the Sybase SQL Anywhere DBMS delivered with PowerDesigner or with one of the following DBMSs:

Oracle 8 and higher
IBM DB2 Common Server and DB2 for OS/390
Sybase Adaptive Server Enterprise
Sybase SQL Anywhere
Informix 2000
Microsoft SQL Server 2000 and higher

In addition, the following databases are supported via a native connection:

Oracle 8 and higher
Microsoft SQL Server 2000 and higher

The following repository components can be installed:

Database server – [required] Select a server to host the repository database and create a database on it. The server need not necessarily be reserved exclusively for hosting the repository, but performance will be improved if this is the case. See Setting up the repository database server.
Repository proxy – [optional] The proxy acts as a bridge between client machines and the repository database, and can provide considerable performance improvements (particularly over a WAN). See Installing the Repository Proxy.
Repository web browser – [optional] The repository web browser allows users to connect to and browse the repository in their standard web browser. See Installing the Repository Web Browser.
Client machines – Can connect either directly to the repository or via the proxy, from PowerDesigner, or from a web browser via the web browser server.

The following diagram shows the various ways of connecting to the repository: