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 OracleLogical 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.

Whats new in this version:

Version 4.3: Upgraded engine to Qt.4.8.0Faster object movement in the diagrams, especially on OSXSVG suportCrash reports automatically submitedRemote software update implementediODBC included on Linux/Unix platformsSetup available to switch between buildsFaster SQL execution by using binding during reverse engineeringUse iODBC unicode on OSX 10.5 and aboveAdded sample models for all supported databasesImport Firebird domains