theKompany.com
Navigation -> ProductsEmbeddedTKCGearServicesSupportAbout UsProjectsPress & Media


Overview : Announcement Mailing List : Aethera Plugins : BlackAdder : dbRadar
Data Architect : Kapital : Kivio mp : KOBOL : KODE : PyQtDoc : Quanta Gold : Rekall
tkCard : tkBackup : tkExpense : tkPhone : tkShopper : Eric Ultimate Solitaire
Licensing Information : Download basket


Data Architect: Professional Database Modelling

Location / Home / Products / Data Architect / Overview

 

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 (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)

In all cases to use DataArchitect you must purchase either the CD or Download version. If you want an optional module, such as Oracle, you would then need to purchase that module in addition to DataArchitect.

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

Roadmap

Want to find out more about the future of Data Architect? Be sure to take a look at the Roadmap, where future platforms and features are explained.

Keep checking back here for updates on Data Architect as they become available.

 


Data Architect links

Overview

Screenshots

Demo Version

Reviews

Roadmap

Change Log

PlatformsLinuxWindowsMac OS X





Items in cart: 0
Total amount: US$ 0.00

Show cart contents

Proceed to checkout


Suggestions? Comments?

Got a suggestion or comment about any of theKompany.com's products? Just drop us a line at demo-support@thekompany.com and let us know what you think.

Support

If you need support with theKompany.com's products, visit the support page for help.

Announcements Mailing List

Want to stay in touch with the latest products from theKompany.com? Just sign up for the Announcements Mailing List for more.

Bug Reports

Found a bug in our software? Visit this page to find out how to let us know, and we'll fix it pronto.


Home

Contact us

Back to Top


Home : Products : Embedded : TKCGear : Services : Support : About Us : Projects : Press & Media
Comments about the website? Contact the webmaster.

Copyright © 2009 theKompany.com. All rights reserved.
Website design from Grantham Design.
Programming from Grantham Design and Alessandro Praduroux.