DataArchitect 3.5-060504 review

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.

License: Trial OS: Mac OS X File size: 0K Developer: theKompany.com Buy Now Price: $59.00 Updated: 12 May 2006

0

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. For a single price you get all the supported platforms, Linux, Solaris, Windows and Mac OS X. Discover what database professionals have known for years - that enterprise databases are designed with enterprise modeling 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 modeling tool into a product at an accessible price - not until now.

Data Architect is an emerging enterprise tool for designing databases at all levels of an organization using the same concepts found in tools costing thousands of dollars!

Here are some key features of "DataArchitect":
Workspace/Project oriented environment
ERD centric data modeling
Logical Data Model
Physical Data Model (ODBC, SQL92, MySQL, PostgreSQL, DB2, FireBird, MS SQL, Gupta 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,Windows XP 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)
supports table inheritance supports; table, view, domain, sequence, procedure, and more DBMS's supported; generic using ODBC generic using SQL92 * MySQL * PostgreSQL * DB2 * InterBase/FireBird * MS SQL * Gupta SQLBase.

What's New:
Fix an crash after creating a new object and deleting it
Reverse engineer postresql domains
Fixed reverse engineer postresql tables based on domains
Add value list and custom check constraints for PostgreQL Domains
Fixed Reverse Engingeer Comments on columns from PostgreSQL
Added attributes on relationships ( m:m )
Fix create column with not null and default values for SQLBase.