Close

Informatica Blogs

Close

Informatica on Facebook

Data Warehouse Advisor

Monitor data usage to optimize data warehouse design and infrastructure.

powerCenter Hero

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

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

Services & Training

Informatica offers a full range of services and training to help you maximize the value of the Informatica Platform in your environment.

Learn More About Services

Recent Buzz

Tips & Tricks: Informatica MDM Now Supports Record Locking
Attention MDM developers, did you know that Informatica Mast

The Power of Data: From Traditional Loyalty Marketing, to Social Marketing to Mobile Marketing
Last week at our worldwide users’ conference, Informatica Wo

All Blog Posts
All Discussions

Recent Blocks

All Blocks
No-cost Lean Data Warehouse Healthcheck
Learn more