Develop > OOTB Content > Out-of-the-Box Content Packs (CPs) > Integration with PPM

Integration with PPM

This section describes the integration, contexts, KPIs, Metrics, and reports, if any, associated with the integration with the Project and Portfolio Management data source.

The purpose of the integration of PPM as a data source is to bring quality management information into the Data Warehouse.

For details about Project and Portfolio Management (PPM), see http://www8.hp.com/us/en/software-solutions/ppm-it-project-portfolio-management/index.html.

ClosedTo access:

Select ADMIN > Data Management > Connect Data Source then click Add data source and select PPM to activate the integration processes for the PPM data source.

ClosedContent Packs and their functionality

To learn about Content Packs and their functionality see, Data Management - Connect the Data Sources.

ClosedImportant Information

  • The PPM Content Pack supports multiple instances.

  • DCS Integration: An extractor using the Data Collection Service mechanism that extracts entities from the source and generates corresponding flat files. For details, see Data Collection Service (DCS) .

  • All fields are case-sensitive.

ClosedActivate the Integration

  1. Select ADMIN > Data Management > Install Content Pack then click the install button relevant for the data source.

  2. Select ADMIN > Data Management > Connect Data Source then click Add data source.

  3. The Add Data Source page opens. Select the PPM data source type.

  4. Select or enter the configuration parameters.

  5. Click Next to proceed to the validation page.

ClosedConsolidate PPM and ALM

If you are integrating ALM and PPM data sources, the consolidation process between ALM and PPM identifies ALM releases as child- projects of PPM projects.You can map which release of the ALM domain is connected to the specific PPM project. The manual mapping must be performed before running ETL. For details, see Consolidate Between ALM and PPM .

ClosedPPM Activation Page

The data warehouse is connected to Project and Portfolio Management through high-level integration processes. A set of database views enables the extraction of the main PPM objects.

Mandatory fields are marked with a red asterisk.

User interface elements are described below:

Note The Oracle database can have both Server ID (SID) and Service Name properties, but the user should specify only one. If you define the SID, then the SID is used, and if you define Service Name, then Service Name is used. If you define both in the UI, only SID is used.

UI Element

Description
Instance name Enter a name for the data source instance you are activating.
PPM Version

Select the relevant PPM version. For details, see the ..
Time Zone Select the time zone for the data source.
Data Source Type PPM can be run only on Oracle.
Username Enter your username used to log on to the PPM database.
Password Enter your password used to log on to the PPM database.
Hostname/IP Address

Enter the Oracle server database hostname or IP address.

Port Port for database connections.
SID Enter the unique name of the database.
Service Name Enter the alias used when connecting.
Schema Name Enter the name of the Schema.
Initial Load Period (months) Select the number of months from which you want the initial data loaded.

ClosedDimensions that are filled by CSVs

  • Budget
  • Cost Category

ClosedPPM-Related KPIs and Metrics

For details about the KPIs and Metrics related to the integration with PPM, see KPIs and Metrics.

Send Help Center feedback