Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Creating a Custom Reporting Service for Adobe Experience Manager

smacdonald2008
Level 10
Level 10

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).

This development article extends an AEM application that is built by following another AEM development article that queries data from MySQL using a DataSourcePool. Before following this article, create the DataSourcePool application by following this article: Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle.

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.

[img]AEMApp.png[/img]

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.

[img]ReportJCR.png[/img]

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.

[img]sheet.png[/img]

To read this development article, click Creating a Custom Reporting Service for Adobe Experience Manager.

0 Replies