Creating an External List in SharePoint by Using Business Data
- Posted: Oct 21, 2009 at 10:19 AM
- 17,322 Views
- 2 Comments
Download
How do I download the videos?
- To download, right click the file type you would like and pick “Save target as…” or “Save link as…”
Why should I download videos from Channel9?
- It's an easy way to save the videos you like locally.
- You can save the videos in order to watch them offline.
- If all you want is to hear the audio, you can download the MP3!
Which version should I choose?
- If you want to view the video on your PC, Xbox or Media Center, download the High Quality WMV file (this is the highest quality version we have available).
- If you'd like a lower bitrate version, to reduce the download time or cost, then choose the Medium Quality WMV file.
- If you have a Zune, WP7, iPhone, iPad, or iPod device, choose the low or medium MP4 file.
- If you just want to hear the audio of the video, choose the MP3 file.
Right click “Save as…”
In this interview, programming writer Norm Estabrook demonstrates how to create a model for the BDC service that returns information about contacts in a sample database, and displays the contacts in an external list. You can learn more in the corresponding Help topic.
Kathleen McGrath
Visual Studio User Education
http://blogs.msdn.com/kathleen
Comments Closed
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation,
please create a new thread in our Forums,
or
Contact Us and let us know.
Follow the Discussion
A really great lesson - from the programmers point of view.
If someone prefers a much faster and more simple out-of-the-box approach to pull external data into a SharePoint list in just minutes,
I would suggest the Business Data List Connector (BDLC) found here:
http://www.layer2.de/en/products/pages/sharepoint-business-data-list-connector.aspx
You can configure the connection directly in the custom SharePoint list settings by entering a connection string, a select statement and primary keys(s) - if any. That's it, without any programming required.
The list structure is automatically created, you can modify it later.
A timer job is used to update changed external data in the SharePoint list. Only changed data is updated (if primary keys are given).
That means, you can use list alerts and workflows, to start business actions in SharePoint, if external data records are changed.
The solution works for SharePoint (any editions) and WSS. There is a completely free shareware version for download.
Just try it out.
SharePointFrank
It maybe complicated but it is free.
The
http://www.layer2.de/en/products/pages/sharepoint-business-data-list-connector.aspx is not.
Remove this comment
Remove this thread
close