The DTD-Database mapper tool of Extenprise provides an easy graphical means of mapping an XML document to fields in the database tables. It allows easy prototyping and adaptability of the service logic, eliminating the need for change & recompilation of the service code on change in the names of tables, nodes in the XML document or even mapping between the two. The tools has the ability to map information in multiple tables in a relational structure onto a flat/hierarchical representation of a document (DTD).

Features

The module has the following features:

• Define mapping between nodes in the DTD and columns in the database tables for
  insert and select operation
• Many to one mapping from columns in the database table to the nodes in the DTD
  using operations like SUM, AVG, MIN, MAX on the columns
• Validation of the mapping defined by the user
• Generation of map XML containing the mapping defined by the user
• Saving and reloading of the mapping GUI
• Creation of new database tables
• Opening tables existing in the database
• Altering column definitions in existing database tables

Tour - SAP Integration (.avi file - 36 MB)