Share this page

# System Overview

This section provides an overview of OpenText PPM architecture.

In this topic:

## Overview of OpenText PPM Architecture

OpenText PPM is based on a three-tier architecture that consists of:

- Client browsers (Client Tier )

- One or more middle-tier J2EE servers (Application Server Tier)

- A single Oracle relational database (Database Tier)

This arrangement is shown in the following figure.

OpenText PPM architecture

Browser clients use HTTP or HTTPS (HTTPS requires an external Web server) to communicate with the OpenText PPM Web and application servers. PPM Workbench clients (Java� applet) use Remote Method Invocation (RMI). The following sections provide information about each tier.

## Client Tier

The client tier of the system consists of:

- The OpenText PPM standard interface. The standard interface is rendered using Java Server Pages (JSP) and is accessed using a web browser.

- The PPM Workbench interface is displayed using a Java applet installed on the client machine, and is started using the Oracle Java plug-in to a web browser.

- The Administration Console. The Administration Console is embedded in the OpenText PPM standard interface.

The client and application server tiers communicate as follows:

- For the standard interface, the client and application server communicate using HTTP or HTTPS, with no code required on client machines. The client accesses information from the database through the J2EE application server using a shared database session pool.

  Note: To use HTTPS, you must also use an external Web server.

- For the PPM Workbench interface, the client and application server communicate using Remote Method Invocation (RMI) or Remote Method Invocation over SSL (RMIS), which is optimized for use in OpenText PPM.

  The architecture and communication protocols are created to minimize the number of round trips between the applet and server, and the volume of data transferred.

## Application Server Tier

The application server (PPM Server):

- Runs on the Microsoft� Windows�, Oracle Solaris, HP-UX, IBM AIX, Red Hat Linux, and SUSE Linux platforms

- Uses the Tomcat Application Server

- Houses workflow, scheduling, notification, and execution engines that drive automated tasks such as running scheduled reports and email notifications

- Can run on multiple machines as a cluster to improve performance and scale hardware as usage increases

- Can run with external Web servers such as Oracle Java System Web Server, Microsoft IIS, Apache HTTP Server, Apache-based Web Server (from OpenText), and IBM HTTP Server

  Note: For detailed information on which Web server versions OpenText PPM supports, and on which platforms, see the System Requirements and Compatibility Matrix.

- Maintains a database connection pool that caches connections to the database

- Eliminates the need to restart the PPM Server if the database shuts down for scheduled maintenance or because of system failure

The application server and the PPM Web server communicate using Apache JServ Protocol version 1.3, or AJP13. The AJP13 protocol is similar to HTTP that has been optimized for performance. The application server and database tiers communicate using Java Database Connectivity (JDBC).

For more information about configuring an external Web server, see Configure an external web server.

## Database Tier

The database tier consists of an Oracle database that contains the tables, procedures, PL/SQL packages, and other components that the OpenText PPM products use. All transaction, setup, and auditing data are stored in the database. OpenText PPM can run on a single database instance, or it can leverage Oracle RAC (Real Application Cluster) configuration for load balancing and redundancy.

Note: The database consists of the following two database schemas:

- The central schema contains the core PPM Center data model and PL/SQL package code. The core data model contains all PPM Center configuration and transaction data.
- The Reporting Meta Layer (RML) schema contains a set of database views to facilitate reporting on PPM Center data.

Note: Running OpenText PPM on Oracle RAC is supported. However, the Oracle RAC failover feature is not available due to that OpenText PPM uses Oracle Thin JDBC Driver.

OpenText PPM supports the following Oracle database features:

- A relational data model

- Use of Oracle stored procedures to implement business logic (for example, workflow processing)

- Use of a database connection pool to eliminate the need to create a separate database session for each user or transaction

- Database caching of frequently-used data, programs, and procedures to improve performance

- A database schema (separate from the OpenText PPM database schema) for implementing operation reporting in OpenText PPM

### If you use MySQL database in the database tier for PPM

Since version 9.50, PPM no longer ships MySQL JDBC driver along with the release bundle, so if you use MySQL in the database tier of any Deployment Management environment object, you have to manually install MySQL Connector/J in the directory `<PPM_Server>\PPM950\deploy\itg.war\WEB-INF\lib\`.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: