Inserting the fields value to SQL Database

Question

I have Form that i created in infopath and published it to SharePoint 2013 Could it be possible to insert the field value to SQL Database? Any help is really appreciated. Thanks in advance

Answer 1

Based on your current settings / requirements you can select the appropriate solution from the following.

1. Create an Event Receiver on your list at ItemAdded and ItemUpdated to write to SQL Database but this requires coding.

   • You can check a full example for Item added at Create a Custom List Level Event Receiver For Item Added To SharePoint 2013

2. You can work with BCS External List to read and write your data from external data source like SQL database , in this case, you can customize your forms via InfoPath as mentioned at an article on MSDN Customize External List Forms Using Microsoft InfoPath but this will need to configuration BCS and recreate your current list as External List.

3. There's another alternative solution from InfoPath (I didn't try it before) where You can use a secondary data connection to a Web service that works with that database. for more details check Add a data connection to a Microsoft SQL Server database