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

31 Mar

A.A.A.R. bugfix: Invalid column for cmis:document cmis:objectid

AAAR_for_marketplace

While getting the parent path of the Alfresco nodes, the CMIS query could contain a bug in the ‘cmis:objectid’ field. Instead of ‘cmis:objectid’ should be used ‘cmis:objectId’ (pay attention to the camel case). A new FAQ has been added to the A.A.A.R. FAQ page.

I’m investigating the context because not all the environments requests that camel case format. Until than, if you have a message below:

Failed to execute script 'classpath*:alfresco/template/webscripts/org/alfresco/cmis/queries.post.cmisquery.js’:
Invalid column for cmis:document cmis:objectid

Please modify the query under ‘/Alfresco/Staging/Utility/Set folder’s children’ as described below:

select
cmis:objectId as cmis_objectid,
cmis:name as cmis_name
from
cmis:document
where
in_folder(”${cmis_parentid}”)
and cmis:lastModificationDate >= TIMESTAMP ”${cmis_last_update}”
and cmis:contentStreamLength >= 0′);

Many thanks to Micheal Fraser and Hu Ting Ung for the investigation and correction. Please, don’t stop contact me making suggestions, improvement and corrections to the solution.

03 Dec

PDI CMIS Input plugin is now compliant to Java6 and Java7

PDI CMIS Input plugin

CMIS Input plugin for Pentaho Data Integration is now compliant to Java6 and Java7. The v1.1 release, downloadable from the Pentaho Marketplace, is ready to be used with Pentaho Data Integration v4.3, v4.4 and v5.0.

Many thanks to Adrián Cadena (fugu.ec) for the contribution with the compilation of the sources and testing with Alfresco Enterprise and Community Edition.

Download CMIS Input plugin