Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

Raviraj9987 — Fri, 26 Oct 2012 05:00:57 GMT

Really great walkthrough!

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

VadiveluB — Thu, 06 Oct 2011 07:05:55 GMT

Nice post!

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

fdaske — Mon, 18 Jan 2010 12:38:19 GMT

If you like the new SharePoint 2010 external list feature and the new Business Connectivity Services (BCS) and want to make use of something similar in SharePoint 2007 / WSS 3.0 to connect SharePoint lists (no web parts) directly to external data sources without any programming or tools, please take a look at:

http://www.layer2.de/en/products/Pages/SharePoint-Business-Data-List-Connector.aspx

All list features are available, e.g. grouping, lookups. You can start buiness workflow actions in SharePoint, if external data changes.

The shareware version is completely free for download and use.

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

Matt L — Sun, 03 Jan 2010 22:50:26 GMT

Nice sample. I update BDC permissions in CA too so any user could read, otherwise, was getting Access denied for all except my admin user.

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

tajeshwar singh — Tue, 08 Dec 2009 19:50:57 GMT

Divya,

I wrote this for Beta 1. What got released in Nov was Beta2.I am currently working on a exhaustive article with client OM in much detail including association and writeback to External store.

I am waiting for some things to freeze before I will do a detailed post on BCS security.

re: Consuming External data using SharePoint 2010 Business Connectivity Services(BCS) and Office Excel 2010 Add-In

Divya — Tue, 08 Dec 2009 00:35:29 GMT

Hi,

Thanks for the great walkthrough. I also saw your security post - but am hoping you could give some further details.

A couple of suggestions for others trying to make this work.

The November release - changes some screenshots (eg. Entity is now called External Content Type).

After configuring the BCS - remember to save before going to the next step of creating a list.

Before going to the Sharepoint workspace sync - please include the step to correct SQL CE (x64 to the correct version). You've got this documented in another post so a link would be fine.

In Visual Studio - you'll need to add references to make it compile. These are found in C:\program files\Microsoft Office\Office14

Microsoft.BusinessData.dll

Microsoft.Office.BusinessData.dll

Microsoft.Office.BusinessApplications.Runtime.dll