Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

Transactional database handling using AEM Forms

Avatar

Level 2

I have a requirement where we need to support transnational database. I know AEM only support content repository, but I am new to AEM forms and little confuse with the approach. In below link it says that AEM form data can be saved in repository (processed data). But E.g. if we have to select line items based upon order (real time), can we support such business logic in AEM forms. I have gone through below link but needs more details on AEM forms w.r.t. database handling:

https://helpx.adobe.com/aem-forms/6-1/aem-forms-architecture-deployment.html

1 Accepted Solution

Avatar

Correct answer by
Level 10

Using AEM Forms - you can design the form and then post the data to a custom OSGi service. Once in the OSGi service, you can process the data to meet your needs using Java APIs.

If you need to store in the JCR, you can easily do so.

See this article to learn how to use an OSGi service and a form together: 

https://helpx.adobe.com/experience-manager/using/posting-aem-6-form-data.html

Requirement is not storing AEM form data to other database, requirement is to maintain database in AEM.

From the AEM OSGi bundle, you can use JCR API to store data in the JCR: 

https://helpx.adobe.com/experience-manager/using/persisting-cq-data-java-content1.html

Hope this helps... 

View solution in original post

5 Replies

Avatar

Level 10

Do you want to persist data from AEM forums to database? AEM supports that!

Avatar

Level 2

Data capture as well as Persisting data. But as per below link it seems that it is not recommended.

https://helpx.adobe.com/aem-forms/6-1/adaptive-forms-best-practices.html#Configuringstoragefordrafts...

"Configuring storage for drafts and submitted forms data". 

My requirement is "We need to maintain procurement related database which includes managing order, purchasing order, etc. Order can have multiple line items.

Avatar

Level 2

Data capture as well as Persisting data. But as per below link it seems that it is not recommended.

https://helpx.adobe.com/aem-forms/6-1/adaptive-forms-best-practices.html#Configuringstoragefordrafts...

"Configuring storage for drafts and submitted forms data". 

My requirement is "We need to maintain procurement related database which includes managing order, purchasing order, etc. Order can have multiple line items.

Requirement is not storing AEM form data to other database, requirement is to maintain database in AEM.

Avatar

Correct answer by
Level 10

Using AEM Forms - you can design the form and then post the data to a custom OSGi service. Once in the OSGi service, you can process the data to meet your needs using Java APIs.

If you need to store in the JCR, you can easily do so.

See this article to learn how to use an OSGi service and a form together: 

https://helpx.adobe.com/experience-manager/using/posting-aem-6-form-data.html

Requirement is not storing AEM form data to other database, requirement is to maintain database in AEM.

From the AEM OSGi bundle, you can use JCR API to store data in the JCR: 

https://helpx.adobe.com/experience-manager/using/persisting-cq-data-java-content1.html

Hope this helps... 

Avatar

Level 2

Thank you very much for quick help.