Data Architect

Discover what database professionals have known for years -- that enterprise databases are designed with enterprise modelling 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 modelling tool into a product at a reasonable price -- not until now.

Data Architect is a software for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

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)

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

What is new in this release:

• 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

Requirements:

• Any 32 or 64 bit Linux distribution for Intel and PPC computers unixODBC or iODBC
• 1GHz processor
• 640 MB RAM
• 40 MB hard drive space

Limitations:

• The application will time-out after a short amount of time.