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.

    ImpBDCMod1.gif
     
  3. On the Import BDC model page, in the BDC Model section, click Browse to find the BDC model or resource file.

    ImpBDCMod2.gif
     
  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.

    ImpBDCMod3.gif
     
  7. BDC model is successfully added to the BDC metadata store.

    ImpBDCMod4.gif
     
  8. Click on Ok.
  9. In the ribbon interface, go to View tab.

    ImpBDCMod5.gif
     
  10. In the drop down select BDC Models.

    ImpBDCMod6.gif
     
  11. You could be able to see the imported BDC Model as shown in the following

    ImpBDCMod7.gif

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