Visibility into your complex ETL environment – to drive smarter decisions, faster and better aligned with the business.

Appfluent Visibility for PowerCenter provides actionable insight into your ETL processes to proactively uncover and resolve issues with a consistent, accurate and repeatable process.

The product is an add-on to the award winning solution, Appfluent Visibility for BI and Data Warehousing and provides a single console to get granular insight into BI, Data Warehouse and ETL activity and associated metrics.

Appfluent Visibility for PowerCenter gives your team the visibility it needs to ensure that business service levels are met while saving hundreds of hours of manual effort and guesswork.

Features

Single console with visibility into BI, Data Warehouse and ETL activity
Get granular insight into Informatica PowerCenter performance metrics within the same console that provides visibility into BI user activity, data usage and data warehouse workloads.

Identify underperforming data loads based on business value
Easily group critical workflows and sessions based on the business value of data to identify underperforming data loads before critical business processes are affected. Provide visibility to key IT and business line managers without requiring PowerCenter clients or expertise.

Get notifications to easily detect exceptions
Set performance thresholds to groups of workflows and sessions based on the business value of data and get notified when any of the critical data loads don’t meet service levels.

Proactively detect variances in service levels
Discover variances in key performance metrics for critical data loads before adversely impacting the business. Set thresholds and get proactively notified when the variance of service levels deviate beyond acceptable levels.

Track Performance Trends
Easily spot trends or variances in performance for specific workflows and sessions Trends are provided for elapsed time, successful and failed source rows and target rows.

Drill down for granular details
For any workflow or session, easily drill down to get information on the mapping and associated transformations including Look-ups, Aggregations, Source qualifiers, Targets and others. Information provided include rows processed, start and end times and trend in elapsed time.

Benefits

Meet Critical Business Service Levels
Proactively discover underperforming ETL jobs before critical business processes are impacted.

Save Wasted Manual Efforts
Eliminate ‘guesswork’ and reduce the time and cost of wasted manual effort with a standard, consistent and repeatable and automated process.

Provide Visibility for All
Provide answers for IT managers from a business viewpoint without requiring PowerCenter clients and expertise in writing custom SQL to get answers.