Import BCS Model for External Content Types

Requirement: Import business connectivity model (.bdcm) into SharePoint

Solution: Automate the import process of business connectivity model with PowerShell Script.

Script:

####################### ENVIRONMENT VARIABLES ####################### $SiteUrl= "http://app" ##################################################################### $Catalog = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "Catalog" -Name "BCSReferenceDataModel" -ServiceContext $SiteUrl echo $model Write-Host "Importing BCS Modal..." Import-SPBusinessDataCatalogModel -Identity $Catalog -Path "C:\BCSReferenceDataModel.bdcm" -force -ModelsIncluded -PropertiesIncluded -PermissionsIncluded -Verbose -ErrorAction Stop -ErrorVariable $err