Monitoring BI Platform in Microsoft Operations Management Suite

[christian_key2]

Hello experts,

My company is using Microsoft Operations Management Suite (OMS) to monitor our infrastructure. We would like to include BI Platform monitoring in OMS so that all of our monitoring is in one place. Ideally we would like to monitor a selection of the metrics that are available in Monitoring in the CMC. Can these be monitored outside of the CMC?

What ideas do you have that would allow us to integrate BIP monitoring into the OMS?

Thanks,

Christian

[christian_key2 · Accepted solution]

Here's what I have found out

• All Business Objects specific counters are stored in the Business Objects embedded monitoring database on the BI server.
• These counters can be accessed using JMX (Java Management Extensions) since it is a Java based database.
• Monitoring tools such as IBM Tivoli and SAP Solution Manager can access this database.
• There is a JMX end point URL through which other clients can connect using JMX Remote API. This URL is service:jmx:boeiiop://671596-BIprivat/<servername>:6400 so we may be able to hook into that.
• There is also an option to connect through a RMI port.
• Another option is to store the trend history of metrics in the Auditing database. I would need to configure the monitoring application to use the Auditing database instead of the embedded monitoring database.

So there seems to be a few options to hook into the monitoring metrics here.

Chris

[former_member185603 · Accepted solution]

Above mentioned all by you, are possible options.

Move monitoring DB to Audit DB. There are some steps laid out in Admin guide depending on the DB you are using.

[former_member182521 · Accepted solution]

I tried to Integrate BOE 3.1 with SCOM sometime back in 2011. Not sure this is still supported. You can refer here to understand How it look like

https://wiki.scn.sap.com/wiki/display/BOBJ/Enterprise+Monitoring+and+BusinessObjects+Enterprise+XI

Redirecting this thread to   to get attention.

Thanks

Mani

[Toby_Johnston · Accepted solution]

Hello, I agree the way to integrate real-time metrics from CMC monitoring would be to use the JMX endpoint URL and access the JMX MBeans directly (you can browse this using JConsole to get a feel on how to query these MBeans to get the info you are looking for)

For historical metrics you can query the monitoring trend database via JDBC or if you are using auditing database for trending database then you can query it via supported db clients.

Regards
Toby

[former_member185603]

I don't believe if there is any integration between BO and OMS.

Since BO monitoring metrics stored in Monitoring DB, I would suggest if you can get that information from DB and show it in OMS. I am not familiar with OMS tool, not sure what capabilities it has.

[christian_key2]

HI Jawahar,

Thanks for the information. Is it possible to query the monitoring database, perhaps there is an interface/API into the monitoring databse that we can access?

Thanks,

Chris