Wednesday, 03 February 2016 21:47

Introduction to the Database Builder

Written by
Rate this item
(0 votes)

enterprise architect for database administrator roles banner

Enterprise Architect’s Database Builder provides interactive connectivity to a DBMS,  supporting both the initial creation of a database and the ongoing update of tables, views, triggers and procedures – all from within the design model.


This tutorial paper works through a simple database example (attached in .ZIP file) using the Database Builder to create tables within a new Database, then make modifications in both the model and the Database and use the compare functionality to update the Database and the model respectively.

Read 8536 times Last modified on Monday, 08 February 2016 22:33

Sparx Systems

99 Albert Street
P: +61 3 5345 1140
F: +61 3 5345 1104
Sparx Systems specializes in high performance and scalable visual modeling tools for the planning, design and construction of software intensive systems. A Contributing Member of the Object Management Group (OMG), Sparx Systems is committed to realizing the potential of model-driven development based on open standards. The company’s flagship product, Enterprise Architect, has received numerous accolades since its commercial release in August, 2000. Enterprise Architect is the design tool of choice for over 740,000 registered users worldwide.


  • Comment Link sparxsystems Monday, 08 February 2016 22:40 posted by sparxsystems

    Hello Phil and thanks for the info, we've identified a bug in the MDA transform in the latest build. The issue has been prioritized and I'm confident that it will be addressed in an upcoming release if it hasn't been resolved in one of our current development builds.

  • Comment Link philchudley Thursday, 04 February 2016 13:33 posted by philchudley


    I am using version 12.1 build 1227 and when I perform the MDA transformation of the supplied logical data model as shown in the paper, the UML types of String, Integer etc do not get transformed into VARCHAR etc as shown in the paper.

    When attempting the use Database datatyppes I have noticed that for all DBMS you can only specify a mapping from Common Types to Data Types

    BUT the UML types of String, Integer, Boolean etc are NOT listed hence it is not possible to specify a mapping from UML to DBMS.

    If this paper is followed, the result of the MDA to MySQL results in UML String types being transformed into String (that is a verbatim transform)

    Any advice/comments on how you can transform UML types to DBMS types (eg String -> VARCHAR(50) would be most appreciated.

Login to post comments