Transactional database handling using AEM Forms | Community
Skip to main content
merajs48779722
merajs48779722
Level 2
September 11, 2016
Solved

Transactional database handling using AEM Forms

  • September 11, 2016
  • 5 replies
  • 1591 views

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

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 smacdonald2008

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

5 replies

smacdonald2008
smacdonald2008
Level 10
September 11, 2016

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

merajs48779722
merajs48779722Author
Level 2
September 13, 2016

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#Configuringstoragefordraftsandsubmittedformsdata

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

merajs48779722
merajs48779722Author
Level 2
September 13, 2016

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#Configuringstoragefordraftsandsubmittedformsdata

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

smacdonald2008
smacdonald2008Accepted solution
Level 10
September 13, 2016

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

merajs48779722
merajs48779722Author
Level 2
September 14, 2016

Thank you very much for quick help.

Terms & ConditionsAccessibility statement

Loading footer...