Data Architect License Key

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
• 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 (32 and 64bit), Windows XP, Solaris, HP-UX 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

Planned features

• Create modify script (SQL script to modify existing database with data preservation)
• Support for file standard in use by PowerDesigner, Rational etc
• Area zones in order to work with an selected amount of objects
• Full unicode support
• CVS integration, FTP integration
• Supported databases
• generic using ODBC
• generic using SQL92
• MySQL
• PostgreSQL
• DB2
• InterBase/FireBird (in testing)
• MSSQL
• Gupta SQLBase
• Oracle

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.
System requirements

Data Architect requires the following operating systems:

• Linux:
  • Any 32 or 64 bit Linux distribution for Intel computers
• Windows:
  • Any of the following Windows versions: 98, NT, ME, 2000, XP
• Mac OS X 10.3 or later
• HP-UX
• Sparc Solaris

Data Architect has the following hardware requirements:

• 200 MHz Pentium or 266 MHz G3 processor
• 64 MB RAM
• 20 MB hard drive space

Getting your key

Your key will be delivered to you via email within 24 hours of purchase.