Is there any way to store Infopath form data in SQL server tables without code?

I am using InfoPath 2010 (with repeating tables) and saving .xml form in SharePoint forms library.

I am using SharePoint 2010.I want to save form's data in SQL to generate reports in future.

Please suggest possible solutions.I can not go for the coding approach.

Any solution with SSIS, BCS or web service is fine for me.

Thanks in advance.


Business Connectivity Services (BCS) is the way to store list data to SQL.

For complete implementation check:

Link1 , Link 2 , Link 3 , MSDN

| improve this answer | |

Form library forms are not stored in SQL and the format they are stored in is full of xml so you have little or no hope of reporting on them. The only way to report on Sharepoint data using SSRS is to use either external content lists (ECTs) and report on the external tables or you can use Sharepoint Custom lists which are also wrapped in xml but we use SQList by Axioworks to clean that xml. It basically copies/updates (every few seconds) all of the SP lists to a new table without the xml. Then you can report on that nice clean data.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.