topic Re: AAAR creation of 'two" ETL in Alfresco Forum

AAAR creation of 'two" ETL

diwakarm — Mon, 05 Feb 2018 16:13:26 GMT

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 ple

Re: AAAR creation of 'two" ETL

fcorti — Tue, 06 Feb 2018 09:36:37 GMT

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.

Re: AAAR creation of 'two" ETL

diwakarm — Tue, 06 Feb 2018 12:42:29 GMT

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.

Re: AAAR creation of 'two" ETL

fcorti — Tue, 06 Feb 2018 13:56:40 GMT

Not a problem.
Everything is open source.
I suggest you to open the spoon UI and open Get all job.

Everything starts from there.

Re: AAAR creation of 'two" ETL

diwakarm — Wed, 07 Feb 2018 09:57:13 GMT

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!

Re: AAAR creation of 'two" ETL

fcorti — Thu, 08 Feb 2018 08:30:29 GMT

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.

Re: AAAR creation of 'two" ETL

diwakarm — Tue, 13 Feb 2018 11:06:09 GMT

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!