Adobe Experience Manager Sites & More

merajs48779722 · 9/11/16

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

smacdonald2008 · 9/13/16

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

smacdonald2008 · 9/11/16

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

merajs48779722 · 9/13/16

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.

merajs48779722 · 9/13/16