Lifting the Lid on OBIEE Internals with Linux Diagnostics Tools

Friday, March 27th, 2015 by

There comes the point in any sufficiently complex or difficult problem diagnosis that the log files in OBIEE alone are not sufficient for building up a complete picture of what’s going on. Even with the debug/trace data that Presentation Services and other components can be configured precisely to write you’re sometimes just left having to […]

OBIEE nqcmd Tidbits

Tuesday, March 24th, 2015 by

nqcmd is the ODBC command line tool that always has, and hopefully always will, shipped with OBIEE. It enables you to manually fire queries directly at the BI Server, rather than through the usual way of Presentation Services generating Logical SQL and sending it to BI Server. This can be useful in several cases: Automated […]

Instrumenting OBIEE Database Connections For Improved Performance Diagnostics

Monday, March 23rd, 2015 by

Nearly four years ago I wrote a blog post entitled “Instrumenting OBIEE – The Final Chapter”. With hindsight, that title suffix (“The Final Chapter”) may have been a tad presumptuous and naïve of me (or perhaps I can just pretend to be ironic now and go for a five-part-trilogy style approach…). Back then OBIEE 11g […]

An Introduction to Analysing ODI Runtime Data Through Elasticsearch and Kibana 4

Thursday, March 12th, 2015 by

An important part of working with ODI is analysing the performance when it runs, and identifying steps that might be inefficient as well as variations in runtime against a baseline trend. The Operator tool in ODI itself is great for digging down into individual sessions and load plan executions, but for broader analysis we need […]

OBIEE Monitoring and Diagnostics with InfluxDB and Grafana

Sunday, February 8th, 2015 by

In this article I’m going to look at collecting time-series metrics into the InfluxDB database and visualising them in snazzy Grafana dashboards. The datasets I’m going to use are OS metrics (CPU, Disk, etc) and the DMS metrics from OBIEE, both of which are collected using the support for a Carbon/Graphite listener in InfluxDB. The […]

Website Design & Build: tymedia.co.uk