 
With exploding growth in data and users and the associated increase in complexity and costs, senior IT managers are being increasingly required to provide metrics related to business usage of investments made in BI and data warehousing to enable justifying investments, controlling costs and increasing scalability.
Appfluent Visibility uniquely integrates with leading BI applications and data integration products to provide Oracle and Oracle Exadata customers a single integrated solution to manage Big Data smarter and better aligned with the business.
By integrating with the BI Applications such as Oracle BI, Microstrategy, SAP Business Objects, IBM Cognos, SAS as well as data integration solutions such as Informatica PowerCenter and IBM DataStage, Appfluent provides an integrated view to manage data smarter and more efficiently.
The key features provided by Appfluent Visibility include:
- Business Activity Analysis - Track and measure business usage of data with a business-centric view of utilization of BI applications and data
- Data Usage and Dormancy - Identify what data is used, what is unused and how data is frequently used to retain and optimize the most relevant data as well as streamline data loads.
- BI User/Application Activity and Query Performance - Identify BI application users, reports and their ad-hoc queries that severely impact data warehouse performance.
- ETL Performance Analysis - Diagnose problematic ETL loads based on business value to prioritize critical data integration processes.
- Security and Compliance Audit - Ensure trusted usage of data by identifying the users and applications that access sensitive database tables and columns and the specific query activity.
Appfluent Visibility and Oracle Grid/ Oracle Enterprise Manager
Oracle Grid and Oracle Enterprise Manager are database monitoring tools mainly designed for system DBA's and provides visibility into database systems such as CPU, Memory, IO and individual SQL Statements etc. Appfluent Visibility complements Oracle Grid and Enterprise Manager by providing a business and application centric view of data usage by integrating with BI applications to provide how users, applications and reports on the application tier are using the data and impacting the data warehouse. Appfluent Visibility is designed as an analytical application for senior IT managers, enterprise data architects, BI application managers, and data integration managers.
Appfluent Visibility complements Oracle Grid and Enterprise Manager by addressing the following key challenges:
- Data growth is exploding but no information on what data is used, what is unused, and how it is used to retain and optimize the most relevant data. Appfluent Visibility provides detailed insight into data usage for data rationalization, consolidation and archiving and data optimization.
- Lack of integrated view into BI-DW-DI stacks with standard database monitoring tools. Appfluent uniquely integrates with BI applications such as Microstrategy, Business Objects, Cognos and Oracle BI as well as ETL tools such as Informatica PowerCenter and IBM DataStage providing an integrated view into the BI-DW-ETL stack to drive operational efficiency, control delivery costs and improve performance scalability.
- Organizations are exposing sensitive information to large number of users but have no easy way to monitor user activity and usage of sensitive data (Table and Columns within databases). Appfluent provides granular level audit information related to sensitive data usage to meet requirements for activity monitoring, audit, compliance.
|
