I’ve used PowerShell scripts to import the External Content Type. It’s easy in the XML to change stuff like ServerName and Database. I’m not sure how to point to a different Secure Store String.
Actually changing the secure store name was easy in XML. Somehow, I thought I needed to do something with Guids–wrong.
However, I did notice after importing the External Content Type that I can no longer edit the connection. I can changed the connection target name in the XML before importing–but it seems strange that I cannot change the properties after I import. Â I can delete and readd one–but can’t edit the connection.
Am I missing permissions somewhere. When I create an External List, I am able to retrieve the data.
Here are my powershell commands:
$MetadataStore = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType Catalog -ServiceContext $SiteUrl
Import-SPBusinessDataCatalogModel -Identity $MetadataStore -Path “$PathtoImportFile” -force -ModelsIncluded -PropertiesIncluded -PermissionsIncluded -Verbose -ErrorAction Stop -ErrorVariable $err
