The SharePoint search crawling component supports crawling external data hosted by business data connectivity service. For details about how to set external data sources for business data connectivity service, see: How: to create an external content type for SQL Server in SharePoint 2013, follow these steps:
Step 1: Go to the management center, Click Manage applications, click Search Service applications to go to the search management configuration page, and click content source.
Step 2: Click Create content source, name the content source, select Business Department data in the crawler content type, and select the external data to be crawled in the external data source
Step 3: Enable incremental crawling at the crawling plan point to create an incremental crawling plan. Note that full crawling crawls all content sources, and incremental crawling only accesses the content updated after the previous crawling, the newly created content source will be completely crawled once. Full crawling is much more resource-consuming than incremental crawling, so try to use incremental crawling instead of full crawling. the incremental crawling plan can be performed every 5 minutes.
Step 4: You can manually start incremental crawling and full crawling, or wait for the automatic execution of the crawling plan
Step 5: query the search results. The query results are as follows. If you click the dimcustomer title, you can view the details of this line of data.
By now, the crawler settings have been completed. to click the title of the BDC search result to display the detailed information of the row, follow these steps:
Step 6: Go to the management center, click Create website set, select Custom website set template, and select template later
Step 2: Go to the management center, Click Manage service applications, and select business data connectivity Service
Step 8: select the external content type to be configured and grant permissions to the external content type. Note that at least one person needs to have the permission to set the external content type, here I have granted everyone the execution and optional permissions on the client to facilitate testing.
Step 9: configure the external content type configuration file host, click the configuration button on the business data connectivity Service Management page, and enter the previously created website set address and click OK.
Step 10: Create/upgrade the configuration page for the external content type
Now, the BDC search configuration is complete.