- Erwin Software
- Erwin Data Modeler Full Version Free Download
- Erwin Data Modeler Tutorial Pdf
- Ca Erwin Data Modeler Versions
- Erwin Data Modeler Version 9
- Erwin Data Modeler Free Download
This article is a comparison of data modeling tools which are notable, including standalone, conventional data modeling tools and modeling tools supporting data modeling as part of a larger modeling environment.
General[edit]
Data governance is at the core of the erwin EDGE software platform, facilitating collaboration between IT and the business for data-driven insights, agile innovation, risk management and business transformation. By creating an “enterprise data governance experience” rather than an isolated technical program, data governance permeates an organization’s culture, operations, business.
Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
---|---|---|---|---|---|---|---|
Astah | Change Vision | Enterprises | Proprietary | MySQL, Oracle, | Windows, macOS, Linux | Standalone | 2006 |
Database Deployment Manager | The Unauthorized Frog project | SMBs and enterprises | LGPL | CUBRID, MySQL, SQLite | Windows, Linux | Standalone | 2010 ? |
Database Workbench | Upscene Productions | SMBs and enterprises | Proprietary | MS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB | Windows, Linux and FreeBSD (both through Wine) | Standalone | 2001 |
Enterprise Architect | Sparx Systems | SMBs and enterprises | Proprietary | IBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, Sybase | Windows, Linux (Wine), macOS (via CrossOver) | Data modeling is supported as part of a complete modeling platform. | 2000 |
ER/Studio | Embarcadero (acquired by IDERA) | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
Erwin Data Modeler | ERWin (formerly CA) | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQL | Windows | Standalone | 1998 |
MagicDraw | No Magic | Enterprises, SMBs, personal | Proprietary | MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 | Windows, Linux, macOS | Standalone | 1995 |
SQL Server Management Studio | Microsoft | Unknown | Proprietary | MS SQL Server | Windows | Standalone | 2005 |
ModelRight | ModelRight | Enterprises, SMBs, personal | Proprietary | Access, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2 | Windows | Standalone | 2005 |
MySQL Workbench | MySQL (An Oracle Company) | SMBs - personal | Proprietary or GPL | MySQL | Linux, Windows, macOS | Standalone | 2006 |
Navicat Data Modeler | PremiumSoft | SMBs and enterprises | Proprietary | MySQL, MS SQL Server, PostgreSQL, Oracle, SQLite | Windows, macOS, Linux | Standalone | 2012 |
NORMA Object-Role Modeling | Terry Halpin | SMBs and enterprises | CPL | MySQL, MS SQL Server, PostgreSQL, Oracle, DB2 | Windows | Visual Studio Extension | 2005 |
Open ModelSphere | Grandite | Enterprises - SMBs - personal | GNU GPL3 | MS SQL Server, MySQL, PostgreSQL, Oracle, DB2 | Windows, macOS, Linux | Standalone with Data, UML, and process modeling | 2008 |
Oracle SQL Developer Data Modeler | Oracle | Enterprises | Proprietary | Oracle, MS SQL Server, IBM DB2 | Cross-platform | Standalone | Unknown |
PowerDesigner | SAP | SMBs and enterprises | Proprietary | Access, Greenplum, Apache Hive, HP Neoview, IBM DB2, Informix, Ingres, Interbase, MySQL, Netezza, NonStop SQL, Oracle, PostgreSQL, Red Brick Warehouse, SAP business Suite, SAP Hana, SAP Adaptive Server Enterprise, SAP IQ, SAP SQL Anywhere, MS SQL Server, Teradata | Windows | Standalone | 1989 |
Software Ideas Modeler | Dusan Rodina | Enterprises, SMBs, personal | Proprietary | MS SQL Server, MySQL | Windows | Standalone | 2009 |
SQLyog | Webyog, Inc. | Enterprises, SMBs, personal | Proprietary | MySQL, MariaDB | Windows and Linux (using Wine) | Standalone | 2001 |
Toad Data Modeler | Quest Software | SMBs and enterprises | Proprietary | Access, IBM DB2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, Oracle | Windows | Standalone | 2005 (before this date known as CaseStudio) |
Tool | Creator | Target Business Size | License | Supported Database Platforms | Supported OSs | Standalone or bundled into a larger toolkit | Launch Date |
Features[edit]
Tool | Supported data models (conceptual, logical, physical) | Supported notations | Forward engineering | Reverse engineering | Model/database comparison and synchronization | Teamwork/repository |
---|---|---|---|---|---|---|
Database Workbench | Conceptual, logical, physical | IE (Crows feet) | Yes | Yes | Update database and/or update model | No |
Enterprise Architect | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | Update database and/or update model | Multi-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge). |
ER/Studio | Logical, physical, ETL | IDEF1X, IE (Crows feet) | Yes | Yes | Update database and/or update model | ER/Studio Repository and Team Server (formerly Portal/CONNECT) for collaboration |
MagicDraw | Conceptual, Logical & Physical + MDA Transform of Logical to Physical | IDEF1X, UML DDL, Information Engineering & ERD | Yes | Yes | Update database and/or update model | Multi-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge). |
MySQL Workbench | Physical | IDEF1X, IE (Crows feet), UML, and more | Yes | Yes | Update database and/or update model | No |
Navicat Data Modeler | Conceptual, physical | IE (Crows feet) | Yes | Yes | Update database and/or update model | No |
NORMA Object-Role modeling | Conceptual (ORM), Logical, Physical | ORM, Relational(Crows feet option), Barker | Yes | Yes | Update database and/or update model | No |
Open ModelSphere | Conceptual, Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | No |
Oracle SQL Developer Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
PowerDesigner | Conceptual, logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
Toad Data Modeler | Logical, physical | IDEF1X, IE (Crows feet), and more | Yes | Yes | Update database and/or update model | Yes |
See also[edit]
Developer(s) |
|
---|---|
Stable release | |
Operating system | Microsoft Windows |
Type | CASE tool |
License | |
Website | www.erwin.com |
As of | October 2017 |
erwin Data Modeler (stylized as erwin but formerly as ERwin) is computer software for data modeling. Originally developed by Logic Works, erwin has since been acquired by a series of companies, before being spun-off by the private equity firm Parallax Capital Partners, which acquired and incorporated it as a separate entity, erwin, Inc., managed by CEO Adam Famularo.
The software’s engine is based on the IDEF1X method, although it now also supports diagrams displayed with a variant information technology engineering notation, as well as a dimensional modeling notation.
History[edit]
ERwin was created by Logic Works, which was based in Princeton, New Jersey.[1] In May 1993, Logic Works released ERwin/ERX, a version of the tool designed to work in conjunction with PowerBuilder. The database models created using ERwin could be translated into software built through the PowerBuilder integrated development environment (IDE).[2] In May 1995, Logic Works ERwin was expanded to include several other IDEs, adding SQLWindows from Gupta Technologies and Visual Basic from Microsoft.[3] As of 1996, ERwin was among several data modeling software solutions being used to facilitate a wide move to the client–server model in database management.[4]
In 1998, Logic Works was acquired by Platinum Technology which was later acquired, in May 1999, by Computer Associates (CA).[5] ERwin was initially made part of CA’s Jasmine suite but it was later added to their new AllFusion suite[6] under the name AllFusion ERwin Data Modeler.[7][8] The tool was later renamed to CA ERwin Data Modeler.[9]
In 2014 Embarcadero Technologies sought to acquire the product from CA, Inc.[1] This acquisition was blocked by the Department of Justice over anti-competitive concerns.[10][11]
In April 2016, Parallax Capital Partners, a private equity firm, acquired the software from CA Technologies[12] and appointed Adam Famularo as CEO.[13] The company now operates under a new name stylized as erwin, Inc.[14] In September 2016, erwin announced that it had acquired Corso, a British enterprise architecture service provider.[15] In December of the same year, erwin acquired the business process modeling software Casewise, with a plan to integrate the two.[16] In 2017, erwin released its Data Modeler NoSQL, an enterprise-class data modeling solution for MongoDB. In April 2018, NoSQL data modeling support for Couchbase was added.[17] Also that year, erwin launched a data governance solution with impact analysis and integrations to its business process, enterprise architecture and data modeling suites.[18][19] In January 2018, the company acquired data harvesting technology and data governance consulting services company A&P Consulting.[20]
They also developed the erwin EDGE software platform, with EDGE as an acronym for “enterprise data governance experience”, intending to use data governance for. PCWorld. Retrieved 2017-10-02.
Erwin Software
Erwin Data Modeler Full Version Free Download
Erwin Data Modeler Tutorial Pdf
Further reading[edit]
Ca Erwin Data Modeler Versions
- DeAngelis, Carla (2000). Data Modeling with ERwin. Sams. ISBN0-672-31868-7.