Technet Radio SharePoint BCS Throttling

I did a radio show last month with SharePoint Product Manager Bill Baer which went live yesterday. We talked about how BCS throtlling is different from large list throttling and what things one should be careful about. You can get the podcast at below given link. Hope you enjoy the show.

Searching External Systems using SharePoint 2010 Business Connectivity Services (BCS) within throttling limits

Searching External Systems using SharePoint 2010 Business Connectivity Services (BCS) within throttling limits Summary: Learn how to use SharePoint Server 2010 Business Connectivity Services (BCS) feature to search content in external system when the number of records in system are more than throttling limits defined for the system. Introduction Searching external systems with large number…


Accessing BLOB Data from External Systems Using Business Connectivity Services

Ok guys, this is a new feature which I came across while exploring BCS. BCS now supports getting BLOBs into SharePoint and provide many features which help in pulling and streaming BLOB’s out to end user. The work which I did on this has been published as a whitepaper courtsey to some folks in Redmond. Here is…


Connecting to Oracle using BCS

While browsing through BCS documentation came across this section on how to design models for connecting to Oracle. What is the support in tools to design and how to do it. Hope you will find it useful

Business Connectivity Services Client Object Model Calls

I’m writing this post as lot of people seem to have some misunderstanding how the BCS Client Object Model works. BCS client object model is different from SharePoint Client Object Model. It comes as a part of Office Professional Pro SKU and contains classes which help to consume/update data from External System using Office Clients….

BCS metadata model is case sensitive

As always whenever I find something which is small but useful, I do end up blogging about it. Yesterday, I had a strange issue with my BCS metadata model. I created an IdEnumerator against AdventureWorks database and written a query to get SalesOrders using SQL. Everything looked ok but when I was crawling the content,…

BCS Client Functionality in Microsoft Office Professional Plus 2010

Yesterday I was re-creating my farm and ran into an interesting issue with BCS client functionality. I was deploying Microsoft Office and used Professional version of the build. I have an Excel Add-In project which was working fine before I redeployed Office. The VS solution complained about missing BCS client OM dll’s. I went to…

Error Synching BCS External list to Outlook or WorkSpace

“The server must be running MOSS2010 to synchronize external list with SharePoint workspace”     I have faced this issue both in Escrow and Beta builds so thought to share it with others to make it easier. If you get the error message or having issues while synching your external list to client tools like WorkSpace…

Provision an External List using feature (BCS)

Eric shared the xml schema to provision an external list using features. I believe everyone will find it useful so sharing it.            <?xml version=”1.0″ encoding=”utf-8″?>             <Elements xmlns=””>               <ListInstance Title=”title of list”                             OnQuickLaunch=”TRUE”                             TemplateType=”104″                             FeatureId=”SharePointFeatureId”                             Url=”lists/Url”                             Description=”Description”>                 <DataSource>                   <Property Name=”LobSystemInstance” Value=”LobSystemInstance” />                   <Property Name=”EntityNamespace” Value=”EntityNamespace” />                   <Property Name=”Entity” Value=”EntityName” />                   <Property Name=”SpecificFinder”…