Copy Bcs ACL To Children 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.

This code will helps you to copy a set of permissions of a Business Connectivity services Metadata Store metadata object to its child objects.

Syntax:
Copy-SPBusinessDataCatalogAclToChildren -MetadataObject <MetadataObject> [-AssignmentCollection <SPAssignmentCollection>] [-Confirm [<SwitchParameter>]] [-WhatIf [<SwitchParameter>]]
Eaxmple:
$BCSExternalSystem = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "SPLOBSystem" -ServiceContext http://gowtham.sharepoint.com -Name "SPDEVDatabase"

Conclusion

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.