Upgrade BDC application definition files to BCS

 BCS Meta Man, Business Connectivity Services, SharePoint 2010.

BCS Meta Man alpha 2 has a great feature that allows you to upgrade MOSS 2007 BDC application definition file to SharePoint 2010 BCS models. BCS Meta Man will automatically read in the BDC XML and create the appropriate BCS Model, BCS External Content Types and generate the necessary C# methods.

In this blog post we will show you how to upscale a BDC application definition file with BCS Meta Man.

In the first part of this blog post, we will show you how to generate a BDC application definition file with BDC Meta Man and then we will show how to upscale that application definition file with BCS Meta Man.

1) Open BDC Meta Man and connect to SQL server, use AdventureWorks database.

Step1 thumb Upgrade BDC application definition files to BCS

2) Drag and Drop Department and Employee tables to the design surface, and create an association between those two tables.

Step2 thumb Upgrade BDC application definition files to BCS

3) Set the output file path.

Step3 thumb Upgrade BDC application definition files to BCS

4) Generate the application definition file.

clip image007 thumb Upgrade BDC application definition files to BCS

Now the BDC application definition file is generated we need to create a SharePoint project in Visual Studio 2010, add a BCS Meta Man project item and upscale the BDC application definition file.

5) Open up Visual Studio 2010 and create new Empty SharePoint project.

Step5 thumb Upgrade BDC application definition files to BCS

6) Add a BCS Meta Man project item to your project. Right click on the project, choose Add new item and select BCS Meta Man item from the dialog.

Step6 thumb Upgrade BDC application definition files to BCS

7) When the project item is added to your project, BCS Meta Man’s design surface will be opened automatically. From the menu bar select BCS Meta Man – >Import BDC Xml File.

Step7 thumb Upgrade BDC application definition files to BCS

8) From the file open dialog, choose the BDC application definition file which you have already generated

Step8 thumb Upgrade BDC application definition files to BCS

9) BCS Meta Man will generate BCS external content types, C# methods and required files. All this information has been imported to BCS Model generated by BCS Meta Man.

Step9 thumb Upgrade BDC application definition files to BCS

10) Now rebuild the project and press CTRL+F5 to deploy the solution.

11) Go to your SharePoint site and add BCS List web part and BCS Related List web part to your page. Set Department as a type for List web part and Employee as a type for Related List web part, connect those two web parts together.

If you select a department in the Department List it will populate employees from that department. We’ve successfully upgraded our BDC XML to a BCS model and deployed it!

Step11 thumb Upgrade BDC application definition files to BCS

 

 

 

 

 

 

 

 

 

<hrayr/>

  1. Joe

    When will the BCS Meta Man support Web services? Will you ever support Web services with the “Import BDC Xml File” feature?

    Thanks!

     
  2. we are focusing our development efforts based on feedback so the more you shout about a feature you need the quicker we’ll get it done. If you have an idea the best thing to do is email is over to support@lightningtools.com

    Thanks
    Nick

     
  3. I’ve installed the BCS Meta Man tool to import BDC ADFs into Visual Studio 2010. My ADFs use stored procs, which I’ve created in my SQL 2010 server.
    When I try to import the BDC XML files it throws an error;
    “Invalid object name ‘Submitter’”.
    This is the name of my Entity.

    Also, does this tool support using Stored Procs as when I tried to use the BDC Data Source Explorer it didn’t pick up the stored procs, just tables and views?

     
  4. carol

    Im using BDC meta man to create the BDC app defition file for my moss 2007 site. the relationship is created ok and imported fine to the site. it can display data in business data list, but when i try to use with business data related list, it just said “unable to connect to AllawaySharepointInstance”, any idea?

     
  5. Sandar

    When I go into VS 2010 and click Add a New Item, the BCSMetaman Items don’t display. I’ve got VS 2010 and the free version of BCSMetaman installed. But the options for Add a New Item go straight from Assembly Information File to Bitmap File-No BCS Metaman options.

    What am I missing?

     

Leave a Comment

Your email address will not be published. Required fields are marked *

*

* Copy This Password *

* Type Or Paste Password Here *

*