How to import BDC model to the BDC Metadata Store

In this article we will be seeing how to import the BDC model to the BDC Metadata Store. Importing a BDC model is a primary way to add it to the BDC Metadata Store, and its related external content types and external systems, into a metadata store. All external content types in a model are automatically activated when you import the model.

In this article we will be seeing the following

1. Import BDC model to the BDC Metadata Store using Central Administration.
2. Import BDC model to the BDC Metadata Store using Powershell.

Import BDC model to the BDC Metadata Store using Central Administration:

1. Go to Central Administration => Application Management => Manage Service Applications => Business Data Connectivity Service Application.
2. In the BDC models group of the ribbon, click Import.
   
   
    
3. On the Import BDC model page, in the BDC Model section, click Browse to find the BDC model or resource file.
   
   
    
4. In the File Type section, select the type of BDC model file to import: Model or Resource.
5. Click on Import button.
6. BDC model will be validated.
   
   
    
7. BDC model is successfully added to the BDC metadata store.
   
   
    
8. Click on Ok.
9. In the ribbon interface, go to View tab.
   
   
    
10. In the drop down select BDC Models.
    
    
     
11. You could be able to see the imported BDC Model as shown in the following
    
    
    

Import BDC model to the BDC Metadata Store using Powershell:

1. Go to Start => All Programs => Microsoft SharePoint 2010 products => SharePoint 2010 Management Shell.
2. Run as an administrator.
3. Run the following script.
   
   $MetadataStore = Get-SPBusinessDataCatalogMetadataObject -BdcObjectType "Catalog" -ServiceContext "http://serverName:1111/hr/MP/"
   Import-SPBusinessDataCatalogModel -Path "C:\Users\222222\Desktop\BdcModel.bdcm" -Identity $MetadataStore