Could someone please point me to the location of where individual form response data is stored in the Epi database? I see a number of views with form data (e.g., VW_FormData_XXXXX....) but trying to map to a specific form.
Forms data is stored in Dynamic Data Store.
Have you tried using IFormDataRepository.GetSubmissionData() ?
Thanks for the response but I was actually trying to access the form data directly within the database. I'm looking to create a SQL job to extract the data into a temp table for additional processing outside of the CMS but can't locate where it s stored in the DB.
The data is stored in the DDS under the tblBigTable table
I strongly advise against accessing database directly. In case of Form, it can be quite complicated. Form is stored in DDS as Dejan and Scott mentioned, but it's not neccessarily in the tblBigTable. It can be in FormData_<Guid> table
Using the API is slower but definitely safer and more future proof
Thanks for the advice but I am only trying to extract data into another database using a job from the external database so not altering the DB directly. Any way to cross reference the form to the corresponding FormData view? I have lots of forms!
Can you not use the import export feature of forms https://webhelp.optimizely.com/15-1/EN/Content/EN/CMS%20Edit/Edit_Forms.htm#:~:text=Exporting%20forms,and%20click%20Import%20or%20Export.
If you're just trying to export and import between systems. If you want to compare you could extract to Excel instead and load the dataset or just use excel to do it
you can find the data in tblBigTable but as data get store in DDS it's not easy to fetch