50015 - Building and Operating Commerce Server 2007 Solutions

This three-day instructor-led course provides students with the knowledge and skills to begin using Microsoft Commerce Server 2007. The course focuses on both developer and IT professional tasks.

After completing this course, students will be able to:

• Describe the advantages of developing solutions that are based on Commerce Server 2007
• Identify the common business scenarios in which developing a Commerce Server 2007-based solution is appropriate
• Describe the features of each Commerce Server 2007 edition
• Select the Commerce Server 2007 edition that is most appropriate for the solution
• Identify the features in earlier versions of Microsoft Commerce Server that are no longer supported in Commerce Server 2007
• Identify the components that make up the Commerce Server 2007 architecture
• Understand the information technology (IT) roles that interact with each component in the Commerce Server 2007 architecture
• Understand the different types of application programming interfaces (APIs) that Commerce Server 2007 provides
• Describe the features and purpose of each Commerce Server 2007 systems (including the Catalog and Inventory System, the Profiles System, the Customer and Orders System, and the Marketing System)
• Describe the developer components in Commerce Server 2007 (including interaction within Commerce Server, interaction with other systems, and deployment of Commerce Server 2007-based solutions)
• Understand the tasks that each customer role performs (including business users, IT professionals, administrators, developers, and business analysts)

Module 1: Microsoft Commerce Server 2007 Overview
This module provides a high-level overview of Commerce Server 2007. This includes identifying the features that are provided with each available Commerce Server edition, the architecture of Commerce Server, and the common tasks for any given role.

Lessons
• Introduction
• Identify Differences in Commerce Server 2007 Editions
• Describe the Commerce Server 2007 Architecture
• Describe the Commerce Server 2007 Systems
• Describe the Commerce Server 2007 Developer Components
• Identify Commerce Server 2007 Tasks

After completing this module, students will be able to:
• Determine the advantages of developing solutions that are based on Commerce Server 2007
• Determine the common business scenarios in which developing a Commerce Server 2007-based solution is appropriate
• Determine the customers who interact with Commerce Server 2007-based solutions
• Determine the features that each Commerce Server 2007 edition provides
• Select the Commerce Server 2007 edition that is most appropriate for the solution
• Determine the features in earlier versions of Microsoft Commerce Server that are no longer supported in Commerce Server 2007
• Describe the components that make up the Commerce Server 2007 architecture
• Determine the information technology (IT) roles that interact with each component in the Commerce Server 2007 architecture
• Describe the different types of application programming interfaces (APIs) that Commerce Server 2007 provides
• Describe the purpose of the Commerce Server 2007 systems
• Determine the features in the Commerce Server 2007 systems (including the Catalog and Inventory System, the Profiles System, the Customer and Orders System, and the Marketing System)
• Determine the developer components in Commerce Server 2007 (including interaction within Commerce Server, interaction with other systems, and deployment of Commerce Server 2007-based solutions)
• Determine the tasks that each customer role performs (including business users, IT professionals, administrators, developers, and business analysts)

Module 2: Deploying Commerce Server 2007
This module provides the prerequisite hardware and software requirements to deploy Commerce Server 2007. It also provides the steps for completing the deployment and recommends best practices for deployment.

Lessons
• Determine the Requirements to Deploy Commerce Server 2007
• Complete the Commerce Server 2007 Pre-Installation Steps
• Complete the Commerce Server 2007 Installation Steps
• Complete the Commerce Server 2007 Post-Installation Steps

Lab : Deploying Commerce Server 2007
• Verify the Hardware, Software, and Security Prerequisites
• Complete the Pre-Installation Steps
• Install Commerce Server 2007
• Complete the Post-Installation Steps

After completing this module, students will be able to:
• Determine the prerequisite hardware that is required to deploy Commerce Server 2007
• Determine the prerequisite software that is required to deploy Commerce Server 2007
• Determine the prerequisite security required to deploy Commerce Server 2007
• Describe the pre-installation steps that are required before you deploy Commerce Server 2007
• Describe the steps in deploying Commerce Server 2007
• Describe the post-installation steps that are required after you deploy Commerce Server 2007
• Verify the hardware, software, and security prerequisites to deploy Commerce Server 2007
• Perform the pre-installation steps required to deploy Commerce Server 2007
• Deploy Commerce Server 2007 by running the Commerce Server Installation Wizard
• Perform the post-installation steps required after you deploy Commerce Server 2007
• Configure Commerce Server 2007 by running the Commerce Server Configuration Wizard
• Configure the various Commerce Server 2007 systems
• Deploy the Commerce Server Starter Site by running Commerce Server Site Packager
• Perform the appropriate steps to configure the security of the solution

Module 3: Managing and Monitoring Commerce Server 2007
This module takes the student into the frontline tools that must be understood to perform day-to-day operations and the managing and monitoring of the components that enable Commerce Server to work efficiently.

Lessons
• Manage Commerce Server 2007 Solutions
• Manage Commerce Server 2007 Components
• Manage Commerce Server 2007 Sites
• Optimize Commerce Server 2007

Lab : Managing and Monitoring Commerce Server 2007
• Install the Starter Set
• Manage the Commerce Server 2007 Administration Database
• Manage Commerce Server Resources
• Manage Profiles
• Manage the Data Warehouse
• Manage Authorization Policies
• View the Starter Site

After completing this module, students will be able to:
• Determine the tools that are used in operating a Commerce Server solution
• Describe the general Web server maintenance tasks to be performed
• Determine the tasks that must be completed to manage each Commerce Server component (including the Administration database, Commerce Server resources, Commerce Server sites and applications, site packages, Profiles, and Data Warehouse)
• Determine the resources that can be used to help operate a Commerce Server solution
• Determine the tasks for managing the Administration database (including service account credentials, SQL Server credentials, and connection strings for a global or site resource)
• Determine the tasks for managing the Commerce Server resources (including site resources, global resources, and sharing resources between multiple sites)
• Determine the tasks for managing commerce sites and applications (including managing sites, managing applications, specifying the domain name for the site, and restarting IIS and Commerce Server services)
• Determine the tasks for managing site packages (including running Site Packager, automating Site Packager, and using best practices).
• Determine the tasks for managing profiles (including managing customer information by using the Profiles Schema Manager and encrypting and decrypting profiles)
• Determine the tasks for managing the Data Warehouse (including importing data, configuring and running DTS tasks, deleting data, and creating and running multitask packages)
• Determine the tasks for managing Direct Mailer (including setting up Direct Mailer, managing Direct Mailer jobs, monitoring Direct Mailer jobs, and viewing Direct Mailer job errors)
• Determine the tasks for managing authorization policies (including configuring Authorization Manager policy access, Catalog and Inventory System roles, Marketing System roles, Orders System roles, and Profiles System roles)
• Describe the steps in monitoring the availability and performance of Commerce Server
• Determine the hardware and Commerce Server performance counters to use in monitoring Commerce Server solutions
• Determine the recommended best practices for monitoring Commerce Server solutions
• Describe the steps in measuring site capacity by using Transaction Cost Analysis (TCA)
• Determine the tools and resources available for optimizing the performance of Commerce Server solutions

Module 4: Staging Content in Commerce Server 2007
This module discusses how to stage content in Commerce Server. Staging content involves moving the application from development, to the test environment, and finally to the production environment. The tools and process used in staging content are described in this module.

Lessons
• Determine the purpose of Commerce Server Staging (CSS)
• Configure, manage, and monitor CSS

Lab : Staging Content in Commerce Server 2007
• Create a Staging Project
• Stage a Web Site to Production
• Roll Back a Staged Product

After completing this module, students will be able to:
• Determine the tools to use in staging Commerce Server sites
• Determine how projects are used in CSS
• Determine how routes are used in CSS
• Determine the security requirements in CSS
• Determine the tasks for configuring the staging of Web sites to production environments (including creating projects for staging, configuring routes for staging, configuring properties for a staging project, and configuring rollbacks for staging)
• Determine how to automate CSS by using command-line utilities
• Determine the tasks for managing CSS (including controlling the staging service and changing the Commerce Server service account)
• Determine the tasks for monitoring CSS (including configuring e-mail settings, configuring event logging, and viewing staging events)

Module 5: Securing Commerce Server 2007 Solutions
This module provides information about how to help secure Commerce Server solutions. The tools and steps for completing the tasks associated with helping to secure Commerce Server are also covered. In addition, the security best practices are presented.

Lessons
• Configure Commerce Server 2007 Security
• Manage Commerce Server 2007 Security and Best Practices

Lab : Securing Commerce Server 2007 Solutions
• Create Required User Accounts and Group Accounts
• Authorize Access to Services and Resources
• Configure IIS-Related Security

After completing this module, students will be able to:
• Determine the tasks for creating the appropriate accounts that are used in helping to secure Commerce Server solutions (including accounts in Active Directory, local accounts on the computers that are running Commerce Server, and adding business user accounts to groups in Active Directory)
• Determine the tasks for authorizing access to services and resources (including assigning file permissions and folder permissions, authorizing access to Web services, authorizing permissions to update cache, granting access to Commerce Server databases, and granting the Marketing Web services access to other services)
• Determine the tasks for configuring IIS-related security (including enabling ASP, configuring application pools, configuring access to the IIS Metabase, and enabling SSL on the Web servers)
• Determine the tasks for configuring the encryption keys for the Profiles System (including determining the purpose for encryption keys, generating encryption keys, and configuring encryption keys in the Profiles System)
• Determine the tasks for setting and viewing security policies by using the SCW (including determining the purpose of the Commerce Server security template, importing the Commerce Server security template, and managing and viewing security policies by using the SCW)
• Determine the tasks for configuring security for CSS

Module 6: Developing Commerce Server 2007 Applications
This module provides an introduction into the Commerce Server development process. The module describes the high-level steps in the development process for creating a Commerce Server-based application.

Lessons
• Prepare to Develop Commerce Server 2007 Applications
• Describe Commerce Server 2007 Development Concepts
• Develop Business Pipelines

Lab : Developing Commerce Server 2007 Applications
• View the Home Page in Internet Explorer
• Review the Home Page in Visual Studio 2005

After completing this module, students will be able to:
• Determine the new development features in Commerce Server 2007
• Determine the steps to be performed by a developer in the development process
• Select the appropriate approach to use as a starting point for the application
• Determine the steps to perform after the development process is complete
• Determine the architecture components that need to be modified by developers when they create a typical application
• Describe the relationship between Commerce Server and ASP.NET
• Describe the caching technologies that are used by Commerce Server
• Describe how Commerce Server stores configuration information in SQL Server
• Describe the authentication methods that are available in Commerce Server
• Describe how access to resources is authorized in Commerce Server
• Determine the types of APIs that can be used in developing Commerce Server applications
• Describe the environment for developing Commerce Server solutions in Visual Studio (including creating a Commerce Server project, adding or modifying application resources, and running the Commerce Server tools within Visual Studio)
• Determine the international considerations in creating a Commerce Server solution (including Catalog System, Profiles System, Business Analytics System, Marketing System, and Orders System considerations)
• Determine the common problems that occur with creating connection strings for 32-bit and 64-bit computers
• Determine the common problems that occur when you develop Commerce Server pipelines and pipeline components
• Determine the purpose of pipelines in Commerce Server applications
• Determine the steps in creating and modifying pipelines by using the Pipeline Editor
• Determine the purpose of pooled pipelines in Commerce Server applications
• Describe the steps in developing pipeline components
• Describe the steps in implementing message management by using the MessageManager object
• Create a new Commerce Server application by using Visual Studio
• Create a new Commerce Server project by using Visual Studio
• Create a new pipeline for a Commerce Server application

Module 7: Developing the Catalog System
This module provides an overview of the development tasks associated with the Catalog System. The module contains a description of the development tasks and code examples for using the Catalog System APIs.

Lessons
• Introduce Catalog System Development
• Create Catalog Definitions and Schema
• Create and Manage Base and Virtual Catalogs
• Import and Export Catalog Data
• Manage Products and Categories
• Extend Catalog Features and Functionality
• Troubleshoot and Optimize the Catalog System

Lab : Developing the Catalog System
• Explore the Catalog and Inventory Schema Manager
• Explore the Catalog Manager
• Export the Catalog
• View the Top-Level Product Page in Internet Explorer
• Review Starter Site Catalog
• Review the Product Page in Visual Studio 2005

After completing this module, students will be able to:
• Determine the purpose of the Catalog System in a Commerce Server solution
• Describe the object architecture of the Catalog System
• Describe the objects that are available in the Catalog System
• Determine the authorization required for the Catalog System
• Determine how to modify the appropriate configuration files to configure the Catalog System
• Describe the steps for creating category and product definitions (including creating the CatalogContext object)
• Describe the steps for modifying the properties of product and category definitions
• Determine the differences between base and virtual catalogs
• Describe the steps for creating a base catalog
• Describe the steps for creating a virtual catalog
• Determine the purpose for importing and exporting catalog data
• Describe the steps for importing catalog data from an .xml file (including importing selected fields)
• Describe the steps for exporting catalog data to an .xml file (including exporting selected fields)
• Describe the steps for managing products (including adding and deleting products and creating product relationships)
• Describe the steps for managing categories (including adding and deleting categories and creating category relationships)
• Describe the steps for creating category hierarchies
• Describe the steps for managing product families and variants
• Describe the steps for ranking items in a catalog
• Describe the steps for browsing the catalog data
• Describe the steps for searching the catalog data
• Describe the steps for managing multilingual catalogs
• Describe the steps for managing catalog sets
• Determine common problems encountered in developing the Catalog System
• Describe the steps for configuring the Catalog System cache
• Determine the recommend best practices for improving performance in the Catalog System
• Create base catalogs
• Create virtual catalogs
• Import data into catalogs
• Create products
• Create categories
• Configure product relationships
• Create category relationships
• Create category hierarchies

Module 8: Developing the Inventory System
This module provides an overview of the development tasks associated with the Inventory System. The module contains a description of the development tasks and code examples for using the Inventory System APIs.

Lessons
• Introduce Inventory System Development
• Create and Manage Inventory Catalogs
• Import and Export Inventory Data
• Troubleshoot and Optimize the Inventory System

Lab : Developing the Inventory System
• Update Product Inventory Data
• View a Product in Internet Explorer
• Review the Product Page Design in Visual Studio 2005
• Review the Product Page Code in Visual Studio 2005

After completing this module, students will be able to:
• Determine the purpose of the Inventory System in a Commerce Server solution
• Describe the object architecture of the Inventory System
• Course Outline · Building and Operating Microsoft Commerce Server 2007 Solutions
• Describe the objects that are available in the Inventory System
• Determine the authorization required for the Inventory System
• Determine how to modify the appropriate configuration files to configure the Inventory System
• Describe the steps for creating and updating an inventory catalog (including creating the InventoryContext object)
• Describe the steps for creating a SKU
• Describe the steps for determining the current condition of a SKU
• Describe the steps for performing bulk updates and deletions
• Describe the steps for integrating the Inventory System with the Commerce Server order processing by using pipeline components
• Describe the steps for integrating the Inventory System with the other LOB applications by using BizTalk Server adapters
• Determine the purpose for importing and exporting Inventory data
• Describe the steps for importing inventory data from an .xml file
• Select the appropriate options to use when importing inventory data from an .xml file
• Describe the steps for exporting catalog data to an .xml file
• Select the appropriate options to use when exporting inventory data to an .xml file
• Determine common problems encountered in developing the Inventory System
• Determine the recommend best practices for improving performance in the Inventory System
• Create an inventory catalog
• Create the appropriate SKUs
• Determine the current condition of a SKU programmatically
• Import data into the Inventory System
• View the status of the inventory programmatically

Module 9: Developing the Profiles System
This module provides an overview of the development tasks associated with the Profiles System. The module contains a description of the development tasks and code examples for using the Profiles System APIs.

Lessons
• Introduce Profiles System Development
• Manage Profiles System Schema
• Create and Access Profile Instances
• Integrate Profiles with Microsoft ASP.NET Authentication
• Configure Site Terms
• Troubleshoot and Optimize the Profiles System

Lab : Developing the Profiles System
• Log on to Starter Site
• View Profile Information
• Review the User Login Page Design in Visual Studio 2005
• Review the User Registration Page Design in Visual Studio 2005
• Review the User Profile Page Design in Visual Studio 2005

After completing this module, students will be able to:
• Determine the purpose of the Profiles System in a Commerce Server solution
• Describe the object architecture of the Profiles System
• Describe the objects that are available in the Profiles System
• Determine the authorization that is required for the Profiles System
• Determine the tools that are used to manage the Profiles System
• Determine the tasks in encrypting fields in the Profiles System (including selecting the encryption storage format, managing the encryption and decryption keys, and encrypting files)
• Determine the schemas used in the Profiles System (including Address, BlanketPOs, CreditCard, Currency, Organization, and UserObject Profile schemas)
• Describe the steps for importing Profiles System schemas by using Commerce Server Manager
• Describe the steps for exporting Profiles System schemas by using Profiles Schema Generator
• Describe the steps for enabling multiple-valued profile properties
• Determine the differences between profiles and embedded profiles
• Describe the steps for creating and accessing profile instances
• Describe the steps for creating and accessing embedded profiles
• Determine the integration features with ASP.NET authentication
• Determine the purpose of the Commerce Server membership provider
• Describe the steps for enabling logons by using the Commerce Server membership provider
• Describe the steps for configuring account lockout for Commerce Server
• Determine the purpose of site terms
• Describe the steps for managing site terms
• Determine the international considerations for site terms
• Determine the common problems in developing the Profiles System
• Determine the recommended best practices for improving performance in the Profiles System
• Modify the profiles schema
• Configure site terms
• Create embedded profiles
• Encrypt fields in the Profiles System

Module 10: Developing the Orders System
This module provides an overview of the development tasks associated with the Orders System. The module contains a description of the development tasks and code examples for using the Orders System APIs.

Lessons
• Customer and Orders System Development
• Manage Customer and Orders System Components
• Develop Order Processing Microsoft Commerce Server 3007 Pipelines
• Map Purchase Order Runtime Objects to the Database
• Secure the Customer and Orders System

Lab : Developing the Orders System
• Log on to Starter Site
• Place Products in the Shopping Cart
• View Basket Information
• Complete Order Checkout
• View Order Information
• Review Shopping Cart Page Design in Visual Studio 2005
• Review the Order Detail Page Design in Visual Studio 2005

After completing this module, students will be able to:
• Determine the purpose of the Orders System in a Commerce Server solution
• Describe the object architecture of the Orders System
• Describe the objects that are available in the Orders System
• Determine the authorization required for the Orders System
• Determine the tools that are used to manage the Orders System
• Describe the steps for creating an OrderManagementContext object
• Describe the steps for coordinating updates to orders
• Describe the steps for managing baskets
• Describe the steps for processing basket punch-outs
• Describe the steps for converting a basket to a purchase order
• Describe the steps for saving purchase orders
• Describe the steps for retrieving purchase orders
• Determine the purpose for Orders Processing pipelines (OPP)
• Determine the default and required pipeline components
• Describe the steps for developing orders pipeline adapters
• Describe the steps for applying discounts programmatically by using Discount objects
• Describe the steps for creating multiple shipments by using Shipping objects
• Determine the purpose for mapping purchase order runtime objects to the SQL Server database
• Determine the tables in the SQL Server database
• Describe the steps for mapping purchase order runtime objects to the appropriate columns in the tables in the SQL Server database
• Describe the methods for storing sensitive Orders System information in the SQL Server database
• Describe the methods for reducing the Denial of Service (DoS) attacks performed against the Orders System
• Create the appropriate Orders System components that are based on the business and technical requirements
• Create the appropriate OPPs based on the business and technical requirements
• Store the purchase order runtime object properties in the appropriate columns in the SQL Server database

Module 11: Developing the Marketing System
This module provides an overview of the development tasks associated with the Marketing System. The module contains a description of the development tasks and code examples for using the Marketing System APIs.

Lessons
• Marketing System Development
• Develop Advertisements and Display Templates
• Develop Discounts and Promotion Codes
• Develop Direct Mail Solutions
• Develop Customized, Targeted Content Delivery

Lab : Developing the Marketing System
• Explore Marketing Manager
• Create a Campaign
• Create Expressions
• Advertise Discount to Newly Registered Users
• View the Home Page in Internet Explorer
• Review the Home Page in Visual Studio 2005
• Review the Home Page Advertisements

After completing this module, students will be able to:
• Determine the purpose of the Marketing System in a Commerce Server solution
• Describe the object architecture of the Marketing System
• Describe the objects that are available in the Marketing System
• Determine the authorization required for the Marketing System
• Determine the Authorization Manager tasks required for the methods in the Marketing System objects
• Determine the tools that are used to manage the Marketing System
• Determine the steps for developing advertisements in a Commerce Server solution (including determining the purpose of advertisements, the differences between house and paid advertisements, and the steps for displaying house advertisements instead of paid advertisements)
• Determine the steps for developing display templates in a Commerce Server solution (including determining the purpose of display templates, determining the steps for creating a display template, and determining the steps for attaching a display template to an advertisement)
• Determine the purpose of discounts and promotion codes in a Commerce Server solution
• Describe the steps in reclaiming unused promotion codes
• Describe the steps in developing discount Commerce Server Pipelines
• Describe the steps in developing promotion code pipelines
• Describe the steps in attaching promotion codes to discounts
• Describe the steps in configuring the Marketing Resource to support promotion codes
• Determine the purpose of direct mail in a Commerce Server solution
• Describe the steps in creating direct mail templates
• Describe the steps in creating direct mail pipelines
• Describe the steps in controlling direct mail from the command line
• Determine the common problems that occur with developing direct mail
• Determine the purpose of the Content Selection Framework (CSF) in a Commerce Server solution
• Describe the steps in displaying targeted content by using the ContentSelector object
• Describe the methods for optimizing the availability and performance of the CSF
• Describe the methods for extending the CSF
• Create the appropriate advertisements based on the business and technical requirements
• Create the appropriate discounts based on the business and technical requirements
• Create the appropriate promotion codes based on the business and technical requirements
• Attach the appropriate promotion codes to discounts based on the business and technical requirements
• Change the display of house or paid advertisements

Module 12: Integrating Commerce Server 2007 with Other Line of Business (LOB) Systems
This module discusses the process for integrating Commerce Server with other LOB systems by using BizTalk Server 2006 adapters. The module discusses how to use BizTalk Server adapters to create workflow orchestrations and data transfer between Commerce Server and other systems.

Lessons
• Commerce Server 2007 Line of Business (LOB) Integration
• Develop LOB Integration by Using Commerce Server 2007 Microsoft BizTalk Server Adapters
• Troubleshoot and Optimize BizTalk Server Adapters

Lab : Integrating Commerce Server with Other LOB Systems
• Enroll Commerce Server Adapters for BizTalk
• Integrate Product Catalog and Inventory

After completing this module, students will be able to:
• Determine the purpose for integrating Commerce Server with LOB systems
• Describe the architecture of the BizTalk Server adapters provided with Commerce Server
• Determine the authorization required for the BizTalk Server adapters
• Determine the tools that are used to manage the BizTalk Server adapters
• Describe the steps for adding the appropriate adapters based on the corresponding Commerce Server systems and the direction of messages
• Describe the steps for configuring the BizTalk Server adapters based on the corresponding Commerce Server systems and the direction of messages
• Describe the process for receiving and sending messages between Commerce Server and the LOB system
• Describe the steps for setting up Visual Studio to provide a BizTalk Server adapter development environment
• Describe the steps for generating the .xsd files that are required when the default schemas have changed for any one of the Commerce Server systems accessed by the BizTalk Server adapters
• Describe the methods for optimizing the performance of BizTalk Server adapters in Commerce Server
• Describe the methods for resolving concurrency issues with BizTalk Server adapters in Commerce Server
• Determine the common problems that occur with integrating by using BizTalk Server adapters and the resolution to the problems
• Add the appropriate BizTalk Server adapters, based on the Commerce Server systems to integrate and the direction of message flow
• Configure the BizTalk Server adapters, based on the Commerce Server systems to integrate and the direction of message flow
• Verify the BizTalk Server adapters are providing the desired integration and message flow between Commerce Server and the LOB system

Module 13: Migrating from Earlier Versions of Commerce Server
This module describes the methods and processes to use to upgrade from earlier versions of Commerce Server (including Commerce Server 2002 and Commerce Server 2000). The module discusses how to use the Commerce Server Migration Wizard to help in the migration process.

Lessons
• Plan for Migration
• Migrate Commerce Server Resources and Systems
• Migrate Microsoft ASP.NET-based Commerce Server 2007 Applications
• Migrate Microsoft Active Server Pages (ASP)-based Commerce Server 2002 Applications

After completing this module, students will be able to:
• Determine the changes in Commerce Server 2007 that affect migration (including site resources, site data, site code, APIs, security-related issues, Commerce Server 2002 Feature Pack 1 issues, and edition-related issues)
• Determine the use of the Commerce Server 2007 Upgrade Wizard in migrating sites
• Determine the steps in migrating global resources (including using the Commerce Server 2007 Upgrade Wizard, Data Warehouse migration tool, Data Warehouse Update Dimension Tool, and the Data Warehouse Update Tables Tool)
• Determine the steps in migrating site resources (including using the Commerce Server 2007 Upgrade Wizard)
• Determine the steps in migrating the Orders System (including using the Commerce Server 2007 Upgrade Wizard)
• Determine the steps in migrating extended the Orders System
• Determine the steps in migrating ASP.NET-connected Commerce Server 2002 applications
• Determine the best practices in migrating ASP.NET-connected Commerce Server 2002 applications
• Determine the steps in migrating ASP-based Commerce Server 2002 applications
• Determine the best practices in migrating ASP-based Commerce Server 2002 applications

Module 14: Developing the Data Warehouse and Analytics System
This module provides the information that you must have to customize the Data Warehouse and Analytics System in Commerce Server. The module covers the managing of the Data Warehouse and Analytics System components, the processes for importing data into the Data Warehouse and Analytics System, and developing reports for the Data Warehouse and Analytics System.

Lessons
• Develop the Data Warehouse and Analytics System
• Manage the Data Warehouse and Analytics Components
• Develop Microsoft Commerce Server 2007 Reports

Lab : Developing the Data Warehouse and Analytics System
• Import Data to the Data Warehouse
• View Reports

After completing this module, students will be able to:
• Determine the purpose of the Data Warehouse and Analytics System in a Commerce Server solution
• Describe the object architecture of the Data Warehouse and Analytics System
• Describe the objects that are available in the Data Warehouse and Analytics System
• Determine the authorization required for the Data Warehouse and Analytics System
• Determine the tools that are used to manage the Data Warehouse and Analytics System
• Determine the basic structures of the logical schema
• Determine the relationships between the basic structures of the logical schema
• Describe the steps for extending the Data Warehouse logical schema
• Determine the COM objects provided in the Data Warehouse and Analytics System
• Determine the business classes that are provided in the Data Warehouse and Analytics System
• Describe the steps for importing data into the Data Warehouse (by using DTS, programmatically, and by using the Data Warehouse Import Wizard)
• Describe the steps for selecting the appropriate predefined reports in the Data Warehouse and Analytics System
• Describe the steps for creating customized reports in the Data Warehouse and Analytics System
• Review the information collected by the Data Warehouse and Analytics System
• Import data into the Data Warehouse database
• Run the predefined reports in the Data Warehouse and Analytics System

Module 15: Customizing Commerce Server 2007 Business Management Applications
This module provides an overview of how to customize Commerce Server business management applications by using the Partner (SDK). This module discusses the common customizations made to the Commerce Server business management applications for most organizations. The module also discusses the customizations to the Commerce Server business management applications performed by Adventure Works, based on the business and technical requirements in the Adventure Works scenario.

Lessons
• Commerce Server 2007 Business Management Application Customization
• Customize Commerce Server 2007 Business Management Applications

Lab : Customizing the Commerce Server 2007 Business Management Applications
• Extend Catalog Management

After completing this module, students will be able to:
• Determine the purpose of the Partner SDK in developing Commerce Server solutions
• Determine the Commerce Server consoles, tools, and wizard that can be modified by using the Partner SDK
• Describe the high-level steps for customizing the consoles, tools, and wizards provided in the Partner SDK, based on the business and technical requirements for a solution
• Describe the detailed steps for customizing Catalog Manager, based on the business and technical requirement for the Adventure Works scenario
• Install and configure the Partner SDK for use in a Visual Studio development environment

This course is intended for all users of Commerce Server: IT professionals; developers; and information workers.

Before attending this course, IT Professionals must have:

• Working knowledge of Microsoft Windows Server 2003
• Working knowledge of networking topics such as TCP/IP, Domain Name System (DNS), and Microsoft Internet Information Services (IIS)
• Working knowledge of database installation and configuration
• Knowledge of Microsoft Commerce Server 2002 or Commerce Server 2000 deployment is helpful but not necessary