Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member

Using Business Connectivity Services (BCS)

From: SharePoint 2010 Essential Training

Video: Using Business Connectivity Services (BCS)

You can't get everything into SharePoint and nor do you probably want to. A typical company has many systems. You have got back end databases and SQL Server, Oracle. You have systems like PeopleSoft and SAP, mainframe applications, custom line of business applications. Those aren't going to certainly disappear and it wouldn't be practical to extract all their data to store inside SharePoint. But we do often want to get to that data and to get it into SharePoint lists and reports and dashboards. We can use something called Business Connectivity Services or BCS to connect to those external databases and those external lines of business systems.

Using Business Connectivity Services (BCS)

You can't get everything into SharePoint and nor do you probably want to. A typical company has many systems. You have got back end databases and SQL Server, Oracle. You have systems like PeopleSoft and SAP, mainframe applications, custom line of business applications. Those aren't going to certainly disappear and it wouldn't be practical to extract all their data to store inside SharePoint. But we do often want to get to that data and to get it into SharePoint lists and reports and dashboards. We can use something called Business Connectivity Services or BCS to connect to those external databases and those external lines of business systems.

Any reasonably up-to-date system that accepts a pretty standardized way of connection such as a web service or a .NET database driver, or OLE DB will allow us to connect to it using BCS. In the last version of SharePoint, SharePoint 2007, this was called the Business Data Catalog. It's been added to since then and it's certainly a little easier to deal with but that doesn't mean it's easy. You first have to understand that what we are asking SharePoint to do is a fairly difficult process indeed.

not just from a technical standpoint, but it usually has big impacts on your business itself. You are wanting SharePoint to connect to an external system, you really have to think about a few things pretty especially. First off, you need to decide exactly what data do you need access to. If you are saying I want SharePoint to connect to our customer service database, do you mean every single piece of data, or just one table, or just several fields? You should, of course, be minimizing the exposure. You should need to have access to the minimum necessary.

You want to ask questions like is this read only or read/write? In the last version of SharePoint, it was really read only. It was the only connectivity story we had, but now we can have write access to that external data as well. Who gets to use this? Are we trying to make it available to every user on every SharePoint or is it just restricted to a few people? How are you going to connect to that external system? From the technical standpoint, what user ID do you have, what password, how is that monitored, how is that taken care of, what happens if the password expires, are there any auditing or logging requirements? If we are certainly reaching in to a line of business database and changing some data, does that have any impact on the system? So a lot of that has to be discussed before you go into the next stage, which is actually creating what's called the BCS Model.

The model is a very long description of exactly how do we connect to that system, where is it, what user ID and password do we connect to, what's the data that we are interested in, what's the key to that data, how might that data relate to another piece of data. Everything is described in the minutest detail. And really while you don't need to write programming code, you will almost certainly need either database administrator or a developer to create the BCS Model for you. Now, in this version of SharePoint, we can actually use SharePoint Designer as a starting point for creating that.

You can create what's called an external content type and this can be exported as a BCS Model but you still run into the issues of how do you describe the connection, do you really understand the data that you are talking to and what you are wanting to bring into SharePoint. Once that file is defined, and I am not going to go through the process of creating a BCS Model in this course. That really is a course all on itself. That file needs to be imported into SharePoint Central Administration and must be configured by a farm administrator.

Just because it's imported, it doesn't mean it will work. They need to describe who gets permission to it, who gets read permission, who gets write permission if necessary, but once that's done, what's the impact? And that's really what I wanted to talk about here. Once your developer, your DBAs and your farm admins have created this BCS Model, and taken it into SharePoint, what do we do? Well let's take a look. What's actually possible is that you can use that business data on potentially every page in every site. I am going to go into my team site here.

I am going to make a new page just so we have some screen real estate to put this data on. I am going to call this BCSDemo. Click Create. So I have a nice blank area of content to play with. The way that you interact with the Business Connectivity Services area is by going to the Insert tab and finding the Web Parts and selecting the categories of Business Data. Most of the Web Parts here are related to that Business Connectivity Services part of the SharePoint.

Classic one here is the Business Data list. It shows me a list of data from that external source. I am going to select that and click Add. This does need to be configured because it has no idea what it's meant to be showing. So it's saying here Open the Tool pane and choose the type of data to display, and over in the Tool pane on the right -hand side, we can click this little button here that says Select External Content Type and I have a couple of different pieces defined here. I am going to select the first one, which is some information from the AdventureWorks database.

I am going to click OK and see we have got a little update bar here. It's connecting to that external database and bringing back all this information. It's looking a little ugly here but luckily this is configurable. I do need to go back into the Edit Web Part mode, because when I do that, I get a link that says Edit View that will allow me to trim the data that I am looking at. So the first question is when this connects, do you retrieve all items? Do you limit the number of item displayed? Which columns are you showing? In this case, I might just want to show Name and ProductCategoryID and I will put Name first.

Then we can have the ability to sort by one of the columns. We can decide to sort or filter and display items on one page, or display items in pages of well let's say 10 in this case, and click OK and it will take care of managing that. In this case, we are now showing in pages of 10. I can just click the little arrow to jump to the next one and that's fetching this information from that database. Of course, they can get a little more complex than this. If you look at the available Web Parts on that Business Data category, you will see things like the Business Data Related List that will allow you to connect one list to another so that when you select say a parent option in one, you will get all the child entries related to it in the other.

You can get a Business Data Item describing a single item from your list. Business Data Actions, if those have been defined in your BCS Model, you can have actions, updating, fetching, deleting against that business data. And while the complexity of working with Business Connectivity Services is all on the front end, it's all about getting it setup and working in the first place. This is really a true integration piece. If you wanting SharePoint to be the program that sits at the middle of the web of your organization and reaches into all your other applications, this is the way that you begin to do that.

Show transcript

This video is part of

Image for SharePoint 2010 Essential Training
SharePoint 2010 Essential Training

70 video lessons · 47720 viewers

Simon Allardice
Author

 
Expand all | Collapse all
  1. 1m 16s
    1. Welcome
      1m 16s
  2. 16m 34s
    1. What is SharePoint?
      8m 9s
    2. SharePoint roles
      2m 5s
    3. Accessing SharePoint
      4m 48s
    4. The SharePoint product line
      1m 32s
  3. 44m 55s
    1. What is a team site?
      2m 43s
    2. Navigating a team site
      9m 41s
    3. Using team site lists and libraries
      11m 38s
    4. Editing the home page
      9m 31s
    5. Adding a Web Part
      6m 19s
    6. Deleting a Web Part
      5m 3s
  4. 10m 53s
    1. What is a Document Workspace?
      4m 2s
    2. Creating a Document Workspace
      4m 3s
    3. Deleting a Document Workspace
      2m 48s
  5. 6m 3s
    1. What is a Meeting Workspace?
      2m 7s
    2. Creating a Meeting Workspace
      2m 40s
    3. Deleting a Meeting Workspace
      1m 16s
  6. 36m 3s
    1. Exploring the available lists
      5m 30s
    2. Creating a custom list
      8m 44s
    3. Creating a custom view
      6m 43s
    4. Working with libraries
      6m 18s
    5. Using versioning and Check In/Check Out
      8m 48s
  7. 45m 55s
    1. SharePoint and Word
      6m 6s
    2. SharePoint and Outlook
      7m 38s
    3. SharePoint and Excel
      3m 54s
    4. SharePoint and Access
      2m 58s
    5. SharePoint and InfoPath
      11m 42s
    6. SharePoint and PowerPoint
      3m 46s
    7. SharePoint and Visio
      6m 20s
    8. Using SharePoint Workspace
      3m 31s
  8. 32m 8s
    1. What is a site collection?
      3m 56s
    2. Creating a site collection
      6m 35s
    3. Creating a new site
      6m 29s
    4. Customizing a site
      7m 47s
    5. Creating a site template
      7m 21s
  9. 13m 53s
    1. Understanding permissions
      3m 33s
    2. Adding a user to a site
      5m 14s
    3. Deleting a user from a site
      1m 39s
    4. Creating a new security group
      3m 27s
  10. 31m 54s
    1. Using out-of-the-box workflows
      11m 1s
    2. Creating your own workflows with SharePoint Designer
      15m 20s
    3. Creating your own workflows with Visio
      5m 33s
  11. 40m 36s
    1. Using site templates
      5m 49s
    2. Using the web content management features
      10m 40s
    3. Using master pages
      3m 37s
    4. Creating an Enterprise Wiki
      7m 14s
    5. Sharing an Access database with Access Services
      7m 19s
    6. Working with rich media
      5m 57s
  12. 53m 9s
    1. Managing documents and records
      3m 0s
    2. What are content types?
      4m 22s
    3. Creating a content type
      11m 30s
    4. What are document sets?
      2m 12s
    5. Creating document sets
      7m 49s
    6. Creating a Document Center
      4m 37s
    7. Creating a Record Center
      8m 25s
    8. Defining information management policy
      11m 14s
  13. 15m 42s
    1. Using personal and social features
      7m 28s
    2. Creating a SharePoint blog
      2m 48s
    3. Personalizing SharePoint with tags and notes
      5m 26s
  14. 21m 22s
    1. Searching in SharePoint
      4m 26s
    2. Creating a Search Center
      8m 4s
    3. Customizing Search with keywords
      3m 30s
    4. Customizing Search with scopes
      5m 22s
  15. 47m 18s
    1. Using Excel Services
      10m 12s
    2. Creating a Business Intelligence Center
      3m 5s
    3. Using PerformancePoint Services
      12m 3s
    4. Using status indicators
      8m 10s
    5. Using the Chart Web Parts
      6m 33s
    6. Using Business Connectivity Services (BCS)
      7m 15s
  16. 1m 3s
    1. Goodbye
      1m 3s

Start learning today

Get unlimited access to all courses for just $25/month.

Become a member
Sometimes @lynda teaches me how to use a program and sometimes Lynda.com changes my life forever. @JosefShutter
@lynda lynda.com is an absolute life saver when it comes to learning todays software. Definitely recommend it! #higherlearning @Michael_Caraway
@lynda The best thing online! Your database of courses is great! To the mark and very helpful. Thanks! @ru22more
Got to create something yesterday I never thought I could do. #thanks @lynda @Ngventurella
I really do love @lynda as a learning platform. Never stop learning and developing, it’s probably our greatest gift as a species! @soundslikedavid
@lynda just subscribed to lynda.com all I can say its brilliant join now trust me @ButchSamurai
@lynda is an awesome resource. The membership is priceless if you take advantage of it. @diabetic_techie
One of the best decision I made this year. Buy a 1yr subscription to @lynda @cybercaptive
guys lynda.com (@lynda) is the best. So far I’ve learned Java, principles of OO programming, and now learning about MS project @lucasmitchell
Signed back up to @lynda dot com. I’ve missed it!! Proper geeking out right now! #timetolearn #geek @JayGodbold
Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.


Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ.

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.


Mark all as unwatched Cancel

Congratulations

You have completed SharePoint 2010 Essential Training.

Return to your organization's learning portal to continue training, or close this page.


OK
Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member?

Become a member to like this course.

Join today and get unlimited access to the entire library of video courses.

Get started

Already a member?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any lynda.com page and choose Site preferencesfrom the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Are you sure you want to delete this note?

No

Your file was successfully uploaded.

Thanks for signing up.

We’ll send you a confirmation email shortly.


Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from lynda.com.

Sign up and receive emails about lynda.com and our online training library:

Here’s our privacy policy with more details about how we handle your information.

   
submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.