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


Introduction

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.

Quote

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

Advertisements

, , ,

  1. Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: