nqcmd - Rittman Mead

OBIEE BI Server Cache Management Strategies

The OBIEE BI Server cache can be one of the most effective ways of improving response times of OBIEE dashboards. By using data already in the cache it reduces load on the database, the network, and the BI Server. Should you be using it? I always describe it as the

Technical

OBIEE nqcmd Tidbits

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

Technical

Built-In OBIEE Load Testing with nqcmd

nqcmd ships with all installations of OBIEE and includes some very useful hidden functionality - the ability to generate load tests against OBIEE. There are lots of ways of generating load against OBIEE [https://www.rittmanmead.com/blog/2013/03/performance-and-obiee-test-build/], but most require third party tools of varying degrees

Oracle BI Suite EE

Automated Regression Testing for OBIEE

In the first article of this series [https://www.rittmanmead.com/blog/2014/01/obiee-regression-testing-an-introduction] I explored what regression testing is, why it matters, and by breaking down the OBIEE stack into its constituent parts where it is possible to do it for OBIEE. In this posting, I explore some

Oracle BI Suite EE

Make Use of OBIEE's Command Line Tools with Reduced Exposure of Plain Text Passwords

Introduction We all love a good commandline utility. It gives us that warm feeling of control and puts hairs on our chests. Either that, or it means we can script the heck out of a system, automate many processes, and concentrate on more important matters [http://phoboslab.org/ztype/]. However,

Technical

Advanced monitoring of OBIEE with Nagios

Introduction In the previous articles in this series, I described an overview of monitoring OBIEE [https://www.rittmanmead.com/blog/2012/09/automated-monitoring-of-obiee-in-the-enterprise-an-overview] , and then a hands-on tutorial for setting up Nagios to monitor OBIEE [https://www.rittmanmead.com/blog/2012/09/an-introduction-to-monitoring-obiee-with-nagios]. Nagios is an Enterprise Systems Management tool