29 Dec

Learning Alfresco Web Scripts

Learning Alfresco WebscriptsIn this post I would like to submit to you the brand new book from Packt Publishing called Learning Alfresco Web Scripts by Ramesh Chauhan. The book is easy to read with its 182 pages, full of practical examples and portion of source code.

Alfresco web scripts are fundamentals to develop a real enterprise solution for the Customers. For this reason, having a complete (and updated) guide on how to understand and properly develop them, is the core of the success of a project.

Read More

23 Dec

Review of the Pentaho Data Integration video course by Itamar Steinberg

pentaho data integration video courseIn this post I have the opportunity to share the review of a brand new Pentaho Data Integration video course by Itamar Steinberg. The full name of the course is mastering data integration (ETL) with pentaho kettle PDI and is available for purchasing on the Udemy website.

The video course is composed by 80 lectures and more then 10 hours of content. It is a walk-through of a real ETL project using Pentaho Data Integration (also known as Kettle), starting from the beginning of the design of the ETL with some easy steps that becomes more and more complex, layer by layer, as you go forward. This Pentaho Data Integration video course also cover some basic concepts of data integration and data warehouse techniques.

Read More

19 Dec

Christmas gift at 5$ from Packt Publishing

packt publishing eBook BonanzaThis is my Christmas gift for all the followers of the past years… ok, this is the Packt Publishing’s Christmas gift. After the huge success last year, the Packt $5 eBook Bonanza is back! From today until 6th Jan 2015, customers will be able to buy any eBook or Video from the Packt website for just $5! A suggestion? What about my Pentaho Reporting Video Course? 😉 Merry Christmas and happy new year!

11 Dec

Uploading a mondrian schema to Pentaho using PDI

In this post is shared the solution to upload a mondrian schema to Pentaho BA Server, using the REST API through a transformation of PDI. If you take a look to this thread of the Pentaho forum, the goal seems to be a common problem so we think it could be a good idea to share the solution with the community. I hope this post will be helpful.

Development environment

The source code is developed and tested on a Windows platform and a Linux Ubuntu 14.04 LTS platform. Pentaho BA Server and Pentaho Data Integration are both in the 5.2 version.

Use case

Starting from a file containing the mondrian schema (a XML file), our goal is to develop a PDI transformation to define a Pentaho BA Server Data Source. Of course we would like to define the data source on the mondrian schema so we would like to define a so called “Analysis Data Source”.

Read More

08 Dec

CMIS queries on Alfresco CE 5.0.c


CMIS is the most important standard for ECM interoperability. Alfresco is compliance with CMIS 1.1 with Apache Chemistry and CMIS queries are one of the most powerful way to use this ECM. In this post is shared some tests on CMIS queries on the brand new Alfresco Community Edition v5.0.c.

Description of the test environment

I have already shared the test environment I prefer to test Alfresco and CMIS. This is composed by:

  • An Alfresco v5.0.c installation. In this case I use a vanilla installation with uploaded 10K documents.
  • A Pentaho Data Integration (Kettle) v5.2 installation.
  • CMIS Input plugin for PDI to develop queries on Alfresco.

To understand how the CMIS Input plugin works, take a look at the demonstration page here.

Read More

01 Dec

A.A.A.R. v2.2 with interactive dashboards and free analysis

Finally the date came!

Starting from the requests and the collaboration of some of you, the brand new A.A.A.R. v2.2 has been released. I would like to explicitly thank strategicfunctions.com for the contribution. As usual it has been an interesting experience.

The main new feature is obviously the interactive dashboard on audit trail.

Read More