Data Entry for records in AEM(backoffice) - am i thinking right?

Question

hello,we got AEM to power our next site and we are/were using Sharepoint.One thing that's missing in AEM from sharepoint is the backoffice. So lets say you need some records that needs to be shown as link or 1 record out of them to be shown on a page (massaged with extra data) etc.I think AEM doesn't provide you a way to write data in database column format, I mean you can do that & i do understand the JCR structure, what i wanted to know if i have author just filling in the blanks for data to be stored in JCR , i would have to create a page (Without components or with it) for data entry. I am taking a look at the example to use for storing customer record in JCR  https://helpx.adobe.com/experience-manager/using/persisting-cq-data-java-content1.htmlThe example shows how to persist data in JCR. is there any other way out of the box to do that in AEM.I think we might have many unique data repositories like that, wanted to know if there is an easier way or  is there already a package to do that.Thanks

kautuk_sahni · Accepted Answer

As mentioned by Scott, we can play with data accordingly with available APIs options.

Some of the example for what you have asked are listed below:

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

//Posting AEM 6 Form Data to AEM Custom Services

Link:- https://helpx.adobe.com/experience-manager/using/querying-persisting-cq-data-mysql.html

//Querying and Persisting Adobe AEM data into MySQL

Link:- https://helpx.adobe.com/experience-manager/using/aem-reporting-service.html

Link:-https://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html

//Ecxel to JCR, Creating a custom Excel Service for Adobe Experience Manager

I hope this would be of some help to you.

Thanks and Regards

Kautuk Sahni

smacdonald2008 · Answer

There are many out of the box APIs you can use in an AEM Project. The JCR API (the API that articles uses) is only one of many APIs. The API you use depends on the type of data you want to work with:

1 - you want to store data as nodes and props - use the JCR API

2 - you want to store assets in the JCR - use AssetManager

3 - you want to store data in pages - you can use SLing API

4 - you want to use data in an Excel document - you can build a custom serviec that uses JExcel API

5 - you want to store data in a relational database - you can use a DataSourcePool

SO which API you use depends on the type of data you want to work with.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded