SharePoint Business Data Connectivity Service (i) Create service Application

Business Data Connectivityservice in SharePoint is a very useful feature that can easily interact with external systems (Database,web service, third-party systems) and so on, using this service. , you can import the data from the external system into the SharePoint list and make changes inside it.

First, you need to build a service application. Go to SharePoint Central Administration, and in application management, create a new business Data Connectivity Service:

As with other service application, enter database server and database name and select Windows Authentication:

It also requires a application pool, which is recommended for new pool:

This creates a success:

Click Manage on the Ribbon:

Found an error:

The reason is that the service for business Data Connectivity service is not turned on. Locate system settings->manage services on Server and start the service:

To check IIS again, if SharePoint Web Service Root does not start, start again:

This time, go to the Manage page again, so the business Data Connectivity service is built:

SharePoint Business Data Connectivity Service (i) Create service Application