Batch Updates from InfoPath 2007 to SQL DB?

[josepk]

Hi All,

Thinking out of the box for a moment - in order to make my InfoPath
2007 form as simple as possible (from a development stand point) I was
thinking of not tying any SQL DB or web service calls to my InfoPath
2007 form. Instead, I was thinking it *might* be easier to have all of
the data the user submits via my InfoPath 2007 form to live within a
SharePoint forms library and then once per day, spin through all of the
newly submitted forms in the SharePoint library and place the data into
a SQL DB.

My thought is - keep the user's InfoPath 2007 form as simple as
possible - no DB or web service calls - the less in the form the less
that could break or not work - and instead leave the DB input to a
batch process that runs in the evening.

Thoughts on this?

Is it technically possible to open InfoPath 2007 forms in a SharePoint
library and programatically take the data from the form and insert it
into a SQL DB? If so, how would one go about doing this?

Adding the data to the SQL DB is critical to my process as I will be
running SQL Reporting Services against the data in the SQL DB.

Thanks,

Joe

 

[S.Y.M. Wong-A-Ton]

You should be able to use one of the web services that comes with SharePoint
to retrieve a list of the forms within a library. Once you've got that, you
can use .NET's WebClient class to download each form from the SharePoint
library and write it to the database.