I've developed quite a few complex reports in HP ALM for my clients over the past years and found it was a good idea to let power users implement SQL reports.

With version 11.x HP introduced business views, which replace not only Excel reports but apparently the whole Dashboard in HP ALM.

Although currently working with version 12.x of HP ALM, I see that you can use business views as basis for Excel reports or Charts and other online reports in the Analysis view of the ALM Dashboard.

This means you should think about migrating your existing SQL reports into business views.

Hits: 2065

Whenever you are interested in ALM Quality Center audit history you have various choices of getting the information.

One way of extracting history information from the database is using the Excel reporting functionality of the HP ALM Quality Center Dashboard.

First create a new Excel Report in the Analysis View of the Dashboard (see documentation library of HP ALM on details how to create such a report).

In the tab Configuration you will find the Query Builder, which allows querying the underlying database server of ALM Quality Center using SQL.

This is a nice feature, if you have to apply more complex analysis. Especially analysis on history information will require accessing audit tables either through the HP ALM OTA API or through SQL or both.

Hits: 11730

Connecting to HP ALM via Java is a bit of a cumbersome task when you have never worked with a REST API before.

It is for certain not as easy as connecting to a database using a connector provided by any vendor.

Using the HP ALM REST API Examples in version 11.52

In order to use the HP ALM REST API Examples in Eclipse you will have to apply changes to some classes and even rewrite some of the tests.

I like to have simple examples, which are not hard to understand for beginners. In contrary HP provides you with an examples section, which is not easy to understand or use due to missing explanations as well as overall complexity.

First you should understand what is happening in the background when you will use the little API HP provided. The following article might help to give you an idea.

Connect to HP ALM via browser using REST API

Anyhow, let's start by setting up an example eclipse project.

Prepare HP ALM REST example project in eclipse

Create a new Java Project in eclipse called "almConnector" (or whatever you like - it does not matter).

In the src directory of this new eclipse project create three new packages.

  • alm
  • infrastructure
  • test

Now go to the HP ALM REST API reference in your ALM documentation library.

To do so when looged into a HP ALM project choose Help -> Documentation Library from the top menu bar.

Hits: 41066
  1. Connect to HP ALM via browser using REST API
  2. Split and Transpose Strings
  3. Reading big Excel files with POI
  4. Simple JavaFX File System Tree View
  • You are here:  
  • Home
  • Featured Articles