Connecting LOB Via BDC using Webservices

Jan 10, 2008 at 2:01 PM
Hi all,

I’m planning to develop a MOSS Portal which is going to be business (no data manipulation) views.

My portal will be connected to LOB databases and fetch the results based on search criteria and display results in tabular format.

Below I have given the two types of approach what I’m planning to do.

Can any one suggest me,which the best approach?

Approach 1 – using BDC

I’m planning to develop the web service (because other non .NET application requires this data later) and connecting the web service through BDC for fetching the results.

For example once user enters the search criteria then, search criteria a will be passed on to BDC and BDC in turn will talk to web service to fetch the results.

Once the results are fetched then it will be displayed in Tabular format (DataGrid).

We can’t use BDC web parts because we have to some customization like on click of some columns it should take user to some detail page.So i'm planning to use datagrid.

Approach 2 – Using Web service directly

Directly query the results the web service from web part.

Inputs on this regard are highly appreciated.

Thanks and Regards,

Jan 10, 2008 at 2:02 PM
Need Help on BDC Approach!!!