AlfBI

Real time analytics customised for you

AlfBI is a business intelligence tool specifically designed to extend the efficiencies and outcomes of Alfresco’s internal reporting capabilities, empowering organizations to create their own individualized reports on system performance, content and workflows. Since its development, it has grown beyond the Alfresco platform, and is now highly configurable and suitable for integration to other line of business applications through its application programming interface (APIs).

The AlfBI tool includes data warehousing of raw information, which works together with a customized front end browser interface, to provide organizations with key actionable information through easy to digest analytic reporting.

Featuring clean and simple presentation formats such as tables, pie charts and other graphical visual elements, AlfBI reports can be used at any level within the organization, to help you make strategic and tactical decisions.

AlfBI features real time alerts through notification “pulses”, to help you monitor critical events and event patterns, such as when thresholds are met.

Fully supported by the Parashift team, AlfBI can be deployed on premise or in the cloud.

AlfBI Features:

  • Browsers supported
  • On premise or cloud based
  • Unlimited user licences
  • Standard customer reporting
  • Alfresco oriented reports

What is AlfBI

AlfBI is a turnkey solution for providing reporting on an Alfresco repository.

Utilising Alfresco Public API, it allows for data from the repository to be harvested and included in a seperate data warehouse.

From this data warehouse, AlfBI provides preconfigured visual web based reports, while also allowing for custom configured reports.

Alongside this, there are a couple of other features that are included to help manage content at scale:

  • Bulk Editing of Metadata via CSV Upload: allows sysadmins to make mass changes to documents
  • Document and Image Deduplication: allows users to see whether the document exists in more than one place

Why Would I need it?

There are a few use cases that AlfBI can provide a solution for:

  • You want to provide reporting in Alfresco but not have to spend the time and resources in setting it up from scratch
  • Your repository is becoming unwieldy to manage and you need some extra visualisation tools to assist in cleanup/maintenance
  • You want to be notified when a certain action happens, such a user accessing a confidential document
  • Your managers want to align some KPIs to your users based upon how they use Alfresco or what content they are ingesting
  • You have a custom content model that you want to be exposed as an SQL table but still updated/managed within Alfresco

How does it work?

AlfBI is divided into 3 components:

  • A module that is installed within Alfresco as an AMP. This module exposes some API endpoints to harvest information from Alfresco for storing in an external database
  • An Apache Camel Component which reads all of these endpoints from an Alfresco instance, and stores it within a PostgreSQL database
  • Ready made reports and dashboards for Metabase for visualisation and querying of information.

The Alfresco Module is simply installed as an AMP, and by itself exposes some endpoints to allow for an external process to collect and harvest information. These endpoints are read only restful APIs that provide information as JSON.

The following endpoints are exposed by the module:

  • nodes: Any metadata or information around documents/folders, including all custom properties
  • audit: The audit log of Alfresco, including all user actions within the system
  • system: System information including CPU, RAM, Disk Space
  • workflow: Tasks and workflows that have taken place within Alfresco

These endpoints are polled by a ready-made Apache Camel Route, which is configured to store this information into a seperate PostgreSQL database as a data warehouse. Periodically changes from the Alfresco instance are harvested, and stored within this data warehouse.