Abiquo reports with Jaspersoft

Introduction to Abiquo reporting

Abiquo reporting is designed to give you a vision of your cloud environment over time with a selection of reports for different Abiquo user profiles.
It is an integration with the Jasperserver JasperReports server.
Abiquo reports have an Abiquo theme and the integration includes a set of basic reports.
All reports support the use of parameters to control the report presentation and filter report content.
You can also create your own reports using data from the Abiquo platform.

Abiquo Support will install the Abiquo reporting module for you.

JasperReports server features:

• Web-based UI and also a web service API

• Reports can drill down into different layers of detail

• Report output in many formats (PDF, CSV, DOCX, RTF, ...)

• Report output can include charts and images

• Automatic scheduling and delivery of reports, including by email

• Users can create reports using JasperReports tools

Abiquo reporting components

The Abiquo reporting components are:

• JasperReports server repository

• JasperReports server 'theme' based on Abiquo user interface

• Jasper roles to match the Abiquo privileges system

• Authentication plugin

  • SSO token authentication OR

  • External database authentication

  • Deprecated: basic authentication

Abiquo reporting should be run with a replica of the Abiquo DBMS.

If you use external database authentication, users can access reports through the Abiquo UI or directly, as shown in the following diagram.

Open

 If you are using token authentication for SSO, users can only access the reports through the Abiquo UI.

Open

Abiquo reporting configuration

An Abiquo reporting configuration has the following general requirements and characteristics.

• Abiquo reporting will be installed on a separate server (i.e. not the Abiquo Server) because JasperReports has its own Tomcat server

• The components include: 

  • The community edition of TIBCO Jaspersoft JasperReports server, version 7.1

  • Abiquo reporting package

• Abiquo reporting requires a replica of the Abiquo database to ensure performance of on-demand reports

  • Reports use many Abiquo database tables, not just the Accounting tables

  • The plugin provides SQL row-level security for the execution of SQL statements

  • You will need a reports user for the database replica

• Abiquo supports two JasperReports authentication methods:

  • External database auth with user login

  • Token authentication for SSO

• The JasperReports server can be configured to autostart

• The SSL termination will be on the Abiquo Server Apache

  • The Abiquo reporting server will need to trust the certificates of the Abiquo server

• JasperReports has a small internal database that stores report metadata and users. This can be installed on your database server/cluster

Reports and report types

Abiquo Reporting offers several different report categories. See the Reports section of the user manual for a description of the reports.