Tuesday, 20 July 2010

Guest blogger and video: SharePoint 2010 Business Connectivity Services and Offline Synchronisation

All this week we will be featuring posts from guest blogger Joel Jeffery. Joel is a Firebrand Training instructor, who is currently developing courseware for our brand new SharePoint 2010 Configuring / Administrator and Developer courses...

This post and video is all about Business Connectivity Services, which is the technology previously known as the Business Data Catalog (BDC).

The BDC in SharePoint 2007 was cool. It allowed us to create read-only forms from existing line of business, or back-end, systems - and fast. It also allowed us to index and search data in these back-end systems.

In the video I show how easy it is to work with SharePoint 2010 Business Connectivity Services. We’ll use SharePoint Designer 2010 to hook up with the Northwind database – and load a SQL table of contacts into SharePoint.

I also demonstrate how SharePoint does the hard work in creating not just read-only, but all the CRUD
(create, retrieve, update, delete) operations. It also creates InfoPath and browser forms for us, without the need to write any code. Finally, I look at the offline functionality of the BCS and SharePoint workspace, including the beauty of conflict resolution.