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)
Product's homepage
Here are some key features of "Data Architect":
· 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
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.
What's New in This Release: [ read full changelog ]
· 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
Find us on Google+
