DataArchitect

DataArchitect is a powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer, create and modify a database through ODBC and perform advanced SQL functions. For a single price you get all the supported platforms, Linux (32 and 64 bit), Solaris, Windows, HP-UX and Mac OS X. Discover what database professionals have known for years - that enterprise databases are designed with enterprise modeling 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 modeling tool into a product at an accessible price - not until now.

Documentation features: Multiple Document Interface (MDI), Workspace/Project paradigm, generic diagramming with rectangles, ellipses, lines, ERD centric modeling (Physical Model), model validation, create Physical Model from existing database, complete documentation capabilities, print data dictionary, export diagram to a variety of graphic formats, export model to HTML, generate database "create scripts", embedded, connected, SQL Editor with syntax coloring and "complete word", show SQL results and export in a variety of formats, open file format (XML), ODBC browser dockwindow, panner dockwindow (birds eye view), intelligent output dockwindow (quickly jump to problem spots), available on; Linux, Solaris, OSX and Windows, generic database support via ODBC, database specific support for; MySQL, PostgreSQL, DB2, MSSQL, Gupta SQL Base, Interbase and Oracle assistance; implicit (navigation and pick lists), tool tips, online help using tkHelp, and html documentation.
Logical Model: create a Physical Model from a Logical Model, create a Logical Model from a Physical Model, improved printing and exporting, Generic ODBC Physical Model (3 SQL Grammars and Driver Defined), Generic SQL92 Physical Model, Outlook-like toolbar dockwindow, properties editor dockwindow, manual mode for SQL on most objects, set validation strictness, improved data type selection for domains and columns, improved drawing speed, import Bulk Data across databases.

What is new in this release:

Version 4.3:

Upgraded engine to Qt.4.8.0 Faster object movement in the diagrams, especially on OSX SVG suport Crash reports automatically submited Remote software update implemented iODBC included on Linux/Unix platforms Setup available to switch between builds Faster SQL execution by using binding during reverse engineering Use iODBC unicode on OSX 10.5 and above Added sample models for all supported databases Import Firebird domains

Limitations:

30-minute trial