Winsmarts.com

Microsoft MVP

MVP Logo

Awarded the Microsoft MVP Award.

Hosted By

blah!bLaH!BLOG!!

SharePoint 2007: BDC - The Business Data Catalog

Posted on 4/24/2007 @ 5:20 AM in #Sharepoint | 9 comments | 20048 views

Tommorow evening, Carl & I will be recording Episode #4 of DNRTV:SharePoint 2007. For those who are interested, also checkout DNRTV: SharePoint #1, DNRTV: SharePoint #2, & DNRTV: SharePoint #3. BDC is one of those topics that you just have to leave back the code you used in the demos. So I am chugging out a number of blog posts this weekend describing BDC, and I will be referencing these in DNRTV. So, here goes.

What is BDC?

Microsoft definition: BDC is a new feature in MOSS 2007, it provides you with an easy way to integrate line of business data in MOSS 2007, without any code.
Sahil defintion: BDC is a really cool thing available in the relatively more expensive versions of MOSS. If anything is accessible using an ADO.NET provider, or a web service, that data can be brought into SharePoint, and then you can use it in one of the following ways -

In subsequent blogposts, I will cover the above one-by-one, and provide links to the above one by one.


On 9/17/2007 2:13:34 PM Melissa said ..
I currently have an excel spreadsheet that has one page of charts, followed by multiple tabs for the supporting work. Can you PLEASE help me find the easiest way to post that to my sharepoint site? I would truly appreciate any help you can provide!

On 1/4/2008 5:18:40 AM PANKAJ LAHOTI said ..
hai
Installed bdc meta but while getting set up i m geting eror as "ASSEMBLY NOT FOUND... AND HR,PUBLIC KEY TOKEN ......

On 2/15/2008 4:15:42 AM dhk said ..
I have the prob on xml when querying with result result ora-12704.
my bdc need to connect to oracle 8.x which the search key was defined as varchar2.
and my parameters are defined as System.String
do u khow how to solve this issue.

On 3/3/2008 4:46:32 AM Steve Clements said ..
Hi Sahil,
Can BDC be used to get data from a WCF service? If so, have you got an links to the beautiful XML that could help me!?

On 3/3/2008 10:38:44 AM Sahil Malik said ..
Steve, You can! But you have to first write the service targeting the OM. SM

On 4/29/2008 11:46:32 PM Shilpa said ..
Hi, I want to take data from Peoplesoft CRM into SharePoint. Can I do it through BDC.

On 7/10/2008 10:26:18 AM Chris Eyre said ..
The Sahil defintion is not entirely accurate.
It is rather difficult to use any ADO.NET provider.
You can use: -ODBC
-SqlServer
-OLEDB
-Oracle that's all folks! I am trying to get the BDC to talk to Sybase via the OleDb provider.
This is far more painful than it needs to be!
Even the tools don't cope with the OleDb option. Oh and in answer to the above question of can BDC call data from a WCF service - yes, expose a Webservice endpoint and suck the data in from that.

On 7/17/2008 11:10:12 AM gary b said ..

On 7/17/2008 11:11:01 AM gary b said ..

Please post your comments:


Your feedback will be submitted for moderation, and will appear after it is approved.

Name:  
Email (optional): Your email address will not be posted.
URL (optional):
Comments: HTML will be ignored, URLs will be converted to hyperlinks  
Enter the text you see in the box:
 

Site designed and maintained by Sahil Malik | All Rights Reserved. ©2007 WinSmarts.com.