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.
v4.3
- Upgraded engine to Qt 4.8.0
- Faster object movement in the diagrams, especially on OSX
- SVG Support
- Crash reports automatically submitted
- 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 samle models for all supported databases
- Import Firebird domains
- 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 (x86, x86_64, ppc), Windows, Solaris 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
- Full unicode support
- Planned features
- Support for database specific features of Oracle, etc.
- Support for file standard in use by PowerDesigner, Rational etc
- Area zones in order to work with an selected amount of objects
- Create modify script (SQL script to modify existing database with data preservation)
- Supported databases
- generic using ODBC (included)
- generic using SQL92 (included)
- MySQL (included)
- PostgreSQL (included)
- InterBase/FireBird (included)
- DB2 (optional - additional cost)
- MSSQL (optional - additional cost)
- Gupta SQLBase (optional - additional cost)
- Oracle (optional - additional cost)
