Setting up the Client/Server environment

Chapter 2 Introduction to the Repository

Setting up the Client/Server environment

Database server

You need a database server and a database running on the server. The database does not need to be specifically designed to store the repository tables, however repository performance is improved when the database only hosts repository tables. The proxy can also be installed on the database server. The DB Administrator is responsible for setting up the database server and the repository proxy.

Database client

On each client workstation you must:

Install PowerDesigner and ODBC drivers.
Create an ODBC data source to access the database on the server.
Create a repository definition.

However, if you use the repository proxy, you only have to Install PowerDesigner on each client workstation, the ODBC drivers and the data source are installed on the repository proxy.

Repository Proxy

On the repository proxy you must:

Install ODBC drivers.
Create an ODBC data source to access the database on the server.
Define an instance of the repository proxy for the database on the server.

First connection to the server

The first time you connect to the server, the repository tables must be created in the database, in this book we call this step repository database creation, see "Creating the repository database" in the "Connecting to the repository" chapter.

When the repository database is created, the clients can connect to the server and use the repository.

WARNING!

Caution
You cannot create a repository using a proxy connection, you have to connect to the repository using a direct connection and execute the repository installation before using the repository proxy. For more information about proxy and direct connection, see the Connecting to the Repository chapter.