Do we need a database integration for data collection?

[Tanmay137]

Hello community users

I have come across a requirement where, we need to save incoming data from users and display that it when requested? Do you recommend database integration or any other integration to make use of the data?

Appreciate your responses.

Thanks
TanmaySingh

[smacdonald2008]

If you want to display the data later, then it makes sense to persist it. You can place that data into the JCR or a relational database.

[Tanmay137]

Thanks Scott, is there any Adobe reference document for using JCR as a database?

[kautuk_sahni · Accepted solution]

I would recommend data to be saved on JCR and persist them like Adobe Experience Manager Help | Persisting Adobe Experience Manager 5 data in the Java Content Repos... [This article was last tested on AEM 5.6, it may requires some modification and also this is anot adhering best practices as it was meant for demo use]

Later consume then by getting their values by JCR APIs like Adobe Experience Manager Help | Querying Adobe Experience Manager Data using the JCR API .

Here is the example of persisting data into MySQL Adobe Experience Manager Help | Querying and Persisting Adobe Experience Manager data into MySQL