BrainDump
  Home arrow BrainDump arrow Page 2 - Microsoft BizTalk Server 2004: Creating a ...
ASP Free Forums 
.NET  
ASP  
ASP Code  
ASP.NET  
ASP.NET Code  
BrainDump  
C#  
Code Examples  
Database  
Database Code  
IIS  
Microsoft Access  
MS SQL Server  
Visual Basic.NET  
Windows Scripting  
Windows Security  
XML  
ASP Web Hosting  
ASP.NET Web Hosting 
Moblin 
JMSL Numerical Library 
Windows Web Hosting
 
IBM® developerWorks 
Sun Developer Network 
Weekly Newsletter
 
Developer Updates  
Free Website Content 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us Get Paid 
Request Media Kit
Contact Us 
Site Map 
Privacy Policy 
Support 
 USERNAME
 
 PASSWORD
 
 
  >>> SIGN UP!  
  Lost Password? 
BRAINDUMP

Microsoft BizTalk Server 2004: Creating a Schema Map
By: MSDN Virtual Labs
  • Search For More Articles!
  • Disclaimer
  • Author Terms
  • Rating: 5 stars5 stars5 stars5 stars5 stars / 6
    2005-12-22

    Table of Contents:
  • Microsoft BizTalk Server 2004: Creating a Schema Map
  • Exercise 1: Creating a Schema Map using BizTalk Mapper
  • Exercise 2: Adding Functoids to a Map
  • Exercise 3: Validating and Testing the Map

  • Rate this Article: Poor Best 
      ADD THIS ARTICLE TO:
      Del.ici.ous Digg
      Blink Simpy
      Google Spurl
      Y! MyWeb Furl
    Email Me Similar Content When Posted
    Add Developer Shed Article Feed To Your Site
    Email Article To Friend
    Print Version Of Article
    PDF Version Of Article
     
     
    ADVERTISEMENT


    Microsoft BizTalk Server 2004: Creating a Schema Map - Exercise 1: Creating a Schema Map using BizTalk Mapper


    (Page 2 of 4 )

    Scenario

    In this exercise, you will use BizTalk Mapper to create a map. This map will be used to create links that associate the data fields between two different schemas.

    Tasks

    Detailed steps

    1. Set up lab.

    1. Click inside the virtual machine window.

    2. Press Right-ALT + DEL.

    3. Type a password of pass@word1 and press Enter.

    4. Click Start | Windows Explorer and navigate to C:\Labs\Setup Scripts\SetupLab3.A.bat.

    5. Double-click the file to run it and close Windows Explorer.

    This script will erase the existing projects and artifacts in the C:\Labs\Work folder and copy all required artifacts and files for this lab into the C:\Labs\Work folder.

    1. Open an existing solution.

      This opens a project with predefined schemas (.xsd).

    1. Click Start | All Programs | Microsoft Visual Studio .NET 2003 | Microsoft Visual Studio .NET 2003.

    2. On the File menu, click Open Solution.

    3. In the Open Solution dialog box, navigate to C:\Labs\Work\NWBusinessSolution, select NWBusinessSolution.sln, and then click Open.

    A project opens in Solution Explorer.

    1. Add the destination schema to the project.

      This loads the schema for the purchase order format used by Fabrikam, Inc.

    1. In Solution Explorer, right-click the NWMessaging project, and then click Add Reference.

    2. In the Add Reference dialog box, click Browse, navigate to C:\Labs\SupportingArtifacts\FKMessaging
      \bin\Development
      , select FKMessaging.dll, and then click Open.

    3. Click OK.

    The FKMessaging reference is added to Solution Explorer.

    1. Create the BizTalk map.

      Selecting the Map template causes BizTalk Mapper to start.

    1. In Solution Explorer, right-click the NWMessaging project, point to Add, and then select Add New Item.

    2. In the Add New Item dialog box, in the Templates pane, click Map.

    3. In the Name box, type NWCustomerOrder_To_FKSupplierPO.btm to name the map.

    4. Click Open to start BizTalk Mapper.

    BizTalk Mapper opens, and the new map is added to Solution Explorer.

    1. Open the source and destination schemas.

      This prepares the Mapper’s UI to translate the source schema to the destination schema.

    1. In BizTalk Mapper, open the following schemas:

    Source schema

    Destination schema

    Schemas
      NWMessaging.CustomerOrder

    References
      FKMessaging
        Schemas
         
    FKMessaging.SupplierPO

    1. Rename the map page.

      Renaming the map page makes map management easier. It does not affect the XSLT in any way.

    1. Below the Map Zone, right-click the Page 1 tab (at the bottom of the map), and click Rename Page.

    2. Rename the page Data Maps and press Enter.

    1. Create a link between fields.

      Linking nodes in the Mapper creates XSLT that will transform the data in the source document into the structure of the destination document.

    1. Using the pairings in the table below, in the Source Schema pane, click each source field and then drag it across the Mapper grid to the associated destination field in the Destination Schema pane.

    Source Field

    Destination Field

    CustomerPONumber  

    PONumber

    UnitPrice

    Cost (under items)

    Quantity (under lines)

    Qty

    ItemID

    ProdID

    Status

    Status

    The lines in BizTalk Mapper show how the fields between schemas have been mapped, as shown here:

     

    More BrainDump Articles
    More By MSDN Virtual Labs


       · This article is from Microsoft's Virtual Labs. We hope you found it to be enjoyable...
     

    BRAINDUMP ARTICLES

    - Microsoft Office SharePoint Server
    - Microsoft Office SharePoint Designer
    - Microsoft Windows SharePoint Services 3.0
    - Microsoft Live Mesh Overview
    - XAML Brushes and Silverlight
    - Silverlight and XAML Basics
    - Immortal XP
    - XAML Basics
    - Microsoft Surface
    - Making Your First Active X Control in Visual...
    - Codes and Packages in Microsoft Project 2007
    - Windows 7: Rumors and Demos
    - XP SP3 Why Me?
    - Breaking Up Your Work in Microsoft Project
    - Breaking Work into Task-Sized Chunks





    © 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway
    Stay green...Green IT