PMO Reports: Database Connection Check to PPM and DWH

ccppmop158
The PMO Accelerator Advanced Reporting content includes two reports for checking the database connections to the main PPM transactional database and the data warehouse database.
 
Database Connection Check: CA PPM Report
The Database Connection Check: 
Clarity PPM
report monitors the health of the transactional database connection. The report includes the data source connection, the database vendor, and the database schema. The report also displays the database link that is used to access the transactional database from the Data Warehouse.
The following image displays the Database Connection Check:
Clarity PPM
report:
Database Connection Check: CA PPM report
Report Prerequisites
None.
Report Properties
The following values list the report properties:
Name:
 Database Connection Check: CA PPM
Resource ID:
 CSK_ADM_DatabaseConnectionCheckPPM
Description:
 Administration (PMO Accelerator)
Folder:
 CA PPM/Reports/Administration/Database Connection Check: CA PPM
Path:
 /ca_ppm/reports/administration/CSK_ADM_DatabaseConnectionCheckPPM
Data Source:
 CA PPM Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type 
Input Control Name
Input Control Resource ID
Mandatory
Default Value 
UI Theme
ppmUserUITheme
 Hidden
 Not applicable
Yes
Passed through
Clarity PPM
DB Vendor
ppmDBVendor
Hidden
Not applicable
Yes
Passed through
Clarity PPM
DB Schema
ppmDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
DB Link
dwhDBLink
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
None.
Parameter Explanations
None.
Report Fields and Calculations
The report displays a green bulb gauge that shows 
Normal
 when the connection is successful. The report query performs a simple SELECT statement to verify the connection. If the connection is unsuccessful, the following error message appears:
The server has encountered an error. Excuse the inconvenience.
This message indicates that the report cannot be executed due to issues with the CA PPM Bean Data Source connection.
This report contains the following fields:
  • Data Source:
    Displays the data source name CA PPM BEAN.
  • DB Vendor:
    Displays Oracle or Microsoft SQL Server depending upon the value of the DB Vendor parameter that is passed through 
    Clarity PPM
    .
  • DB Schema:
    Displays the value of DB Schema parameter that is passed through 
    Clarity PPM
    .
  • DB Link:
    Displays the value of the DB Link parameter that is passed through 
    Clarity PPM
    . The report does not verify the existence of the database link. The report displays the DBLINK name that is defined in CSA that is passed into Advanced Reporting from 
    Clarity PPM
Report Security
None.
Database Connection Check: Data Warehouse Report
The Database Connection Check: Data Warehouse report is used for monitoring purposes to determine the health of the database connection to the data warehouse (DWH). The report displays information relevant to the DWH database, such as the data source connection, the database vendor, and the schema. The report also displays the database link from the CA PPM transactional database.
The following image displays the Database Connection Check: Data Warehouse report:
Database Connection Check: Data Warehouse Report
 
Report Prerequisites
None.
Report Properties
The following values list the report properties:
Name:
 Database Connection Check: Data Warehouse
Resource ID:
 CSK_ADM_DatabaseConnectionCheckDWH
Description:
 Administration (PMO Accelerator)
Folder:
 CA PPM/Reports/Administration/Database Connection Check: Data Warehouse
Path:
 /ca_ppm/reports/administration/CSK_ADM_DatabaseConnectionCheckDWH
Data Source:
 CA PPM DWH Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type 
Input Control Name
Input Control Resource ID
Mandatory
Default Value 
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity PPM
DB Vendor
dwhDBVendor
Hidden
Not applicable
Yes
Passed through
Clarity PPM
DB Schema
dwhDBSchema
Hidden
Not applicable
Yes
Passed through
Clarity PPM
DB Link
dwhDBLink
Hidden
Not applicable
Yes
Passed through
Clarity PPM
Parameter Lookup Values
None.
Parameter Explanations
None.
Report Fields and Calculations
The report displays a green bulb gauge that shows 
Normal
 when the connection is successful. The report query performs a simple SELECT statement to verify the connection. If the connection is unsuccessful, the following error message appears:
The server has encountered an error. Excuse the inconvenience.
This message indicates that the report cannot be executed due to issues with the DWH Bean Data Source connection.
This report contains the following fields:
  • Data Source:
     Displays the data source name 
    Clarity PPM
     DWH BEAN. 
  • DB Vendor:
     Displays Oracle or Microsoft SQL Server depending on the value of the DB Vendor parameter that is passed through 
    Clarity PPM
  • DB Schema:
     Displays the value of DB Schema parameter that is passed through 
    Clarity PPM
  • DB Link:
     Displays the value of the DB Link parameter that is passed through 
    Clarity PPM
    . The report does not verify the existence of the database link. The report displays the DBLINK name that is defined in CSA that is passed into Advanced Reporting from 
    Clarity PPM
Report Security
None.