IT Operations Management (ITOM)
cancel
Showing results for 
Search instead for 
Did you mean: 

SHR Northbound: Opening up new vistas enabling third-party BI integrations !

SHR Northbound: Opening up new vistas enabling third-party BI integrations !

Vineetha_V

Those of you familiar with HP Service Health Reporter would by now be aware of the fact that it ships a Business Objects based reporting platform for delivering out-of-the-box report content and also enabling ad-hoc reporting of IT performance metrics.

 

If you aren’t currently using SHR, click to sample it today.

 

SHR offers powerful, extensible people centric IT reporting tailor-made for Executives, Managers, Analysts and corporate end-users alike.

 

At times, we come across deployment scenarios wherein organizations already have adopted a single ‘standardized Business Intelligence platform’ of their choice and would prefer to have data reported off the SHR performance management database via their preferred BI portal.

 

Well, the good news is that this is of course possible …

 

This blog post makes an attempt to elucidate such integrations for the benefit of the clientele interested in 3rd party BI integrations from SHR.

 

The secret sauce easing 3rd party BI integrations

 

Let’s look at some of the details surrounding how this integration is enabled. The content packs in the latest SHR 9.40 release package a set of database views that are deployable in the SHR database. These views have been auto-generated in each content pack by the SHR Content Development Environment (CDE) and offer ‘data cubes’ that can potentially be leveraged in any query involved in a 3rd party BI tool for reporting on SHR data.

 

For example,

For OMi content in SHR, the script offering the view definitions is available on the SHR server @ {PMDB_HOME}\packages\OMi\OMi.ap\OMi_view_vw.sql

 

For System Performance content in SHR, the script offering the view definitions is available on the SHR server @ {PMDB_HOME}\packages\SystemManagement\CoreSystemManagement.ap\CoreSystemManagement_view_vw.sql

… and so on for rest of the content packs released on SHR 9.40 version onwards.

 

These data views do come handy while building customized reporting use cases on 3rd party BI tools as you will see in some illustrations described later in this article.

 

Of course, there exists the choice of directly querying the tables beneath these data cubes in isolation as well.

In either case, for details on more semantics on the metrics offered within each, SHR offers data model documentation in each of the packaged content packs which is detailed in a former blog post – All you need to know about Model Documentation in SHR.

 

Some 3rd party BI illustrations

                                                                                                               

There are few illustrations of such integrations posted on the SHR Community as proof points on how it can be achieved via some external BI tools like Tableau etc.

 

Tableau

 

In Tableau, firstly, a connection to the SHR Sybase IQ database needs to be created (if you do not have the IQ driver in place, it could be retrieved from the SHR server/CDE package).

The next step is to create custom sql queries as required by the reporting use case leveraging the afore-mentioned cube view definitions.

 


Thereafter the dimensions and measures thus retrieved could be leveraged for preparing data visualizations to serve the required use case (the ‘Show Me’ kit offering necessary pointers on varied visualization types).

 

 

 

QlikView

In QlikView, an ODBC connectivity needs to be established via the ‘Edit Script’ dialog in the File menu; followed by sql definitions that need to be run against the SHR database. The output could then be saved as .qvw files.

 

Microsoft Power BI

Microsoft Power BI requires a SQL Anywhere client as a pre-requisite to establish connectivity to the backend Sybase IQ database of SHR.

(In this case, there is also an option of connecting to the SHR Business objects universe as well for data retrieval via the logical model exposed in the BObj semantic layer).

 

BIRT and others …

In a similar fashion, data from SHR can also be made available in BIRT and other tools for reporting purposes.

 

Do let us know your thoughts on this front via the IT Experts Community forum for SHR Practitioners.

 

_________________________________________________________________________________________________

 

Community Forums

 

The IT Experts Community Forum for SHR Practitioners is now integrated under the Forums tab of the Service Health Reporter pages on HP Live Network.

 

We encourage you to use this forum in lieu of the HP LN forum for SHR queries. This is accessible using HP Passport login.

For the comprehensive Operations Bridge solution, see Operations Bridge forums.

 

Community Content

 

SHR Community content (downloads, tools and other resources) continues to be hosted on HP Live Network.

 

Here are some quick links to consolidated references for SHR blog articles and SHR Videos - do check it out !

 

For more on tools, downloads and other resources, see the updated SHR product overview page on HP Live Network.

 

_________________________________________________________________________________________________

 

Get more information

 

HP Service Health Reporter - hp.com/go/shr

 

HP Service Health Reporter on HP Live Network - hpln.hp.com/group/service-health-reporter

 

HP Service Health Reporter on BSM Community - hpln.hp.com/node/14127/contentfiles/?dir=16929

 

HP BSM - hp.com/go/bsm

 

HP OpsBridge - hp.com/go/opsbridge

 

 

  • operations bridge
About the Author

Vineetha_V

Comments
HPE Blogger

Thats a great idea to expose the underlying schema via views for 3rd party BI integrations ... shields customer's BI preference from underlying schema changes by just modifying the view(s), and leaves R&D the flexibility to change the schema without worrying about breaking existing integrations.

//Add this to "OnDomLoad" event