Data Extraction for Reporting | Community
Skip to main content
A
Anonymous
July 11, 2017
Solved

Data Extraction for Reporting

  • July 11, 2017
  • 4 replies
  • 2076 views

Hi,

I'm looking to see how I can extract AEM data from a remote server, transforming it to either JSON or some other easily accessible format. Looking to do this for reporting purposes to better utilize the data we have stored on AEM. I'm looking to make this automated instead of having to physically log into the system and look for the data needed for reports.

Any and all help would be greatly appreciated!

Thanks,

Nick

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by viveksachdeva

It seems that what you want is full customization. Wondering why you need mySQL connector or for that matter any DB connector. As Scott mentioned, you should use JCR/resource API and based on the result set, you can build charts, excel or anything you like

4 replies

MC_Stuff
MC_Stuff
July 12, 2017

Hi Nick,

What kind of data you want to extract?

Thanks,

A
Anonymous
July 12, 2017

Hey MC Stuff,

I'm looking to grab report data, some tagging info, user data, and a whole bunch of other things, looking to create a sort of guided query tool so that users can access what they need without having to click through alot of AEM tabs. I'm looking into mySQL connectors as an option but am still struggling to find a good way to extract data in any way from the application.

Best,

smacdonald2008
smacdonald2008
July 12, 2017

One thing you can do is to use JCR API and build a tool that can query a result set  and export to excel -- Scott's Digital Community: Developing a Java Swing Application that displays Adobe Experience Manager Data

We build many in house tools using this approach.

viveksachdeva
Community Advisor
viveksachdevaCommunity AdvisorAccepted solution
Community Advisor
July 18, 2017

It seems that what you want is full customization. Wondering why you need mySQL connector or for that matter any DB connector. As Scott mentioned, you should use JCR/resource API and based on the result set, you can build charts, excel or anything you like

Terms & ConditionsAccessibility statement

Loading footer...