Attunity Visibility

Analytics for Data Warehouse and Hadoop Management

Assess and manage your data usage, and its impact on your infrastructure, in the context of the business.  Improve data warehouse and Hadoop performance, prioritize investments and gain real-time business insights at lower cost.

With Attunity Visibility, enterprises can gain insight into business activity, resource consumption and data usage across data platforms to deliver increased operational efficiency and reduce data management costs.  Use Visibility to manage your data warehouse and ecosystem more effectively.

With Visibility customers can:

  • Map users and application activity to data usage and data warehouse performance
  • Continuously collect, storage, and analysis of all queries and applications against data warehouses
  • Monitor data consumption and workload performance metrics for the entire data warehousing environment
  • Monitor Hadoop with the same metrics and controls as the data warehouse
  • Business Activity

    Problem: Enterprises struggle to understand how data assets are being used in order to make better decisions about managing it. Attunity Visibility enables you to measure activity and usage trends by business line to support chargeback and showback. You can identify heavy users and their impact on the data warehouse, as well as data best suited for archival.

    Solution: Visibility allows enterprises to:

    • Measure activity and usage trends by business lines and departments within your organization
    • Identify individual application users and BI reports that impact system performance on the data warehouse
    • Optimize multiple data delivery platforms with an integrated dashboard to diagnose and assess performance bottlenecks
  • Workload Performance

    The problem: diagnosing data warehouse performance issues quickly and without major resource impact. 

    Solution: Visibility helps enterprises to:

    • Easily identify individual application users and BI reports that impact system performance on the data warehouse
    • Identify frequently used data associated with problem SQL and quickly identify associated users and applications
    • Discover and isolate repetitive and frequent operations that cause bottlenecks in the data warehouse

     

  • Analyzing Data Usage

    The problem: Enterprise are faced with:

    • Exponential data growth, coupled with lack of insight into data usage
    • Inability to assess how much history is actually used in specific tables
    • Difficulty in tracking user activity with sensitive data to minimize risk 

    Visibility image

    Solution: Visibility:

    • Identify unused data that can be archived rather than consuming valuable EDW capacity and loading cycles
    • Assess how much historical data is being used in large tables to guide data retention policies
    • Identify the users that access specific database tables or columns to meet audit requirements and reduce compliance exposure
  • Hadoop Data Usage and Workload Analytics

    The problem: Control Hadoop growth and budget, optimize performance and ensure compliance

    Visibility GUI for Optimization

    The answer: 

    • Improve capacity planning by analyzing storage level activity, including HDFS, directories and files
    • Optimize performance by monitoring data processing activity across many Hadoop engines, including MapReduce, Tez and Impala

    • Drill into usage patterns to assist compliance and chargeback, including file and directory level actions by users