Using BCS and External Content Types in SharePoint 2010 To Bring Contacts In and Connect To Outlook 2010

Home > Blogs > SharePoint > Using BCS and External Content Types in SharePoint 2010 To Bring Contacts In and Connect To Outlook 2010

Using BCS and External Content Types in SharePoint 2010 To Bring Contacts In and Connect To Outlook 2010

Like This Blog 0 Spike Xavier
Added by June 15, 2012

We will use SharePoint Designer 2010 to create an external content type. This will be connected to the customers table in NorthWind and will allow for the creation of a new external list. We will add the functionality of being able to connect this list to Outlook by mapping the customers from NorthWind to the Office Content Type of Contact.

Open SharePoint Designer



I start with an out of the box site collection using the Team Site as the top level site Template. I Choose Site Actions>Edit in SharePoint Designer to opent SharePoint Designer 2010.

External Content Types


I choose External Content Types in the Navigation Pane of SharePoint Designer 2010.

New External Content Type


I click on the External Content Type Icon in the Ribbon which is how I will create a new External Content Type. Since this is my development Server I have several already created but I will create a new one here.

Name External Content Type


I click the Link in the Name area to name this external content type. I name it NorthWindCustomers, I also name the Display Name the same thing.

Office Item Type


I click the drop down menu for Office Item Type and select Contact.

Sync Enabled


I make sure that the Office Sync for external list is set to Enabled.

Discover External Data Sources


I click the link to discover external data sources

Add Connection


I click the Add Connection button.

Choose Data Source Type


I select SQL Server from the drop down list since I'm connecting to a SQL Server Database.

SQL Server Connection


I Fill in the SQL Server Connection Modal Window text boxes as appropriate and click OK. In this case the instance of SQL Server that I have NorthWind on is sharepoint that's why i added .\sharepoint to the Database Server text box. In other environments this would be different in most cases.

Expand NorthWind Customers


I click the + sign next to NorthWind Customers to expand it.

Expand Tables


I click the + sign next to Tables to expand it.

Create All Operations


I right click on the Customers table and choose Create All Operations.

Operation Properties Wizard


On the first page of the Operation Properties Wizard I click Next.

Map Customer ID


With CustomerID selected in Data Source Elements I click the drop down menu for Office Property and map to the Office CustomerID property.

Map Company Name


I set the CompanyName mapping as shown.




I map the ContactName field as shown.




I map the ContactTitle Field as shown.




I map the Address as shown.




I map the City field as shown.




I map the Region field as shown.




I map the PostalCode Field as shown.




I map the Country Field as shown. (I map it to the mailing address region country)




I map the Phone Field as shown.




I map the Fax Field as shown. I then click Next.

Filter Parameters Configuration 



I do not add a filter parameter but if this database table with over 2000 or so items I would add a filter parameter to avoid exceeding my list view threshold which would result in an error when the web part tried to render. So I click Finish.




It's very important to remember to hit save in the quick access toolbar (I have forgotten many times…) after I'm sure it's done saving I close SharePoint Designer.

Central Administration 



At this point a farm administrator needs to configure permissions to the external content type. This is really a separate blog so i'll just show the finished screenshot.

Create a New List 



There are many ways to do this but I'll click Site Actions>More Options

Choose External List 



I filter by list and choose External List for the template. Then I click Create.

Name List Choose ECT 



I'll name the list NorthWindCustomers and enter NorthwindCustomers in the External Content Type Field and click CTRL + K to do a lookup and fill in the value. Then I click Create.

Connect To Outlook


I click the Connect to Outlook Icon in the ribbon.

Verify Results


I clicked o.k. to a couple of modal windows that i was too slow to capture and BAM the contacts are in outlook!!!!!
All with NO CODE by the way!!!



Videos You May Like

Creating Users and Managing Passwords in Microsoft Office 365

0 769 4

In this Office 365 training video, instructor Spike Xavier demonstrates how to create users and manage passwords in Office 365.   For instructor-led Office 365 training classes, see our course schedulle: Spike Xavier SharePoint Instructor – Interface Technical Training Phoenix, AZ 20347: Enabling and Managing Office 365    

Using Navigation Controls in a Collaboration Site in SharePoint

0 352 1

In this SharePoint training video, I want to talk about the Navigation Controls in SharePoint. They tend to fall into two kind of different categories; one with the navigation controls in a typical Collaboration Site such as a Team Site or a Project Site. These are Sites that are based on the Team Site Template … Continue reading Using Navigation Controls in a Collaboration Site in SharePoint

How to Use SharePoint Navigation Controls in a Publishing Site

0 234 2

For more SharePoint training videos in this series, see: Part 1 – Using Navigation Controls in a Collaboration Site in SharePoint Part 2 – » Using Navigation Controls in a Publishing Site in SharePoint « Part 3 – Configuring SharePoint Navigation in a Publishing Site – Activating the Publishing Feature Part 4 – How to Configure Navigation in SharePoint … Continue reading How to Use SharePoint Navigation Controls in a Publishing Site

Write a Comment

Share your thoughts...

Please fill out the comment form below to post a reply.