DataArchitect versions

Powerful tool that provides ERD capability like PowerDesigner as well as the ability to graphically reverse engineer...
4.3
Oct 2, 2014
Review
4.2
Aug 31, 2011
Review

What's new

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)

Alternative downloads

Data Extractor
Data Extractor
rating

Extracts data from unstructured text and collects them in a database.

Aqua Data Studio
Aqua Data Studio
rating

A database integrated development environment supporting many databases types.

iList Data
iList Data
rating

One of the most powerful, low cost, single-user database tool.

DbWrench
DbWrench
rating

Database design and synchronization tool.

Chief Architect Interiors
Chief Architect Interiors
rating

Interior home design software.