

This field shows a description of the current ODBC connection, in the format: The sophisticated reporting engine can produce high quality documentation, including data dictionaries, diagrams and relationships back to other models such as architecture and information requirements, and ultimately to business goals and drivers.ĭatabase schema information can be imported via the Database Builder or from the 'Develop' ribbon.

When systems target multiple DBMSs, these can all be reverse engineered into a model and elements and datatypes can be compared between these models. Once the schema is in Enterprise Architect, the database objects can be traced to other elements, ensuring the integrity of design and architecture. Enterprise Architect communicates with the DBMS via ODBC, can import a schema via this connection, and can synchronize the model with the live database if it is changed. A wide range of database objects are supported including Tables, Views, Procedures, Functions and Sequences. Enterprise Architect can reverse engineer a DBMS schema and its objects into a model under a number of different standards, including UML, Information Engineering and IDEF 1X.

Being able to view the database schemas alongside other models of a system provides great clarity and reduces the chance of error. The power of model-based engineering is the ability to visualize, analyze and design all aspects of a system.
