Editor: Discover what database professionals have known for years -- that enterprise databases are designed with enterprise modelling tools. Why has this been a secret for so many? Why do so many labor with buckets full of error-prone undocumented SQL? Well, it seems no one has been able to pack the features of a quality data modelling tool into a product at a reasonable price -- not until now.
Data Architect is the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!
Features
* Workspace/Project oriented environment
* ERD centric data modelling
* Logical Data Model
* Physical Data Model (Oracle, ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, SQLBase)
* model panner ('birds eye view')
* quick find and navigation from output window
* model validation
* full documentation capabilities
* integrated Advanced SQL Editor with syntax highlighting
* save/load SQL Sessions
* integrated ODBC
* multi-platform (Linux (32 and 64bit), Windows XP, Solaris, HP-UX and OSX)
* open file format (XML)
* DBMS specific features such as data types and SQL syntax
* reverse engineer existing databases
* generate Create-Scripts
* print model
* print data dictionary
* liberal use of tool-tips to help Users
* integrated Team Diagram (general purpose diagramming)
* Dynamically drop/add keys and linked indexes
* Dynamically add foreign keys on Tables
* supports table inheritance
* supports: table, view, domain, sequence, procedure, and more