0

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

0

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.

  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

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.