All posts tagged BCS

SharePoint Search – Error While Crawling LOB Contents

Recently I was configuring search to access my SQL Server data via an external content type for a demo I was presenting.  Once the content source was configured I ran the full crawl to populate the index with the data from my external source.  After about a minute the crawl was marked complete.  So naturally I am going to want to test it and make sure my data is pulling through.  The external data is a basic asset database so I did a search for one of the manufacturers I knew was in there.  Received the dreaded “Nothing here matches your search” message.

SearchNoData

Well I know there is data in there so obviously something went wrong.  I know what is wrong as I have done this before, but I want to go through some of the troubleshooting steps you can do to help determine the problem.

Read more

Playing Outside Your Sandbox Slide Deck

This weekend I had the privilege of speaking at the SharePoint Saturday Conference in Vancouver.  At the conference I spoke on no code solutions for SharePoint Business Connectivity Services and the different features you had access to out of the box.  It was a great experience and one I hope to repeat in the future.  This presentation seems quite popular as I will be giving it again at the SharePoint Saturday in Calgary and the Prairie Developers Conference in Winnipeg.

As promised for all of these sessions I have attached the slide deck here for you to download for reference.

Playing outside your sandbox

Thanks for reading.

SharePoint Business Connectivity Service – Create External Content Type and External List

Previously I have discussed SharePoint’s Business Connectivity Services specifically the External Content Type (ECT) and the External List.  Basically an ECT is a mapping of all the data that you want to surface from an external source into SharePoint.  An external list is where that ECT is surfaced into once you get it into SharePoint.  An external list is very similar to a regular SharePoint List, but some features are not available.  Some features that you don’t have include the ability to add or delete columns, quick edit, and most of the social specific features.  You can find a complete list from Microsoft here.

Today I am going to illustrate to you how to create an ECT and an external list while making use of the secure store entry I showed you how to create previously.  Today’s demo is going to be a completely “no-code” solution.  My intention is to illustrate some code based example in a later blog post, but today we are strictly doing this without writing any code.

Read more

SharePoint Secure Store – How to Create an Entry

Recently I had blogged about SharePoint’s Business Connectivity Service.  Another service which goes hand-in-hand with BCS is SharePoint’s Secure Store Service.  I talk in more detail about the Secure Store within part three of my SharePoint BCS overview series.  However, Secure Store is not limited to just BCS.  It can be used for Excel Services, Access Services and even custom applications.

Today I am going to take what I have discussed already about Secure Store and show you how to create and configure a new entry that you can then consume with another system\service.  I plan to show you how to create your secure store entry.

Read more

Playing Outside your Sandbox (Part 3) – Secure Store and BCS Authentication

Welcome to the third installment of my SharePoint BCS overview series.

If you wish to see part 2 of the series please click here.

Today I would like to discuss the different methods of authentication with Business Connectivity Services (BCS).  There are actually many ways to perform the authentication.  You can use methods such as connection strings and OData Authentication Providers.  However, if you want to go with a total no-code solution (as discussed in this series) SharePoint Secure Store Service is the way to go.  You can use a non-code solution that doesn’t make use of the Secure Store as well, and I intend to discuss, but you will soon learn why you don’t want to use this in a production environment unless your system is setup a particular way.  This post will cover those different methods of authentication as well as discuss how you can use the SharePoint Secure Store Service to help you make your BCS connections.

Read more