New A.A.A.R. Alfresco audit analysis and reporting v1.5 release

A.A.A.R.

A new version 1.5 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a smarter installation wizard and the compliance to the recent Pentaho 5 release (the compliance with Pentaho 4 still remain). This version makes the adoption of A.A.A.R. solution very easy and (quite) ready for the inclusion in the Pentaho marketplace. Stay tuned for new updates!

Below some useful links:

A.A.A.R. Analytics video n.1 of 10 – The main dashboard

AAAR Analytics - Video n.1 of 16 - The main dashboardImagine to analyze Alfresco data with some real interactive tools, making possible to develop your own free analysis and charts to include in your web pages, presentations or communications to your staff.

No software development, no technical skills required but a really simple user console for a knowledge worker and not a IT professional.

This is what I was thinking while I was developing the AAAR Analytics.

2013-11-06 Alfresco - Speaking BarcelonaAAAR Analytics will be released soon and I’m going to present it to the next Alfresco Summit in Barcelona. Starting from today I would like to share some videos I have developed, to better understand what the solution is and how easy is to use. With this post I share the very first video and I plan to release one video every couple of days, announced with a twit on @FrkCorti.

New A.A.A.R. Alfresco audit analysis and reporting v1.4 release

A.A.A.R.

A new version 1.4 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with a brand new logo and a complete re-styling of the reports layout.

This version introduces the settings useful to an impressive improvement, recently presented at Pentaho Community Meeting in Portugal, regarding the AAAR Analytics. Stay tuned for the details!

Here some useful links:

New A.A.A.R. Alfresco audit analysis and reporting v1.3 release

New release!

Release 1.3

Thanking to interest on the solution, a new version 1.3 of the A.A.A.R. – Alfresco audit analisys and reporting has been released with the full support to the analysis of the repository structure.

Here some useful links:

New A.A.A.R. Alfresco audit analysis and reporting v1.2 release

New release!

Release 1.2

Thanking to the contribution of some users with interesting practical cases, a new version 1.2 of the A.A.A.R. – Alfresco audit analisys and reporting has been released.

Here some useful links for the interested of you.

A.A.A.R. Alfresco audit analysis and reporting frequently asked questions

Thanking to the contribution of some users a new FAQ page for A.A.A.R. (Alfresco audit analysis and reporting) has been released. I’m sure will be usefull for most of the people are currently using the solution, in P.O.C., production environment or only to see how it works.

Waiting for your feedback to make it grow up… 🙂

Howto install Alfresco audit analysis and reporting patch from v1.0 to v1.1

In this post I would like to describe howto install the Alfresco audit analysis and reporting patch from v1.0 to v1.1 after the release announced in this post.

First of all you have to download the installation patch from the Download page on Google code.

Inside the zip file you will find the scripts and files useful to the patch:

  • AAAR_DataMart – Patch to v1.0 on ….sql – Script containing the patch for the Data Mart structure.
  • AAAR_ Kettle.sql – Script containing the E.T.L. repository structure and data (used by Pentaho Data Integration – Kettle).
  • reports.zip – Archive containing the new version of the 5 prpt files, one for each report.

Below are described the main installation steps:

  1. Replace and reconfigure the AAAR_Kettle database.
  2. Update the AAAR_DataMart database.
  3. Deploy the new version of the sample reports.

Replace and reconfigure the AAAR_Kettle database.

The first step of installation is the Pentaho Data Intergration (Kettle) ETL contained in the AAAR_Kettle database. Let’s start with tasks:

  • Using your preferred database administration client, make a backup of the AAAR_Kettle database and delete it.
  • Install again the new version of the AAAR_Kettle database following the instructions described here.

Update the AAAR_DataMart database.

With this script some index are added to the Data Mart structure to query it more faster. Let’s start with tasks:

  • Open a terminal
  • For the PostgreSQL platform use:
cd <PostgreSQL bin>
psql –U postgres -d AAAR_DataMart –f “<AAAR folder>/AAAR_DataMart - Patch to v1.0 on PostgresSQL.sql”

(use ‘psql.exe’ on Windows platform and ‘./psql’ on Linux based platforms)

  • For the MySql platform use:
cd <MySQL bin>
mysql –uroot –p<password> < “<AAAR folder>\AAAR_DataMart - Patch to v1.0 on MySQL.sql”

(use ‘mysql.exe’ on Windows platform and ‘./mysql’ on Linux based platforms)

Deploy the new version of the sample reports.

With this deployment, a new version of the sample reports are released to insure compressed times with a big quantity of audit data. Let’s start with tasks:

  • Extract ‘reports.zip’ in the ‘data-integration’ folder. ‘report.zip’ contains 5 files with ‘prpt’ extension, each one containing one Pentaho Reporting Designer report. By default, and to let the report production simpler, are saved in the default folder: ‘data-integration’.
  • For the PostgreSQL platform: check if the ‘alfresco’ user of the database has password equal to ‘alfresco’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:
    • For each prpt report in the ‘data-integration’ folder, execute what is described below.
    • Open the prpt report, one by one, with the Pentaho Reporting Designer.
    • Click on the ‘Data’ tab on the top right of the interface.
    • Right click on the JDBC:AAAR_DataMart in the Data sets.
    • Select ‘Edit Datasource’.
    • Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the PostgreSQL one because two connections are defined: one for PostgreSQL and one for Mysql.
    • Click on the pencil.
    • Modify the password.
    • (OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.
    • Save the report.
    • Remember to repeat the tasks for all the prpt reports.
  • For the MySql platform: check if the ‘root’ user of the database has password equal to ‘root’. If yes, jump to the next task otherwise you have to update the connection in all the prpt reports. To update the password of all the prpt reports, follow that tasks:
    • For each prpt report in the ‘data-integration’ folder, execute what is described below.
    • Open the prpt report, one by one, with the Pentaho Reporting Designer.
    • Click on the ‘Data’ tab on the top right of the interface.
    • Right click on the JDBC:AAAR_DataMart in the Data sets.
    • Select ‘Edit Datasource’.
    • Select the ‘AAAR_DataMart’ in the left list. Pay attention to select the MySql one because two connections are defined: one for PostgreSQL and one for Mysql.
    • Click on the pencil.
    • Modify the password.
    • (OPTIONAL) If you want to test the connection remember that it could fail even if the password it’s correct because you could need the JDBC library in the ‘lib/jdbc’ folder of your Pentaho Reporting Designer installation.
    • Save the report.
    • Remember to repeat the tasks for all the prpt reports.

That’s all!

Now everything is ok to process again the audit data in the same way it is described here.

For informations or questions, let me know.