Adaptive form best way to store the data?

[AdobeID24]

Hi folks, 

Need some suggestions over this. What would be the best way to store forms data? 

1. Inside crx some node 

2. Sql database 

3.any other? 

I have seen some articles where most of the people suggested storing the forms data inside crx is not good idea ? Is that so? What's the reason behind it?.

Please tell me some kind of real time scenerio where storing to some 3 rd party would be best idea? 

[GirishBedekar]

Any rdbms database 

[Kosta_Prokopiu1 · Accepted solution]

Hi @AdobeID24 ,

well, there are probably as many variations of how submitted data can be handled as there are integrations and solutions out there.

CRX is just one of them and suitable for Demo and Development purposes. It is a bit like saving your submitted data to a file on the file system. To fetch it again you need to know where it is and what it was called.

CRX is also not a database which means OOTB querying is limited.

You may also have security concerns if PII and sensitive data is stored, Your CRX may not be as secure as some secure data store out there (be it database or other systems).

An RDBMS is probably the better solution and you may be able to use inbuilt features of FDM and Data Sources.

Some solutions would integrate with systems such as SAP, PeopleSoft, what have you. You would then use special APIs and write custom services.

In short: It depends on what you need to do with the data once it is submitted.

Look around in Experience League - there are articles regarding data submission from Adaptive Forms.

Kosta

[Mayank_Gandhi]

@AdobeID24 for dev/testing :CRX

For production: Any RDBMS(inbuilt integrations)

FTP: If data is to be kept in files(Custom code required) 

[manu-gupta]

well it depends on what you will do with data stored. Will it further processed to :

1. any CRM system, - in case you need Customer profiling and start customer engagement from other channels

2. any archival system - just no other processing

3. any reporting tool - extract to get reports on various actions

4. any internal application will be further extracting it. - preferrably DB will be a choice for other internal applications to extract data using queries

5. Sending to AEP - for any Customer profiling and start customer engagement from other channels

based on that you can define where you will submit to. 

Thanks

Manu