02-05-2018 08:13 AM
I have been trying to create a basic document analysis report in ACE 5.2. Following Franc blog I was able to install and configure PDI PBA and AAAR.
But am stuck at creating the ETL ,all the blogs reffers to creating two ETL ,to get the Audit from alfresco process and update into DataMart.
Can any please explain me about this process.
A practical example with such ETL will help me out.
02-06-2018 04:42 AM
Hello Franc thanks for your reply,
Your blog was really helpful, i was able to generate and view the report.
My Environment is,
Windows 7
PBA - 7
PDI -7
AAAR - 4.5
I would like to learn about the Data transformation method used to Extract Data from alfresco and transform it for reporting purposes.
As i will be working on Alfresco maintenance, i will be responsible for custom report generation,for example report on a particular document or Folder.
02-06-2018 01:36 AM
Hi Diwakar,
Can you please share your environment.
Which AAAR/Alflytics version are you using?
Which Pentaho version?
Which Operating System are you using?
Please be sure you read before the documentation below, accordingly to your version.
AAAR => How to install A.A.A.R. - Francesco Corti
Alflytics => Alflytics/Alflytics-Manual.pdf at master · fcorti/Alflytics · GitHub
Cheers.
02-06-2018 04:42 AM
Hello Franc thanks for your reply,
Your blog was really helpful, i was able to generate and view the report.
My Environment is,
Windows 7
PBA - 7
PDI -7
AAAR - 4.5
I would like to learn about the Data transformation method used to Extract Data from alfresco and transform it for reporting purposes.
As i will be working on Alfresco maintenance, i will be responsible for custom report generation,for example report on a particular document or Folder.
02-06-2018 05:56 AM
Not a problem.
Everything is open source.
I suggest you to open the spoon UI and open Get all job.
Everything starts from there.
02-07-2018 01:57 AM
That was helpful Franc.
What ever the extraction i do, it seems that Nodes Staging Failed,i guess which in turn affects the Data Quality.
Do i have to enable any other properties from alfresco side?
####alfresco-property file#######
audit.enabled = true
audit.alfresco-access.enabled=true
What understanding am missing? Kindly teach me!
02-08-2018 12:30 AM
Hi,
There is an issue on the repository extraction (this is why the Data Quality dashboard is useful because it tells you when and where the extraction went well or wrong).
Please check the catalina.out for further details on the issue.
Please open a new question if you'd want to ask more, because it is another thread.
Thanks.
02-13-2018 03:06 AM
Hello Franc,
As u said i have raised a separate thread for the Data quality.
how to view the Get all Jobs pertaining AAAR in spoon UI?.
Thanks in advance!
Explore our Alfresco products with the links below. Use labels to filter content by product module.