XML and the SQL 2000 Server part 3: XML Data with XPath Queries - Adding an SQL Module
(Page 4 of 8 )
To begin you may highlight, for example the SQL module, and right click which brings up this Add Module screen where you may choose to add the module. Or as shown in the picture that follows use the menubar item to add a module.
Assuming that an SQL module is added, familiar Data Link Properties window shows up as in the next picture-connecting to the data source. In step 1, the SQL 2000 Server is chosen, in step 2, the authentication information is supplied, and in step 3, the database to be connected to is specified. The connection may also be tested.
The database may have any number of tables, but you can choose the tables for which you want to create the XDR schema/XML View. These can be chosen by clicking the table names in the Available list on the left to the Selected list on the right.
Clicking OK will import these tables into the Project's SQL Modules folder creating a file with .smt extension. Drag and drop this item into the left pane in the Map Editor.
The tables may be expanded to show the columns contained therein as shown in this picture. In the color table, although three columns were imported, an additional relationship is also imported due to an existing relationship in the database[between the color and nums tables].
Next: Generating and Mapping an XDR Schema >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
