CrossOSS: Cross Platform Software Database

Database Modeling: Data Architect

(No Ratings Yet)

 Loading ...

Data Architect is a cross-platform data modeling tool for Windows, OS X, Linux and Solaris

From the web site: 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 the emerging enterprise tool for designing databases at all levels of an organization, using the same concepts found in tools costing thousands of dollars!

Features

Workspace/Project oriented environment
ERD centric data modelling
model panner (”birds eye view”)
quick find and naviagtion from output window
model validation
full documentation capabilities
integrated Advanced SQL Editor with syntax highlighting
SQL Project - a multi-platform (Windows, Mac OS X, Linux), multi-database, integrated development environment
save/load SQL sessions
integrated ODBC
multi-platform (Linux, MS Windows and soon Mac OS X)
multi-database (ODBC, MySQL, PostgreSQL, DB2, InterBase/FireBird, Gupta SQLBase, MSSQL)
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, triggers, functions
import Bulk Data across databases

Supported databases
MSSQL
generic using ODBC
MySQL
PostgreSQL
DB2
InterBase/FireBird (in testing)
Gupta SQLBase

Typical interaction

Run Data Architect on your favourite operating system. Create an ODBC Data Source Name (DSN) for the desired data source. Create a Data Architect Project and create a new ERD. Optionally adjust the validation rules for the model. Now prime your ERD by reverse engineering the existing database or start from scratch. Add/edit/document; domains, sequences, tables, views, and procedures. Validate the model. Use the quick navigation features of the output to quickly jump to any problems and correct. Generate a create script. Review, edit, and execute the script in the integrated Advanced SQL Editor. Print a data dictionary report to communicate the design and design desicisions to other or pass the open XML file along for use in third-party software.

| Post in Linux, OS X, Windows, Charged, Development, Database |