Tuesday, September 24, 2013
The goal is to learn how search connectors can be used to connect to and search across external data sources using Business Connectivity Services (BCS). To extract content from a SQL database and make it searchable, we will create an external content type (ECT) using SharePoint Designer, deploy it to SharePoint, and create a new content source to crawl this External Content Type. Finally, we will perform some queries to confirm that the external content is now available to SharePoint search. Create an External Content Type (ECT) We will create a new external content type using SharePoint Designer. The external content type will point to a local SQL Server Database, AdventureWorks2012. The SQL database contains product and sales data for Adventure Works Cycles, a fictitious bicycle manufacturer and parts distributor. Open SharePoint site in SharePoint Designer 2013 Click on External content type
Verify that you now have an entry BCSHOL in the Data Source Explorer.
Expand the tree view and scroll down, and then right-click on the table Product and click Create All Operations
A wizard opens that lets you customize the parameters and filters for these operations. You will use the default values
Press Finish to accept the default values
At the right side of your screen, you should now see all the operations (Create, Read Item, Update, Delete, and Read List) on the External Content Type Operations.
In this task, you will define a title and enable a profile page for the external content type.
Click Name from the Fields list the right side of this screen, and then in the ribbon, click Set as Title.
Leave SharePoint Designer open. You will now briefly return to SharePoint Central Administration to enable and create a profile page for the new external content type.
Go to CA -> Under Application Management, click Manage service applications -> Click Business Data Connectivity Service. -> In the ribbon, if the configuration options are not visible, click the Edit tab. -> Click Configure.
Click OK -> In the Ribbon, click BROWSE. You will return to the View External Content Types page
Return to SharePoint Designer -> Create Profile Page
When prompted to Save the External Content Type now, click Yes and close designer.
In order for the new external content type to be crawled, the content access account must have
appropriate permissions. In this task, you will confirm the correct settings for these parameters.
Under View External content type
Create, Configure, And Crawl An External Content Source
CA -> Under Application Management, click Manage service applications. -> Click the link for the Search Service Application (not the proxy). -> In the left navigation, click Content Sources.