Data Warehouse Advisor

Monitor Data Warehouse Usage to Control Costs, Increase IT Efficiency

Informatica Data Warehouse Advisor is scalable enterprise software that monitors how business units and departments use data, including sensitive corporate data. Both costs and data warehouse load times can be reduced by the identification of inactive and unused data. This software helps your IT organization to better manage data warehouse and integration processes, justify costs, and prioritize resources.

• Optimize schema design and improve data warehouse performance
• Improve data warehouse architecture to better serve user priorities
• Identify sensitive data needing protection

• Lean Data Warehouse Practices

Informatica Data Warehouse Advisor Key Features

Automated Business Activity Monitoring

• Maps business intelligence (BI) applications and data warehouse usage to business units and departments so that IT organizations can see how and by whom data is used
• Tracks and assesses data utilization based on query volume, as well as frequency and currency of access

PowerCenter Performance Reporting

• Reports on multiple Informatica PowerCenter servers and repositories via a single console, and correlates Informatica PowerCenter workflows with data warehouse workloads
• Groups workflows and sessions according to business value, sets performance metric thresholds to detect workflows variances, and delivers notifications when problems and exceptions arise

Data Warehouse Monitoring

• Discovers the most frequently used data and tracks how usage impacts data warehouse performance
• Assesses column usage and database performance to implement optimal database indexing strategies and to determine the best times to run PowerCenter processes based on data warehouse loads

BI User Activity and Query Performance Monitoring

• Identifies the BI users and queries that drain data warehouse performance, and correlates user activity with data warehouse performance metrics
• Sets performance metric thresholds to detect workflows variances, and delivers notifications when problems and exceptions arise

Sensitive Data Usage Tracking and Auditing

• Finds and tracks the users and applications that access sensitive database tables and columns
• Sets thresholds on permissible user activity and delivers notifications when exceptions occur

Enterprise-Level Monitoring

• Monitors the data warehouse without consuming extensive production database resources
• Supports leading data warehouse platforms—including Oracle, IBM DB2, SQL Server, and Teradata—and is ready for enterprise deployment