Reporting and InfoPath 2010

[Pedro Nunez]

Does anyone know if in 2010 a different approach to the following is possible
for storing data for later reporting?: create their InfoPath solution from
SQL Server and then enable the form to submit to both SQL Server and Windows
Sharepoint in order to have the raw data in SQL Server (for reporting, for
example) and the XML-Form data in Sharepoint.

 

[Ben Walters]

Hey Pedro,
While I don't know of any specific features, I would suggest the best
approach for this type of solution would be to have the form submit to
SharePoint and then to a web service to then be stored in SQL. You do
however run the risk of having 2 sources of the truth for a single form, so
you'll want to ensure that the form stored within SharePoint is locked down
to prevent any discrepancies.

Hope this helps
Cheers
Ben Walters