OData support for extended reporting
ALM Octane supports OData (Open Data Protocol), the OASIS REST-based standard for accessing data. You can use OData to extend and improve reporting capabilities, above and beyond the functionality provided by ALM Octane dashboard widgets. This topic provides instructions for working with OData and ALM Octane.
This overview describes the use cases for using the OData standard to access ALM Octane.
You can retrieve ALM Octane data over OData with reporting and business intelligence tools.
You can use these reporting and business intelligence tools that support OData (such as Power BI) to generate reports and charts, instead of relying only on ALM Octane dashboard widgets.
Connect to ALM Octane's OData support from the application's interface.
ALM Octane supports OData version 4.0.
Any tool that supports OData version 4.0 is likely to work well with ALM Octane.
ALM Octane OData support has been tested with Power BI and Excel.
Caution: Tableau’s support for OData is limited. For example, Tableau's OData support currently does not include the $expand interactive query argument, which ALM Octane uses extensively for cross entity reporting. Consider using a different reporting or business intelligence tool.
For OData version 4.0 support, download and install the Microsoft Power Query for Excel add-in.
Make sure the following prerequisites are met to work with OData.
- Request that the site admin or the space admin activate basic authentication with the SUPPORTS_BASIC_AUTHENTICATION configuration parameter for each space. For details, see SUPPORTED_CI_PLUGIN_SDK_VERSION.
When ALM Octane is configured with SSO, configure OData integration using API access keys. For details, see Set up API access.
Make sure that Access OData permission is granted to the appropriate role. By default, permission is enabled, but if you have created custom roles, make sure this option is enabled. For details see General System Actions in Assign roles and permissions.
The ALM Octane server base URI for accessing ALM Octane data using OData is:
Troubleshooting: If ALM Octane does not respond successfully to an OData consumer request, it might be because the base URL used to refer to ALM Octane is different than expected. Consider modifying ODATA_USE_SERVER_BASE_URL and SERVER_BASE_URL as described under Configuration parameters.
To work with OData, review the prerequisites for basic authentication under Prerequisites, and then authenticate with basic authentication.
Caution: Activating basic authentication enables external systems to access ALM Octane using this authentication method, not just OData.
You can authenticate with either:
Your user name and password.
An API access key.
For details, see Basic authentication.
Tip: When working with basic authentication, on each successful authentication, ALM Octane includes the LWSSO_COOKIE_KEY cookie in the response. We recommend that you send the LWSSO_COOKIE_KEY cookie with each subsequent OData request for enhanced performance.
Any reporting or business intelligence tool with OData support can integrate with ALM Octane, including Excel 2010 and later, Power BI, Power Query for Excel, and Power Pivot for Excel.
For a list of many of the tools that support OData, go to http://www.odata.org/ecosystem/ and click Consumers on the left.
Choose Home > Get Data > OData Feed.
Enter the ALM Octane server base URI and click OK.
Under Basic, enter the ALM Octane user name and password.
Now you can see all ALM Octane entities in the Navigator.
Choose DATA > From Other Sources > From OData Data Feed.
Enter the ALM Octane server base URI and click OK.
Select Use this name and password and enter the information.
Now you can see all ALM Octane entities.
When using OData with a secure ALM Octane server and Microsoft Excel (or other Microsoft applications, such as PowerBI), this error appears. This is because, by default, the Microsoft application does not support TLS1.2, which ALM Octane expects.
Modify your registry (using regedit.ext).
Set the SchUseStrongCrypto DWORD value in the following two registry keys to 1:
If these keys do not exist, create them.
Restart the Microsoft application.
For an Excel template that helps you create a feature quality status report using OData, see https://marketplace.microfocus.com/appdelivery/content/odata-octane-excel-feature-quality-status-report.
For a Power BI template that you can deploy and import, see https://marketplace.microfocus.com/appdelivery/content/power-bi-desktop-template-for-octane-odata.
This example demonstrates how to use Power BI to access ALM Octane data using OData. It shows, step by step, how to create a traceability report.
In Power BI, set up the data feed for ALM Octane with OData. For details, see Example of how to access ALM Octane using Power BI.
Set up a basic feed using the ALM Octane URI.
Enter the user name and password for basic authentication and click Connect.
Now we have connected and can see all ALM Octane entities. Let's start creating our report.
To see only stories, click on stories and then Edit.
We now select the columns we want to see. Click Choose Columns.
For our report, let's select the ID, name, release, and tests columns.
Releases and tests are references to other entities. We can get more information about releases and tests by clicking on the right button for each column to expand them.
Click the button for the release. We would like the name of the release, so we select name.
Similarly, click the button for tests, and then select the name and ID attributes.
Let's filter for items in release 2.2.
Click Close & Apply. Here is the result so far.
Now we will create the graph with data we select.
From the right pane:
Select the values.
Select matrix visualizations.
Arrange the rows, columns and values.
We can also add the pie chart visualization.
Save and refresh the data.