DataArchitect

Giới Thiệu · DataArchitect

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 (32, 64 bit and PowerPC), Solaris, Windows (32 and 64 bit) 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! Major Features: Documentation features Multiple Document Interface (MDI) Workspace/Project paradigm Generic diagramming with rectangles, ellipses, lines etc ERD centric modeling (Physical Model) Model validation Create Physical Model from existing database Complete documentation capabilities Print data dictionary Export diagram to a variety of graphic formats Export model to HTML Generate database "create scripts" Embedded, connected, SQL Editor with syntax coloring and "complete word" Show SQL results and export in a variety of formats Open file format (XML) ODBC browser dockwindow Panner dockwindow (birds eye view) Ontelligent output dockwindow (quickly jump to problem spots) Available on; Linux, Solaris, OSX and Windows Assistance; implicit (navigation and pick lists), tool tips, online help using tkHelp, and html documentation Logical Model Create a Physical Model from a Logical Model Create a Logical Model from a Physical Model Improved printing and exporting Generic ODBC Physical Model (3 SQL Grammars and Driver Defined) Generic SQL92 Physical Model Outlook-like toolbar dockwindow Properties editor dockwindow Manual mode for SQL on most objects Set validation strictness Improved data type selection for domains and columns Improved drawing speed Import Bulk Data across databases DBMS's supported; generic using ODBC generic using SQL92 MySQL PostgreSQL DB2 InterBase/FireBird MS SQL Gupta SQLBase Oracle