Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Connect external LOB data directly to SharePoint lists

  Asked By: Deborah    Date: Dec 08    Category: Sharepoint    Views: 1593

The SharePoint Business Data List Connector (BDLC) connects SharePoint lists (no
Web Parts) directly with almost any external LOB data using common list settings
with 3 easy steps:

1. Enter connection string
2. Enter select statement
3. Enter primary keys.

Fast background updates of changed data only: Alerts and workflows can be used,
to take business actions, if external data records are changed. The feature
comes with a robust installer and is available for WSS and SharePoint (all



4 Answers Found

Answer #1    Answered By: Kaitlyn Clark     Answered On: Dec 08

Is this the same kind of thing you can do with SQL Server Integration

Answer #2    Answered By: Latanya Nieves     Answered On: Dec 08

Yes, it pulls data  into a SharePoint list  destination too.
But much more efficient and without any complex configuration, mapping etc. All
this can be done directly  in the SharePoint list settings.

Only modified data is pulled into list (insert/update/delete). So alerts  and
workflows can be used  on SharePoint side for changed  items. It can be used with
any data source, that can be accessed using connection  strings (not SQL Server

Answer #3    Answered By: Vidisha Pathak     Answered On: Dec 08

SharePoint 2010 has similar thing built in.

Answer #4    Answered By: Malcolm Maxwell     Answered On: Dec 08

Yes, SharePoint Business Connectivity Services (BCS) will be much better to
manage compared to BDC in 2007 version.

But I dont find any way to import data  scheduled with workflow enabled. And -
what about Windows SharePoint Services 4.0? BCS will not be included - or? Lots
of customers out there for the BDLC

Didn't find what you were looking for? Find more on Connect external LOB data directly to SharePoint lists Or get search suggestion and latest updates.