Close

Informatica Blogs

Close

Informatica on Facebook

Close

Informatica on Twitter

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

Marge Breya and Rick Smolan Discuss the Growing Amount of Data
Hi everyone, it’s great to be back again this week. I’m cont

Why Big Data Leaders are Made and Not Born
There are organizations truly reaping the rewards of Big Dat

All Blog Posts
All Discussions

Recent Blocks

Informatica Fast Clone
By Informatica Enterprise Data Integration

Informatica Fast Clone (15 Day Trial)
By Informatica Enterprise Data Integration

All Blocks
Las Vegas, NV
June 4-7, 2013
Register Now
Tell us how Marketplace
helped you.
Win Exciting Prizes!
Get Started