You can create a custom reporting service for Adobe Experience Manager (AEM) that stores AEM data. A benefit of creating a custom service is you can develop it to meet your business requirements and integrate the reporting service to use data queried from an AEM service. For example, you can create an AEM solution that queries enterprise data that a digital marketer is interested in viewing. Then you can write out the data to a report and store the report in the AEM Java Content Repository (JCR).
In this article, an option is added to the web application that lets a user specify if the queried data is written to a custom report. Consider the following AEM web application.
When an end user clicks the 'Generate Report' checkbox, the custom AEM service generates the report using the result set that is queried from MySQL. In this example, the report is generated as an Excel spreadsheet and stored in the AEM JCR, as shown in the following illustration.
Notice that the report named AEMReports.xls is stored in /content/reports in the AEM JCR. You specify the name of the report in the web application by specifying a value in the 'Report Name' field. The data that is displayed in the web application is also written to the Excel report, as shown in this illustration.