Posts Tagged BDC

Talking about Using the SharePoint Business Data Connectivity Designer in VS 2010 | Visual Studio Team Interviews


At work  I’m starting to build a BI Portal in SharePoint 2010.

Getting SharePoint 2010 installed has proved to be a bit of a trial. The main source of “aggravation” was in the installation of SQL Server 2008 R2. That was probably cause by a limited “admin” ID in the work production domain. I’ve not tried to explore what’s missing, but I suspect that there will be some privileges which are  missing.

I’ve yet to install PowerPivot, and see how that works with SharePoint 2010. That installation another “adventure” I’ve in store for later this week(probably next week).

One of the elements I need for this “BI Portal” is a (SharePoint) list of the Analysis Services Cubes which are going to be part of the Portal. That’s a “long” list, and best surfaced as a dynamic link into the Analysis Services Metadata (AdomdConnection.GetSchemaDataSet will list Analysis Services – Databases [Catalogs in ADOMD speak] and Cube).

To do this one needs to used a “Business Data Connectivity” (BDC) object (.NET Code which “pokes” external data into SharePoint).

The following links to the Channel 9 MSDN are highly recommended. The first video is all I needed to get up and developing a BDC (I’ll soon find out what’s missing). The second is a good series of tips about deployment and debugging BDC’s.


Using the SharePoint Business Data Connectivity Designer in VS 2010 | Visual Studio Team Interviews

Tips & Tricks with Business Data Connectivity Model Deployment in Visual Studio 2010

Technorati Tags: ,,,,,,,,,,,,,,,,,,,,

Windows Live Tags: SharePoint 2010,Visual Studio,BI Portal,installation,SQL Server 2008 R2,PowerPivot,Analysis Services,Cubes,Metadata,AdomdConnection,GetSchemaDataSet,Databases,Catalogs,ADOMD,Cube,Channel 9,MSDN,deployment,Tips,Tricks,Model

Digg This


, , ,

Leave a comment

%d bloggers like this: