Typically applications such as Oracle BI (OBIEE) connect to a data warehouse as a single application user and it is near impossible for BI managers get visibility into data usage and query performance metrics on the database for specific Oracle BI users or reports. Conversely data warehouse managers are limited to viewing single SQL statements and its metrics but cannot identify which Oracle BI users or reports are generating the queries that impact the data warehouse.
Appfluent Visibility integrates with Oracle BI and leading data integration products to provide enterprises a single integrated solution to manage Big Data smarter and better aligned with the business.
By integrating with Oracle BI, Appfluent provides the ability to correlate data usage and database query metrics with Oracle BI users and reports to provide an end-to-end view.
The key features provided by Appfluent Visibility include:
- Respond faster to end-user issues with complete visibility. Easily find the most active Oracle BI users and reports that impact the performance of your data warehouse (i.e. correlate with database metrics).
- Quickly find problematic queries and isolate the sources including the Oracle BI users and reports responsible for the problem queries.
- Easily track and report on the use of sensitive data to meet security and compliance audits. Set thresholds and get notified to proactively discover inappropriate or unauthorized Oracle BI user activity.
- Identify frequently used Tables and Columns associated with slow running SQL generated by Oracle BI. Discover patterns of repetitive complex operations and aggregation and the associated Oracle BI users and reports.
- Measure how your business units and departments are using your BI and DW infrastructure and deliver score cards and dashboards in Oracle BI.
|
