<div>
Yes, it is very possible to interact with SQL using InfoPath as the front end. See if this link helps out any:<br />
<a href="http://www.databasejournal.com/features/mssql/article.php/3070881/Creating-a-SQL-Server-User-Interface-with-InfoPath.htm" rel="ugc">http://www.databasejournal.com/features/mssql/article.php/3070881/Creating-a-SQL-Server-User-Interface-with-InfoPath.htm</a><br />
&nbsp;<br />

</div>


Yes, it is very possible to interact with SQL using InfoPath as the front end. See if this link helps out any:
http://www.databasejournal.com/features/mssql/article.php/3070881/Creating-a-SQL-Server-User-Interface-with-InfoPath.htm [http://www.databasejournal.com/features/mssql/article.php/3070881/Creating-a-SQL-Server-User-Interface-with-InfoPath.htm]
 


<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
I'm very new to using InfoPath but we recently upgraded to SharePoint Enterprise 2010 and we would really like to take advantage of the new InfoPath Form Services that's available with this version of SharePoint. I need to know if it's possible to build a form that gets data from a Microsoft SQL Server, and also when that form is submitted it will need to populate a table on our Microsoft SQL Server. Is this possible when done through SharePoint? <br />
<br />
If it is, what would be the first steps that I need to take? I thought it was as simple as building a form in InfoPath2010 and just publishing it to SharePoint but I get the feeling that I need to upload some type of data connections to SharePoint Central Administration?<br />
<br />
&nbsp;Thanks in advance.
</div>
</div>


Hello, 

I'm very new to using InfoPath but we recently upgraded to SharePoint Enterprise 2010 and we would really like to take advantage of the new InfoPath Form Services that's available with this version of SharePoint. I need to know if it's possible to build a form that gets data from a Microsoft SQL Server, and also when that form is submitted it will need to populate a table on our Microsoft SQL Server. Is this possible when done through SharePoint? 

If it is, what would be the first steps that I need to take? I thought it was as simple as building a form in InfoPath2010 and just publishing it to SharePoint but I get the feeling that I need to upload some type of data connections to SharePoint Central Administration?

 Thanks in advance.

InfoPath2010 and Sharepoint 2010 integration

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

Microsoft InfoPath is a software application for designing, distributing, filling and submitting electronic forms containing structured data. The product features a WYSIWYG form designer in which the various controls (e.g. textbox, radio button, checkbox) are bound to data, represented separately as a hierarchical tree view of folders and data fields. All the data stored in InfoPath forms are stored in an XML format. Secondary data sources can be built into the form or they can be accessed through an external data connection to SharePoint or a Web service.

InfoPath

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.