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

[arychu]

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

The 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

[smacdonald2008]

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. 

[kautuk_sahni · Accepted solution]

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

[rahul_chugh]

Thanks Everyone.