InfoPath 2010 is the bridge that connects data with Office 365 business projects.
"Using the InfoPath Designer you can quickly create data connections to dynamically pull information into your forms. Convert these data connections into Universal Data Connections (UDC) files and you can even reuse them in all of your InfoPath forms. No need to recreate a data connection, just add a UDC. Best of all, UDC files help your forms function in the browser," Microsoft's Channel9.
In this video Microsoft MVP Patrick Halstead, provides an overview for using data connections and UDC files.
InfoPath 2010 Data Connections and Universal Data Connection (UDC) Files:
In this video, Jimmy Rishe, provides guidance on how to modify a WCF web service to change it from a SOAP web service to a REST web service. This will allow dynamically retrieving data from the web service simply by changing the request URL, and without the need for SOAP protocols.
InfoPath 2010 and REST-enabling a WCF Service for Consumption:
In this video, Hilary Stoupa, discusses creating InfoPath 2010 Forms that query REST Web Services. She discusses techniques for accessing RESTful services and then how to consume these in InfoPath 2010 Forms.
InfoPath 2010 and Creating a Form that Consumes a REST-enabled WCF Service:
In this video, Stoupa, discusses how to efficiently incorpoarate cascading filtering in your InfoPath 2010 Forms when accessing OData services. It's a great technique that you'll certainly want to use!
Infopath 2010, OData and Cascading Filtering in Forms: