Typically applications such as Microstrategy 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 Microstrategy users or reports. Conversely data warehouse managers are limited to viewing single SQL statements and its metrics but cannot identify which Microstrategy users or reports are generating the queries that impact the data warehouse.
Appfluent Visibility integrates with Microstrategy 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 Microstrategy, Appfluent provides the ability to correlate data usage and database query metrics with Microstrategy 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 Microstrategy 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 Microstrategy 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 Microstrategy user activity.
- Identify frequently used Tables and Columns associated with slow running SQL generated by Microstrategy. Discover patterns of repetitive complex operations and aggregation and the associated Microstrategy 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.
|
