Together with the recent book named “Pentaho 8 Reporting for Java Developers” (Packt Publishing) a public repository on Github has been developed with more than 40 examples with PRPT files, Maven Projects, one CDE Dashboard and a PDI Transformation. All the examples offer a complete set of demos for the 8th version of Pentaho Reporting. Read More
- Rebranding from A.A.A.R. to Alflytics.
- Complete rewrite of the whole solution.
- HyperSQL, PostgreSql and MySql support.
- Multi-value properties support.
- Support for categories and tags analytics.
- Alfresco custom models support.
- Does not require any installation or customization on Alfresco.
- Supports Alfresco v5.2+.
- Requires Pentaho Analytics platform 7.1.
What’s now? Join the Early Access Program
Now it’s your turn to use it (check the full manual here), but I would like to invite you to join the Early Access Program to test it in your environment and make it more stable and ready for the GA release.
Few weeks ago, close to the annual Pentaho Community Meeting, the Pentaho Team released the brand new Pentaho Suite v7 with a complete restyle of the layout (of course, this is only one of the improvements). This a good opportunity for me to update the step by step tutorial on how to install the Pentaho Business Analytics after the one about the past version 5.
This tutorial describes the default installation using the HSQL database for the security storage. If you want to know how to install it using MySql database instead, I suggest to check into the Official resources or in several articles around the web.
Few weeks ago, close to the annual Pentaho Community Meeting, the Pentaho Team released the brand new Pentaho Suite v7 with a complete restyle of the layout (of course, this is only one of the improvements). This a good opportunity for me to update the step by step tutorial on how to install the Pentaho Data Integration (aka Kettle) after the one about the past version 5.
It was 2012 when I started to think, and then develop, Alfresco Audit Analytics and Reporting. In few words, the idea was to integrate Alfresco ECM with Pentaho, one of the most famous Open Source Business Intelligence Platform.
Since 2014, A.A.A.R. was released into the official Pentaho Marketplace and today it is at its 4th version, with several succesfull installations and positives feedbacks from both the Alfresco and Pentaho Communities. The counter says that around 20.000 downloads has been done from the Sourceforge repository, in less than three years… not bad, I say!
As you probably know, A.A.A.R. is completely Free of Charge, and I am (proudly) the principal developer. In other words, A.A.A.R. is a case of success, even if it is not an official solution developed and supported by Alfresco.
Starting from October 2016, I joined Alfresco (as a Company) with the role of Product Evangelist… and this is a nice stuff… but:
Which is the implications for the A.A.A.R. project?
Which is the future of the A.A.A.R. analytics solution?
Will A.A.A.R. became an official Alfresco thing?
Will I continue to support, maintain and evolve A.A.A.R.?
In this post I would like to clarify these questions, to avoid any misunderstanding connected to my new role.
During the support activities on the A.A.A.R. solution, one of the most common request is about the success (or failure) of the extraction task from Alfresco. As a standard Business Intelligence solution, the extraction task is developed as a batch (called ETL process), in average executed during the night time.
How can you be sure that the extraction from Alfresco succeed or failed?
And how can you be sure that all the audit trail, the documents, the folders and workflow instances are correctly available into the analytic environment?
For those purpose, the brand new A.A.A.R. v4.4 release has been developed, together with some minor improvements you can fin detailed here in the change log.
After a stress test on a 2 milion documents repository, more than 6 milions of instances of custom types and aspects and 180.000 instances of workflows (everything on the same Alfresco instance). Together with two others different sources (a real Enterprise Record Management System and a ERP repository) the A.A.A.R. v4.3 has been released. This version has been tested on the brand new Pentaho 6.1 release, that comes with some relevant improvements on performance over JSON treatment and various other nice changes.
This release is dedicated to the incoming BeeCon event (to thank all of BeeGirls/BeeGuys for the support) and the Pentaho girls and guys for the sponsorship of the event.
As you probably know, the next 28-th and 29-th of April in Brussels, will happen the very first BeeCon. The place for the Alfresco community of professionals and enthusiasts to meet, share, learn, build, and enrich relationships.
Unfortunately this friendly event is less happy than expected, for the respect we all have for the victims of the recent tragedy. Said that, I would like to submit to your attention the brand new official agenda of the event with a lot of interesting contributions… all of them based on technical and practical topics.
I would like to personally invite all of you to talk, meet, share, learn about Content Intelligence on Alfresco and I’ll be pleased (as usual) to hear about interesting feedback about A.A.A.R., Alfresco, Pentaho and what you have done or what you would like to have from the analytics (a not only from the analytics).
Bye bye CMIS!
With the latest A.A.A.R. v4.2 release, the extraction jobs have been fully moved to Alfresco REST based calls, instead of using CMIS (great in principle, but slower for massive enquiries).
Another added feature is the management of the custom properties extraction, as showed as a brief presentation in the video below.