Share via

Schema Tool

  • Article

Location in SDK: SDK\Samples\Business Analytics\Schema Tool

The Schema Tool sample is a Microsoft Visual Basic project that provides a schema browser that can be used to explore the Commerce Server Data Warehouse logical schema. You can use the Schema Tool to view the Data Warehouse classes, class properties, data members, and class relationships as they are defined in the logical schema. The following figure shows the Commerce Server Data Warehouse Schema Tool window.

Figure showing the Schema Tool window.

Ee823828.note(en-US,CS.20).gifNotes

  • Before you install the Schema Tool, Microsoft Visual Basic 6.0 or higher must be installed.
  • Before you install the Schema Tool, a Data Warehouse must exist on the computer.

To run the Schema Tool

To use the Schema Tool

To run the Schema Tool

  1. Click Start, point to Programs, point to Microsoft Visual Studio 6.0, and then click Microsoft Visual Basic 6.0.
  2. In Microsoft Visual Basic, on the File menu, click Open Project.
  3. In the Open Project dialog box, navigate to the DWSchema.vbp file located at <drive>:\Program Files\Microsoft Commerce Server 2002\SDK\Samples\Business Analytics\Schema Tool.
  4. Select DWSchema.vbp, and then click Open.
  5. On the Run menu, click Start.
  6. In the Data Warehouse Connection dialog box, do the following:
    Use this To do this
    Server Type the name of the server where the Data Warehouse is located.
    Database Type the name of the database, for example, Retail_dw.
    User Type the user name for SQL Server.
    Password Type the password for SQL Server.
  7. Click OK.

The Commerce Server Data Warehouse Schema is displayed.

To use the Schema Tool

  • The Commerce Server Data Warehouse Schema window contains two panes, the left pane contains the tree view, and the right pane contains the class detail. When a class is selected in the left pane, the child classes are displayed in the right pane. Child classes can also be viewed by double-clicking an expandable class name node. To view class properties, Right-click the class name, and then click Properties.

See Also

Schema Reference

Extending the Data Warehouse

Copyright © 2005 Microsoft Corporation.
All rights reserved.