https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/57549.aspxTue, 03 Aug 2010 05:05:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57549Patrick Halstead0https://www.infopathdev.com:443/forums/thread/57549.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=57549<p>Hi LMelito,</p> <p>Easiest way is to install the Qdabra&#39;s free database accelerator trial (<a title="DBXL" href="http://www.qdabra.com/en/products/DBXL.aspx">DBXL</a>) that we created back in 2004 to address this issue. It lets you quickly create a mapping between XML and SQL without writing any code and it contains a host of other features to fill gaps between InfoPath and SQL.&nbsp;There&#39;s still no other easy alternative to quickly map existing forms to SQL. You could use BCS in MOSS 2010 but it&#39;s more work to create the mappings and there are numerous issues (for example, can&#39;t easily change database or XML and update, mapping to deep table structures is also a lot of work). </p> <p>You could hire a developer to create your own Web service, but you&#39;d spend more money, the mapping wouldn&#39;t be data-driven, and it wouldn&#39;t work for all of your templates. That&#39;s one of the nice things about DBXL - it works for all templates. It also improves SharePoint submit times and supports server-side filtering for faster query to populate dropdowns. </p> <p>Looking on the bright side, at least you didn&#39;t start from a SQL connection. Then, you&#39;d have a much more difficult migration path. </p> <p>(Disclaimer: Qdabra has provided this free forum to the InfoPath online community since 2003. We don&#39;t make any money off of the forum, but we do sell a few tools at very reasonable prices. If you find value in this forum and you want to help support Qdabra while saving cost and time developing your solution, please consider trying out qRules or one of the other accelerators. Discounts are available if you like the free trial and want to send us a 2-3 sentence quote that we can use with your first name on our website. There are hundreds of happy qRules users and we will be releasing new functionality in v2.3 soon. Your purchase today enables you to free upgrades.)&nbsp;</p>https://www.infopathdev.com:443/forums/thread/57547.aspxMon, 02 Aug 2010 23:58:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:57547lmelito0https://www.infopathdev.com:443/forums/thread/57547.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=57547I have an InfoPath form (2007) that currently submits to a SharePoint (MOSS or 2010) Form Library (promotes the form fields to SharePoint columns). I was looking to create an additional data connection that would be used when the form status is complete. For this data connection, I am looking to load all of the form data into a Access or SQL database. I&#39;m having a difficult time - does anyone know how this is done?