(This is an update of a previous article by Naina Padaki. This update includes some smaller changes and new links to relevant Operation Bridge Suite 2020.08 documentation.)
Have you ever wondered how to visualize the data you collect from ITOM products using the Business Intelligence (BI) tool of your choice? The solution is to Bring Your Own BI (BYOBI) tool to visualize the data that is in COSO Data Lake .
With ITOM’s COSO strategy, the data required for operations management is collected once and stored in our COSO Data Lake. Data from this lake can be used by different services. Read here for more details on COSO.
OpsBridge COSO Reporting is based on Business Value Dashboard (BVD) and BYOBI.
Organizations increasingly rely on intelligent reporting and analytics on top of data spanning across multiple sources and domains. In the case of Operations Bridge (OpsBridge), COSO Data Lake receives topology data, metric data, and events from various OpsBridge components such as, Operations Agents, SiteScope, Business Process Monitor, Real User Monitor or Network Operations Management and others being added with each release.
Apart from Business Value Dashboard (BVD), you can use your own BI (Business Intelligence) tools like Microsoft Power BI, SAP Business Intelligence, Tableau, IBM Cognos etc., on top of COSO Data Lake to create reports and dashboards you need. In Figure 1, you can see BYOBI highlighted. You can see how the BYOBI tool interacts with Vertica to show the reports.
Before you start creating the reports in the BI tools of your choice, it is important you consider the below:
- Understand the schema on top of which you plan to create reports (Check here for OpsBridge Data Model within COSO documentation.)
Note: The schema has changed between the COSO Data Lake “limited availability” release available as part of OpsBridge suite release 2019.11 and OpsBridge Suite release 2020.08, which is now generally available.
- Have a fair idea of the report you want to develop to address the business use cases.
- Knowledge of the BI tool.
It is advisable to use a dev/test suite environment to play with the data to develop the new reports. If you plan to use the production environment, ensure you make a copy of the table you are working with and limit the amount of data; there can be an impact on the time it takes to load the report after every edit during the report development process.
View the linked whitepaper to see how Microsoft Power BI and Tableau (as examples) are used to build your own reports on top of COSO Data Lake. You will learn how to connect to Vertica from a BI tool and visualize the data and see how to easily create a report using the data available in the COSO Data Lake.
Using similar procedures you can use other BI tools as well create reports for your use cases.
We encourage you to try out our new features and enhancements!
To get more information on this release and how customers are using Operations Bridge, we are happy to announce the following events:
- On-demand – Micro Focus Universe 2020
- On-demand - Map Your Route to AIOps: A 5-Step Guide
- On-demand - AIOps Summit
- On-demand - What’s New in Operations Bridge Cloud Monitoring
- On-demand - The AIOps Story: Bringing It All Together with Micro Focus Operations Bridge
See all the Micro Focus events worldwide.
Read all our news at the Operations Bridge blog.
Have technical questions about Operations Bridge? Visit the Ops Bridge User Discussion Forum
Keep up with the latest Tips & Info about Operations Bridge
Do you have an Idea or Product Enhancement Request about Operations Bridge? Submit it in the Ops Bridge Idea Exchange
We’d love to hear your thoughts on this blog. Comment below.