Showing posts with label How to create Business Data Connectivity Service Application. Show all posts
Showing posts with label How to create Business Data Connectivity Service Application. Show all posts

25 March, 2014

How to create Business Data Connectivity Service Application

When we need to talk about external content type then BCS plays important role w.r.t. functionality. If BCS is not active in your farm then there will be numerous problems that you will come across so by means of this article we will build the base of external CT i.e. creation of BCS SA.

I know it’s very easy to create the service application but this article might be useful for a new bie who have just started learning SharePoint.

Here are the details:

Open the Central Administration

Application management

Manage service applications

New -> Business Data Connectivity Service

You will get the following page: 


a)   Name of the database server will be there by default,
b)   Database name will be there with long GUID: Remove this GUID and use simple & short naming convention.
c)   If you have a failover configure then you can specify the name of the server, otherwise keep it empty.

Application Pool:
a)   I would recommend you to create a new application pool option
b)   Specify the name as per your requirements
c)   Select ‘configurable’
d)   Select the account from the dropdown / If you have created a new account for this functionality then register it first and then proceed further
e)   Finally click OK



By this way, Business Data Connectivity Service application will be successfully created.

If you have any queries / questions then please let me know. I would be more than happy to assist you, Thank you.