Proactive Monitoring for PowerCenter connects to the PowerCenter environment with minimum configuration requirements.
The following steps provide an overview of the solution usage:
Installation
Install Proactive Monitoring for PowerCenter on a machine that is separate from the host machines in the PowerCenter domain.
The solution objects connect to the PowerCenter repository to gather metadata of all the objects that the developers modifies. To fetch data from the tables and views in the PowerCenter repository, the solution requires creation of a read-only user with specific privileges.
See the Installation chapters for pre-requisites and detailed installation instructions.
Configuration and customization
The solution needs to connect to specific services in the PowerCenter domain to start monitoring the domain. This involves configuring the solution through Proactive Monitoring for PowerCenter Management Console.
When the solution is online, you can customize and extend built-in rules to enhance the monitoring capabilities based on the business needs.
See the installation and configuration chapters for detailed instructions on the post-installation configuration steps.
Receiving alerts
The solution can be configured to send email alerts and RTAM alerts to the personas defined in the solution, namely pcadmin, pcmonitor, dataarchitect, apparchitect, itsecurity. Each of these personas can have an associated RTAM login or email ID. In case of email, the user will start receiving email alerts as and when anomalies are detected by the solution. In case of RTAM, the user needs to login to the RTAM web application to check the alerts on demand. You can also configure the PMPC solution to send alerts as SNMP traps. The Proactive Monitoring solution supports SNMP v2.
Viewing Reports
You can use the Reports dashboard to get information about the health of the monitored services, hosts, and nodes in a PowerCenter domain. View the best practice violations that occur over a period of time and drill down into the alert details from the Reports dashboard. Use the on demand reports to generate reports for workflow, session, or transformation attributes.
Managing Objects
You can use the Manage Objects tab to manage watchlists, SQL sources, rules, and topics. You can view the events generated for a source and the activations for a rule.