Creating BCS Service Application Using PowerShell Script In SharePoint 2013

This blog will help you learn how to create a Microsoft Business Connectivity Services service application in SharePoint Server 2013.

SharePoint

SharePoint 2013 is a collaboration environment that organizations of all sizes can use to increase the efficiency of business processes.

BCS

• Business Connectivity Services is a centralized infrastructure in SharePoint 2013/2016 that supports integrated data solutions.BCS will help you to present the data in an external list.
• External lists look and feel like regular SharePoint lists, except that they can only display external data.If you want to integrate external data alongside other data in a list or library, you would use an external data column.
• External data may be in a database and it is accessed by using the out-of-the-box Business Connectivity Services connector for that database.
• BCS can also connect to data that is available through a web service.

Create a BCS using OOTB

 

If you want to create a BCS using OOTB method, open the SharePoint Central Administration website with a farm administrator account.

 

Under Application Management, select "Manage service applications".

 

At last, you have to select "New" and then click "Business Data Connectivity Service".

Powershell Method

• Open your SharePoint Management Shell.
• Copy the below code.
• Run this one.
  

  Add - PsSnapin Microsoft.SharePoint.PowerShell - ErrorAction SilentlyContinue
  # Required Details / Settings
  $ServiceName = "BCS Service"
  $ServiceProxyName = "BCS Proxy"
  $AppPoolAccount = "SPDEV\gowtham"
  $AppPoolName = "SharePoint App Pool"
  $DatabaseServer = "bcs2013"
  $DatabaseName = "BCS"
  Write - Host - ForegroundColor Yellow "Checking if Application Pool Accounts exists"
  $AppPoolAccount = Get - SPManagedAccount - Identity $AppPoolAccount - EA 0
  if ($AppPoolAccount - eq $null)
  {
      $AppPoolCred = Get - Credential $AppPoolAccount
      $AppPoolAccount = New - SPManagedAccount - Credential $AppPoolCred - EA 0
  }
  $AppPool = Get - SPServiceApplicationPool - Identity $AppPoolName - ErrorAction SilentlyContinue
  if (!$AppPool)
  {
      Write - Host - ForegroundColor Green "Creating Application Pool"
      $AppPool = New - SPServiceApplicationPool - Name $AppPoolName - Account $AppPoolAccount - Verbose
  }
  Write - Host - ForegroundColor Yellow "Checking if BCS Service Application exists"
  $ServiceApplication = Get - SPServiceApplication - Name $ServiceName - ErrorAction SilentlyContinue
  if (!$ServiceApplication)
  {
      Write - Host - ForegroundColor Green "Creating BCS Service Application"
      $ServiceApplication = New - SPBusinessDataCatalogServiceApplication– ApplicationPool $AppPool– DatabaseName $DatabaseName– DatabaseServer $DatabaseServer– Name $ServiceName
  }
  Write - Host - ForegroundColor Yellow "Starting the BCS Service"
  $ServiceInstance = Get - SPServiceInstance | Where - Object
  {
      $_.TypeName - like "*Business*"
  }
  Start - SPServiceInstance $ServiceInstance
  Write - Host - ForegroundColor Green "BCS Services Created Succesfully."

Conclusion

 

The above code will create a BCS using OOTB method.

Was my blog helpful? If yes, please let me know and if not, please explain what was confusing or missing. I’ll use your feedback to double-check the facts, add info and update this blog.