Description

Organizations increasingly rely on intelligent reporting & analytics on top of data spanning multiple sources and domains. To enable this critical function, the Operations Bridge suite utilizes the OPTIC Data Lake, a component on the ITOM platform that consolidates the data collection and storage of a high volume of data from various Operations Bridge suite components into a common data lake. This white paper introduces the concept of Bring Your Own BI tool, to guide you in building your own reports on top of the OPTIC Data Lake, using example BI tools. It also includes sample reports that you can directly import into the respective tools.

Suggested apps

Suggested for you are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.

Releases

Release
Size
Date
Guide to using an external BI tool on OPTIC DL 24.1
10.1 MB
  |  
Feb 9, 2024
More info Less info
Product compatibility
Version 2022.05 · 2022.11
Version 2023.05
Version 23.4
Version 24.1
Release notes

This guide has been updated to work with Operations Bridge 24.1 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Magellan, Tableau, Power BI, Grafana, Qlik Sense, and SAP Business Objects), including some best practices. It provides references to the corresponding Operations Bridge data model documentation. In addition to the guide showcasing the report building, it includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI in a .pbix file, Grafana dashboards as json files, and a QlikSense app in the form of a qvf file. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

What's New: This version of the guide has added the following details:

  • New sample Grafana dashboards for Service Health Data in the OPTIC Data Lake
    • HI Overview and Distribution Over Time
    • KPI Overview and Distribution Over Time
  • Updated screenshots for adding Power BI dataflows for reporting on the OPTIC Data Lake when using OpsBridge-SaaS
  • Operations Bridge 24.1 support
Languages
English
Guide to using an external BI tool on OPTIC DL 23.4
10.1 MB
  |  
Dec 11, 2023
More info Less info
Product compatibility
Version 2022.05 · 2022.11
Version 2023.05
Version 23.4
Release notes

This guide has been updated to work with Operations Bridge 23.4 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Magellan, Tableau, Power BI, Grafana, Qlik Sense, and SAP Business Objects), including some best practices. It provides references to the corresponding Operations Bridge data model documentation. In addition to the guide showcasing the report building, it includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI in a .pbix file, Grafana dashboards as json files, and a QlikSense app in the form of a qvf file. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

Languages
English
Guide to using an external BI tool on OPTIC DL 2023.05
9.9 MB
  |  
May 22, 2023
More info Less info
Product compatibility
Version 2022.05 · 2022.11
Version 2023.05
Release notes

This guide has been updated to work with Operations Bridge 2023.05 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Magellan, Tableau, Power BI, Grafana, Qlik Sense, and SAP Business Objects), including some best practices. It provides references to the corresponding Operations Bridge data model documentation. In addition to the guide showcasing the report building, it includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI in a .pbix file, Grafana as a json file, and a QlikSense app in the form of a qvf file. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

What's New: This version of the guide has added the following details:

  • Additional support for Grafana with OpsBridge-SaaS
  • This version has added Magellan BI & Reporting as an additional example BI tool to build reports on the data in the OPTIC DL.
Languages
English
Guide to using an external BI tool on OPTIC DL 2022.11
9.4 MB
  |  
Dec 14, 2022
More info Less info
Product compatibility
Version 2021.11
Version 2022.05 · 2022.11
Release notes

This guide has been updated to work with Operations Bridge 2022.11 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Tableau, Power BI, Grafana, Qlik Sense, and SAP Business Objects), including some best practices. It provides references to the corresponding Operations Bridge data model documentation. In addition to the guide showcasing the report building, it includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI in a .pbix file, Grafana as a json file, and a QlikSense app in the form of a qvf file. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

What's New: This version of the guide has added the following details:

  • opr_event flex table usage: with OpsB 2022.11 release, the opr_event table that contains the raw event log has been converted into a flex table. We have added some guidance around how best to consume data from the flex table.
  • This version has added SAP Business Objects as an additional example BI tool to build reports on the data in the OPTIC DL.
Languages
English
Guide to using an external BI tool on OPTIC Data Lake 2022.05
8.6 MB
  |  
May 13, 2022
More info Less info
Product compatibility
Version 2021.05 · 2021.08 · 2021.11
Version 2022.05 · 2022.11
Release notes

This guide has been updated to work with Operations Bridge 2022.05 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Tableau, Power BI, and Grafana), including some best practices. It provides references to the corresponding Operations Bridge data model documentation.

What's New: This version of the guide has added a Qlik Sense as an additional example BI tool to build reports on data in the OPTIC DL. In addition to the guide showcasing the report building, this version includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI .pbix file, a json file for importing into Grafana, and a QlikSense app in the form of a qvf file. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

Languages
English

Prior releases

Release
Size
Date
Guide to using an external BI tool on OPTIC Data Lake 2021.05
6.6 MB
  |  
Jul 23, 2021
More info Less info
Product compatibility
Version 2020.08 · 2020.10 · 2020.10.2
Version 2021.05
Release notes

This guide has been updated to work with Operations Bridge 2021.05 version. It showcases how to consume data from the OPTIC Data Lake and build reports in a BI tool of your choice, using example BI tools (Tableau, Power BI, and Grafana), including some best practices. It provides references to the corresponding Operations Bridge data model documentation.

What's New: In addition to the guide showcasing the report building, this version includes few sample reports that have been published in the OpsB-OPTIC-DL-sample-reports.zip file that goes along. The zip includes sample reports for Tableau, in the form of Tableau workbooks, Power BI .pbix file, and a json file for importing into Grafana. You can download the samples and use them as-is, hooking them up with your own OPTIC DL, or modify and build on top of them.

Languages
English
Guide to using an external BI tool 2020.10
2.7 MB
  |  
Dec 7, 2020
More info Less info
Product compatibility
Release notes

This version of the guide has been evaluated to work with Operations Bridge 2020.10 version. The guide showcases how to consume data from COSO Data Lake and build reports in a BI tool of your choice, using example BI tools (Tableau, Power BI, and Grafana), including some best practices. It provides references to the corresponding Operations Bridge data model documentation.

Languages
English
Files
Guide to using an external BI tool 2020.08
1.9 MB
  |  
Oct 5, 2020
More info Less info
Product compatibility
Release notes

This version of the guide has been evaluated to work with Operations Bridge 2020.08 version. The guide showcases how to consume data from COSO Data Lake and build reports in a BI tool of your choice, using example BI tools (Tableau, Power BI), including some best practices. It provides references to the corresponding Operations Bridge data model documentation.

Languages
English
Files
Guide to using an external BI tool 2019.11
1.7 MB
  |  
May 28, 2020
More info Less info
Product compatibility
Release notes

This version of the guide has been evaluated to work with Operations Bridge 2019.11 version. The guide showcases how to consume data from Store Once and build reports using your own BI tool of choice, using example BI tools (Tableau, Power BI), including some best practices. It provides references to the corresponding Operations Bridge data model documentation.

Languages
English
Files
Guide to using an external BI tool 1.0
910.4 KB
  |  
Feb 15, 2019
More info Less info
Product compatibility
Release notes

This version of the guide has been evaluated to work with OpsBridge 2018.11 version.

The guide showcases how to consume data from Store Once and build reports using your own BI tool of choice, using an example BI tool (Power BI), including some best practices. It provides references to corresponding Store Once schema documentation.


Languages
English
Files

Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the OpenText Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2024-10-1-6270 | Sun Oct 6 21:16:47 PDT 2024