Role of Web Assistant Wizard and Displaying Records from the XML_EX Database
Web Assistant Wizard in SQL 6.5 provides a wizard that steps the process of creating a Web Task, hiding all the underlying functionality with the Graphical User Interface. The SQL Server Web Assistant is a simple way to quickly generate Web Tasks.
1. Click on Enterprise manager by selecting Start, Programs, Microsoft QL Server 7.0. A small window will appear.
The table Bookinfo is created. The datas should be entered in the table. Double click on the Tables icon, a list of available tables (tables created by the system and user) will appear. Right click on the table Bookinfo, selecting Open Table, returning all rows. A window called “Data in Table ‘BookInfo’ ” The values are entered in the window and closed.
The first step is to create a template file called Bookinfo.tpl. The procedure for creating the file is the same as an xml document.
From the programs menu the Microsoft SQL Server 7.0 and then the Enterprise manager is selected from the programs menu.
A server group is selected by clicking the icon.
The various components of the server group such as the databases contained Management tools, Data Transformation Services etc are displayed. The Database such as xml_ex is selected.
The various user defined and system tables available in the xml_ex database are displayed. Over the tool bar click on the icon tool tip displaying “Run a Wizard” .
The window that appears shows various wizards available. The “Web Assistant Wizard” is selected and the ok button is clicked.
A welcome screen that guides through the steps needed to complete the wizard appears. The “Next” button is then clicked.
The list of all the databases available in the server group are displayed. The desired database is selected. In the example, xml_ex (name of the database ) is selected and “Next” button is clicked.
A text field is provided for entering the name of the “Web Assistant Wizard” .The data can be retrieved from the database in three different ways. They are as follows:
1. Data from the tables and columns- This is a straight forward method of extracting information. The columns that should be included in the output are selected after selecting the table.
The list of tables available in the selected database is displayed. When a table is chosen, the fields available in the table are displayed. The required fields alone can be selected by selecting the field and the “ADD” button is being clicked. If all fields are required , then the “AddAll” button is clicked, followed by “Next” button.
A screen that allows the user to filter the records based on the criteria appears. The three different types of filters are:
The various refresh options are:
Any one of the above options is selected and the “Next” button is being clicked.
The window that appears, requires the path where the xml file should be created and saved. The directory on the server should be specified. The “Next” button is clicked then.
The screen that appears next displays various options regarding the retrieval of rows. They are:
The final screen appears that requires the confirmation to complete the wizard. Finally click the “finish” button. If the wizard is successful, the following message “Web Assistant Wizard” screen appears, followed by the clicking of “Ok” button.