Business Connectivity Services Write Back

The Business Data Catalog was often quoted as being a solution to get your Line of Business information into SharePoint. Often people wanted to be able to complete the data life cycle by also being able to write new records and update existing ones from within SharePoint 2007. This was possible with the use of BDC Meta Man and the generation of our write back web parts.

BCS and SharePoint 2010

Business Connectivity Services is now being marketted as having full write back capabilities from within SharePoint 2010 out of the box. This means your ADF model can have specific method types for inserting new records or updating existing ones, and external lists will have a built in UI for this functionality. Your insert and update statements can be any of the following:

- SQL statements
- Stored Procedures
- Web Service calls
- .NET assembly calls

BCS Meta Man will generate all of the code and BCS model you need to be able to write back to your BCS data source.