BDLC to use a SharePoint list as "cache"

Jul 23, 2009 at 10:08 AM

I've found another idea very helpful to integrate external data to SharePoint with full list features:

Simply enter connection string, select statement, choose primary key(s) - thats it.

The external data is "cached" in SharePoint lists, so that you can use all list features, e.g. lookups, connected web parts, even notification and workflows if external data enties are changed.
Only changed data is updated in the SharePoint list with high performance (batch update).

Possibly it solves some problems with data integration, e.g. with Office data (Excel).

Cheers, Frank