DataArchitect

4.3 15 Aug 2012

Architecture database data modeling and more.

2

Developer website: theKompany.com

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.

What's New

Version 4.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)

Requirements

  • Mac OS X 10.5 or later
  • ODBC driver

Ratings

Overall
(3)
Current Version (4.x)
(2)

Details

Downloads
6,310
Version Downloads
551
Type
Multimedia Design / Author Tools
License
Demo
Date
15 Aug 2012
Platform
OS X / PPC 32 / Intel 32
Price
$149.95