The scenario that we are going to build is a Vacation Request Approval System using InfoPath, BizTalk, and SharePoint 2010 Foundation. An employee will fill out the form and submit it to a Forms Library in SharePoint where it will be ready for approval by the employee's supervisor. Once the vacation has been approved, BizTalk will consume this form, archive it, and then use the FILE adapter to deliver the approved Vacation Request to an ERP system. The ERP system requires this information to be in a Comma Separated Value (CSV) file.
Note
Note: The examples in this chapter assume you have an existing SharePoint site in place. The following links describe how to create SharePoint sites for WSS 3.0 SP2 and SharePoint 2010 Foundation:
WSS 3.0 SP2:
http://technet.microsoft.com/en-us/library/cc288969(office.12).aspx
SharePoint 2010 Foundation:
http://technet.microsoft.com/en-us/library/cc263094.aspx
The foundation for this solution is a schema called InfoPath_Vacation_Approval...