Erwin Data Modeler Versions

  1. Erwin Software
  2. Erwin Data Modeler Full Version Free Download
  3. Erwin Data Modeler Tutorial Pdf
  4. Ca Erwin Data Modeler Versions
  5. Erwin Data Modeler Version 9
  6. 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.

ToolCreatorTarget Business SizeLicenseSupported Database PlatformsSupported OSsStandalone or bundled into a larger toolkitLaunch Date
AstahChange VisionEnterprisesProprietaryMySQL, Oracle,Windows, macOS, LinuxStandalone2006
Database Deployment ManagerThe Unauthorized Frog projectSMBs and enterprisesLGPLCUBRID, MySQL, SQLiteWindows, LinuxStandalone2010 ?
Database WorkbenchUpscene ProductionsSMBs and enterprisesProprietaryMS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDBWindows, Linux and FreeBSD (both through Wine)Standalone2001
Enterprise ArchitectSparx SystemsSMBs and enterprisesProprietaryIBM DB2, Firebird, InterBase, Informix, Ingres, Access, MS SQL Server, MySQL, SQLite, Oracle, PostgreSQL, SybaseWindows, Linux (Wine), macOS (via CrossOver)Data modeling is supported as part of a complete modeling platform.2000
ER/StudioEmbarcadero (acquired by IDERA)SMBs and enterprisesProprietaryAccess, IBM DB2, Informix, Hitachi HiRDB, Firebird, Interbase, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, Teradata, Visual Foxpro and others via ODBC/ANSI SQLWindowsStandalone1998
Erwin Data ModelerERWin (formerly CA)SMBs and enterprisesProprietaryAccess, IBM DB2, Informix, MySQL, MS SQL Server, Netezza, Oracle, PostgreSQL, Sybase, and others via ODBC/ANSI SQLWindowsStandalone1998
MagicDrawNo MagicEnterprises, SMBs, personalProprietaryMS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2Windows, Linux, macOSStandalone1995
SQL Server Management StudioMicrosoftUnknownProprietaryMS SQL ServerWindowsStandalone2005
ModelRightModelRightEnterprises, SMBs, personalProprietaryAccess, MS SQL Server, Oracle, MySQL, PostgreSQL, IBM DB2WindowsStandalone2005
MySQL WorkbenchMySQL (An Oracle Company)SMBs - personalProprietary or GPLMySQLLinux, Windows, macOSStandalone2006
Navicat Data ModelerPremiumSoftSMBs and enterprisesProprietaryMySQL, MS SQL Server, PostgreSQL, Oracle, SQLiteWindows, macOS, LinuxStandalone2012
NORMA Object-Role ModelingTerry HalpinSMBs and enterprisesCPLMySQL, MS SQL Server, PostgreSQL, Oracle, DB2WindowsVisual Studio Extension2005
Open ModelSphereGranditeEnterprises - SMBs - personalGNU GPL3MS SQL Server, MySQL, PostgreSQL, Oracle, DB2Windows, macOS, LinuxStandalone with Data, UML, and process modeling2008
Oracle SQL Developer Data ModelerOracleEnterprisesProprietaryOracle, MS SQL Server, IBM DB2Cross-platformStandaloneUnknown
PowerDesignerSAPSMBs and enterprisesProprietaryAccess, 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, TeradataWindowsStandalone1989
Software Ideas ModelerDusan RodinaEnterprises, SMBs, personalProprietaryMS SQL Server, MySQLWindowsStandalone2009
SQLyogWebyog, Inc.Enterprises, SMBs, personalProprietaryMySQL, MariaDBWindows and Linux (using Wine)Standalone2001
Toad Data ModelerQuest SoftwareSMBs and enterprisesProprietaryAccess, IBM DB2, Informix, MySQL, MariaDB, PostgreSQL, MS SQL Server, SQLite, OracleWindowsStandalone2005 (before this date known as CaseStudio)
ToolCreatorTarget Business SizeLicenseSupported Database PlatformsSupported OSsStandalone or bundled into a larger toolkitLaunch Date

Features[edit]

ToolSupported data models (conceptual, logical, physical)Supported notationsForward engineeringReverse engineeringModel/database comparison and synchronizationTeamwork/repository
Database WorkbenchConceptual, logical, physicalIE (Crows feet)YesYesUpdate database and/or update modelNo
Enterprise ArchitectConceptual, Logical & Physical + MDA Transform of Logical to PhysicalIDEF1X, UML DDL, Information Engineering & ERDYesYesUpdate database and/or update modelMulti-user collaboration using File, DBMS or Cloud Repository (or transfer via XMI, CVS/TFS or Difference Merge).
ER/StudioLogical, physical, ETLIDEF1X, IE (Crows feet)YesYesUpdate database and/or update modelER/Studio Repository and Team Server (formerly Portal/CONNECT) for collaboration
MagicDrawConceptual, Logical & Physical + MDA Transform of Logical to PhysicalIDEF1X, UML DDL, Information Engineering & ERDYesYesUpdate database and/or update modelMulti-user collaboration using File, DBMS or (transfer via XMI, CVS/TFS or Difference Merge).
MySQL WorkbenchPhysicalIDEF1X, IE (Crows feet), UML, and moreYesYesUpdate database and/or update modelNo
Navicat Data ModelerConceptual, physicalIE (Crows feet)YesYesUpdate database and/or update modelNo
NORMA Object-Role modelingConceptual (ORM), Logical, PhysicalORM, Relational(Crows feet option), BarkerYesYesUpdate database and/or update modelNo
Open ModelSphereConceptual, Logical, physicalIDEF1X, IE (Crows feet), and moreYesYesUpdate database and/or update modelNo
Oracle SQL Developer Data ModelerLogical, physicalIDEF1X, IE (Crows feet), and moreYesYesUpdate database and/or update modelYes
PowerDesignerConceptual, logical, physicalIDEF1X, IE (Crows feet), and moreYesYesUpdate database and/or update modelYes
Toad Data ModelerLogical, physicalIDEF1X, IE (Crows feet), and moreYesYesUpdate database and/or update modelYes

See also[edit]

Retrieved from 'https://en.wikipedia.org/w/index.php?title=Comparison_of_data_modeling_tools&oldid=916534837'
erwin Data Modeler
Developer(s)
  • Logic Works (Through 1998)
  • Platinum Technology (1998–1999)
  • CA Technologies (1999–2016)
  • erwin, Inc. (2016 to present)
Stable release
Operating systemMicrosoft Windows
TypeCASE tool
License
Websitewww.erwin.com
As ofOctober 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.

  • ^PC Client/server. Computerworld. 1993-05-17. pp. 71, 75.
  • ^Nash, Kim S. (1995-05-08). 'Database utility choices highlighted'. Computerworld. IDG Enterprise. p. 127.
  • ^Richman, Dan (1996-07-29). 'CASE reincarnation'. Computerworld. pp. 45, 49. Retrieved 2017-09-02.
  • Modeler
  • ^'Computer Associates' Jasmine goes Platinum'. KMWorld Magazine. 1999-03-30. Retrieved 2017-10-02.
  • ^Songini, Marc L. (2001-11-26). 'CA product lines get second overhaul'. Computerworld. Retrieved 2017-10-02.
  • ^ abHamblen, Matt. 'Brief: CA to release new modeling tool'. Computerworld. Retrieved 2017-10-02.
  • ^Bergeron, Bryan (2013). Developing a Data Warehouse for the Healthcare Enterprise: Lessons from the Trenches. HIMSS. ISBN9781938904332.
  • ^Burbank, Donna; Hoberman, Steve (2011-08-01). Data Modeling Made Simple with CA ERwin Data Modeler r8. Technics Publications. ISBN9781634620697.
  • ^'Embarcadero Technologies and CA Inc. Terminate Proposed Transfer of CA Inc.'s ERwin Data Modeler'. OPA. Department of Justice. 2014-11-05. Retrieved 2016-05-13.
  • ^ abZaino, Jennifer (2016-06-09). 'ERwin Looks to the Future of Data Modeling'. Dataversity. Retrieved 2017-10-02.
  • ^Wells, Joyce (2016-04-06). 'Parallax Acquires ERwin from CA Technologies as Part of Big Data Strategy'. Database Trends and Applications. Retrieved 2017-10-02.
  • ^Cardoza, Christina (2016-04-07). 'ERwin becomes a standalone company'. SD Times. Retrieved 2017-10-02.
  • ^Zaino, Jennifer (2017-02-23). 'Erwin's End Game: Holistic Data Management'. Dataversity. Retrieved 2017-10-02.
  • ^Guess, A.R. (2016-09-14). 'erwin Acquires SaaS Enterprise Architecture Provider, Corso'. Dataversity. Retrieved 2017-10-02.
  • ^Woodie, Alex (2016-12-13). 'Business Process Mining Promises Big Data Payoff'. Datanami. Retrieved 2017-10-02.
  • ^'erwin DM NoSQL Strengthens Data Governance Across More Database Platforms'. Database Trends and Applications. 30 April 2018.
  • ^'Another Serious Player Is Entering The Data Governance 2.0 Market'. 20 November 2017.
  • ^Zaino, Jennifer (15 November 2017). 'It's Time for Data Governance 2.0 with erwin DG'.
  • ^'Erwin Inc. acquires AnalytiX DS, grows to 240 workers'. Newsday.
  • ^'LI software maker buys Italian company'. Newsday.
  • ^'Doubling Down on Data Governance: Q&A with Adam Famularo, CEO, erwin, Inc'. Database Trends and Applications. 28 February 2018.
  • ^'Data Governance: How prepared are enterprises for the impending GDPR?'. 12 February 2018.
  • ^'Preparing for the GDPR in the eleventh hour'. 5 March 2018.
  • ^'erwin acquisition of AnalytiX DS rounds out its data governance platform'. 4 September 2018.
  • ^ abTeorey, Toby J.; Lightstone, Sam S.; Nadeau, Tom; Jagadish, H. V. (2011-02-10). Database Modeling and Design: Logical Design. Elsevier. p. 234. ISBN9780123820211.
  • ^Fernandez, Iggy (2009-02-18). Beginning Oracle Database 11g Administration: From Novice to Professional. Apress. p. 131. ISBN9781590599686.
  • ^Burbank 2011, p. 481.
  • ^Burbank 2011, p. 47.
  • ^Burbank 2011, p. 328.
  • Erwin Software

  • ^Vogel, Peter (2010-12-09). 'Starting a Data Model in CA's ERwin'. Visual Studio Magazine. Retrieved 2017-10-02.
  • ^Burbank 2011, p. 496.
  • ^Vogel, Peter (2010-12-01). 'Designing Databases with ERwin Data Modeler 7.3'. Visual Studio Magazine. Retrieved 2017-10-02.
  • ^Burbank 2011, p. 38-39.
  • ^Burbank 2011, p. 38.
  • ^'10 Best Data Modeling Tools To Manage Complex Designs'. www.softwaretestinghelp.com.
  • ^Hoffman, Thomas (1993-08-09). 'U.N. group globalizes data modeling'. Computerworld. pp. 69, 74. Retrieved 2017-09-02.
  • Erwin Data Modeler Full Version Free Download

  • ^Nance, Barry (2001-04-23). 'Managing Tons Of Data'. Computerworld. Retrieved 2017-10-02.
  • ^Songini, Marc L. (2002-03-04). 'CA Customers Hang Tough'. Computerworld. Retrieved 2017-10-02.
  • Erwin Data Modeler Versions

    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.

    Erwin Data Modeler Version 9

    External links[edit]

    Erwin Data Modeler Free Download

    Retrieved from 'https://en.wikipedia.org/w/index.php?title=Erwin_Data_Modeler&oldid=903335376'