Hi,

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