nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

AAAR creation of 'two" ETL

diwakarm

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.

Find more posts tagged with

Alfresco Content Services

Accepted answers

diwakarm

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.

All comments

fcorti

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.

diwakarm

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.

fcorti

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

Everything starts from there.

diwakarm

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!