How to Export SharePoint 2010 External Content Types (BDC Metadata Models) to Xml File

External content types are defined through XML files referred to as “BDC metadata models”. These BDC metadata models can be created in both SharePoint Designer and Visual Studio. The technique used to create the BDC metadata models determines the technique used to export it.

  • Models created using Visual Studio can be exported directly through the SharePoint UI in a browser (via the BDC service application).
  • Models created using SharePoint Designer must be exported using SharePoint Designer

 

How to Export BDC Metadata Model using the BDC Service Application

Open SharePoint Central Administration | Application Management | Manage Service Applications

image

Select the Business Data Connectivity Service

image

Change the view drop-down to BDC Models

image

From the context menu on the BDC Model choose Export BDC Model

image

Ensure the file type is set to Model to Export

image

Select the save location. The exported file is an xml file saved with a .bdcm file extension (Visual Studio SharePoint BDC Designer File)

image

 

How to Export BDC Metadata Model using SharePoint Designer

Open the SharePoint site in SharePoint Designer and select External Content Types

bcs-01-export-bdc-metadata-model-using-sharepoint-designer

Select the External Content Type and choose the Export BDC Model ribbon button

bcs-02-export-external-content-type

Provide a name for the exported model and the settings profile to export.

image

The settings refer to the Default and Client settings profiles under on the Connection Properties.

bcs-03-export-bdc-model-settings-default-client

Select save location. The exported file is an xml file saved with a .bdcm file extension (Visual Studio SharePoint BDC Designer File)

bcs-04-export-bdc-model-save-bdcm-file

About Cameron Dwyer

Architect and developer at OnePlace Solutions. Passionate about delivering compelling solutions on the Office 365/SharePoint platform. Addicted to coffee.

Posted on August 8, 2012, in SharePoint and tagged , , , , , , , . Bookmark the permalink. 1 Comment.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: