erwin Data Modeler

ERwin was created by Logic Works, which was based in Princeton, New Jersey.{{Cite news|url=http://www.pcworld.com/article/2108620/embarcadero-moves-into-data-modeling-with-ca-erwin-buy.html|title=Embarcadero moves into data modeling with CA ERwin buy|last=Jackson|first=Joab|date=2014-03-14|work=PCWorld|access-date=2017-10-02|language=en}} 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).{{Cite book|url=https://books.google.com/books?id=0Uw3oTahRcwC|title=PC Client/server|date=1993-05-17|publisher=Computerworld|pages=71, 75|language=en}} In May 1995, Logic Works ERwin was expanded to include several other IDEs, adding SQLWindows from Gupta Technologies and Visual Basic from Microsoft.{{Cite news|url=https://books.google.com/books?id=pQpRMj6jSFYC|title=Database utility choices highlighted|last=Nash|first=Kim S.|date=1995-05-08|work=Computerworld|publisher=IDG Enterprise|pages=127|language=en}} 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.{{Cite news|url=https://books.google.com/books?id=rrz6PIR7f0oC|title=CASE reincarnation|last=Richman|first=Dan|date=1996-07-29|work=Computerworld|access-date=2017-09-02|pages=45, 49}}

In 1998, Logic Works was acquired by Platinum Technology which was later acquired, in May 1999, by Computer Associates (CA).{{Cite news|url=http://www.kmworld.com/Articles/News/News/Computer-Associates-Jasmine-goes-Platinum-12030.aspx|title=Computer Associates' Jasmine goes Platinum|date=1999-03-30|work=KMWorld Magazine|access-date=2017-10-02|language=en-US}} ERwin was initially made part of CA’s Jasmine suite but it was later added to their new AllFusion suite{{Cite news|url=http://www.computerworld.com/article/2584857/networking/ca-product-lines-get-second-overhaul.html|title=CA product lines get second overhaul|last=Songini|first=Marc L.|date=2001-11-26|work=Computerworld|access-date=2017-10-02|language=en}} under the name AllFusion ERwin Data Modeler.{{Cite news|url=http://itreports.computerworld.com/article/2554997/enterprise-applications/brief--ca-to-release-new-modeling-tool.html|title=Brief: CA to release new modeling tool|last=Hamblen|first=Matt|work=Computerworld|access-date=2017-10-02|language=en}}{{Cite book|url=https://books.google.com/books?id=pTcwBQAAQBAJ|title=Developing a Data Warehouse for the Healthcare Enterprise: Lessons from the Trenches|last=Bergeron|first=Bryan|date=2013|publisher=HIMSS|isbn=9781938904332|language=en}} The tool was later renamed to CA ERwin Data Modeler.{{Cite book|url=https://books.google.com/books?id=P4_XBgAAQBAJ|title=Data Modeling Made Simple with CA ERwin Data Modeler r8|last=Burbank|first=Donna|last2=Hoberman|first2=Steve|date=2011-08-01|publisher=Technics Publications|isbn=9781634620697|language=en}}

In 2014 Embarcadero Technologies sought to acquire the product from CA, Inc. This acquisition was blocked by the Department of Justice over anti-competitive concerns.{{cite web|url=https://www.justice.gov/opa/pr/embarcadero-technologies-and-ca-inc-terminate-proposed-transfer-ca-incs-erwin-data-modeler|title=Embarcadero Technologies and CA Inc. Terminate Proposed Transfer of CA Inc.'s ERwin Data Modeler|date=2014-11-05|website=OPA|publisher=Department of Justice|access-date=2016-05-13}}{{Cite news|url=http://www.dataversity.net/erwin-looks-future-data-modeling/|title=ERwin Looks to the Future of Data Modeling|last=Zaino|first=Jennifer|date=2016-06-09|work=Dataversity|access-date=2017-10-02|language=en-US}}

In April 2016, Parallax Capital Partners, a private equity firm, acquired the software from CA Technologies{{Cite news|url=http://www.dbta.com/Editorial/News-Flashes/Parallax-Acquires-ERwin-from-CA-Technologies-as-Part-of-Big-Data-Strategy-110276.aspx|title=Parallax Acquires ERwin from CA Technologies as Part of Big Data Strategy|last=Wells|first=Joyce|date=2016-04-06|work=Database Trends and Applications|access-date=2017-10-02|language=en-US}} and appointed Adam Famularo as CEO.{{Cite news|url=http://sdtimes.com/erwin-becomes-a-standalone-company/|title=ERwin becomes a standalone company|last=Cardoza|first=Christina|date=2016-04-07|work=SD Times|access-date=2017-10-02|language=en-US}} The company now operates under a new name stylized as erwin, Inc.{{Cite news|url=http://www.dataversity.net/erwins-end-game-holistic-data-management/|title=Erwin’s End Game: Holistic Data Management|last=Zaino|first=Jennifer|date=2017-02-23|work=Dataversity|access-date=2017-10-02|language=en-US}} In September 2016, erwin announced that it had acquired Corso, a British enterprise architecture service provider.{{Cite news|url=http://www.dataversity.net/erwin-acquires-saas-enterprise-architecture-provider-corso/|title=erwin Acquires SaaS Enterprise Architecture Provider, Corso|last=Guess|first=A.R.|date=2016-09-14|work=Dataversity|access-date=2017-10-02|language=en-US}} In December of the same year, erwin acquired the business process modeling software Casewise, with a plan to integrate the two.{{Cite news|url=https://www.datanami.com/2016/12/13/business-process-mining-promises-big-data-payoff/|title=Business Process Mining Promises Big Data Payoff|last=Woodie|first=Alex|date=2016-12-13|work=Datanami|access-date=2017-10-02|language=en-US}} 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.{{cite web|url=http://www.dbta.com/Editorial/News-Flashes/erwin-DM-NoSQL-Strengthens-Data-Governance-Across-More-Database-Platforms-124750.aspx|title=erwin DM NoSQL Strengthens Data Governance Across More Database Platforms|date=30 April 2018|website=Database Trends and Applications}} Also that year, erwin launched a data governance solution with impact analysis and integrations to its business process, enterprise architecture and data modeling suites.{{cite web|url=https://go.forrester.com/blogs/another-serious-player-entering-the-data-governance-2-0-market/|title=Another Serious Player Is Entering The Data Governance 2.0 Market|date=20 November 2017}}{{cite web|url=https://www.dataversity.net/time-data-governance-2-0-erwin-dg/|title=It’s Time for Data Governance 2.0 with erwin DG|first=Jennifer|last=Zaino|date=15 November 2017}} In January 2018, the company acquired data harvesting technology and data governance consulting services company A&P Consulting.{{cite web|url=https://www.newsday.com/business/technology/erwin-analytix-ds-ca-famularo-software-1.20705495|title=Erwin Inc. acquires AnalytiX DS, grows to 240 workers|website=Newsday}}

They also developed the erwin EDGE software platform, with EDGE as an acronym for “enterprise data governance experience”, intending to use data governance for data-driven insights to help accomplish organizational objectives.{{cite web|url=https://www.newsday.com/business/erwin-ca-acquisition-software-1.16146827|title=LI software maker buys Italian company|website=Newsday}}{{cite web|url=http://www.dbta.com/BigDataQuarterly/Articles/Doubling-Down-on-Data-Governance-QandA-with-Adam-Famularo-CEO-erwin-Inc-123290.aspx|title=Doubling Down on Data Governance: Q&A with Adam Famularo, CEO, erwin, Inc.|date=28 February 2018|website=Database Trends and Applications}} In February 2018 erwin released its first State of Data Governance Report with UBM.{{cite web|url=https://www.information-age.com/prepared-enterprises-impending-gdpr-123470729/|title=Data Governance: How prepared are enterprises for the impending GDPR?|date=12 February 2018}}{{cite web|url=https://sdtimes.com/data/preparing-gdpr-eleventh-hour/|title=Preparing for the GDPR in the eleventh hour|date=5 March 2018}} In August 2018, erwin acquired metadata management and data governance company AnalytiX DS.{{cite web|url=https://sdtimes.com/data/erwin-acquisition-of-analytix-ds-rounds-out-its-data-governance-platform/|title=erwin acquisition of AnalytiX DS rounds out its data governance platform|date=4 September 2018}}

On December 31, 2020 erwin, Inc. was acquired by Quest Software. The business unit is headed by Prashant Parikh.

At its core, erwin has a computer-aided software engineering tool (or CASE tool).{{Cite book|url=https://books.google.com/books?id=9x2LawVL_UsC|title=Database Modeling and Design: Logical Design|last=Teorey|first=Toby J.|last2=Lightstone|first2=Sam S.|last3=Nadeau|first3=Tom|last4=Jagadish|first4=H. V.|date=2011-02-10|publisher=Elsevier|isbn=9780123820211|pages=234|language=en}} Users can utilize erwin Data Modeler as a way to take conceptual data model and create a logical data model that is not dependent on a specific database technology.{{Cite book|url=https://books.google.com/books?id=ufDibgxnCdUC|title=Beginning Oracle Database 11g Administration: From Novice to Professional|last=Fernandez|first=Iggy|date=2009-02-18|publisher=Apress|isbn=9781590599686|pages=131|language=en}} This schematic model can be used to create the physical data model. Users can then forward engineer the data definition language required to instantiate the schema for a range of database-management systems.{{Sfn|Burbank|Hoberman|2011|p=481}} The software includes features to graphically modify the model, including dialog boxes for specifying the number of entity–relationships, database constraints, indexes, and data uniqueness. erwin supports three data modeling languages: IDEF1X,{{Sfn|Burbank|Hoberman|2011|p=47}} a variant of information technology engineering {{Sfn|Burbank|Hoberman|2011|p=328}} developed by James Martin,{{Cite web|url=https://visualstudiomagazine.com/Blogs/Tool-Tracker/2010/12/Starting-CA-ERwin-Data-Model.aspx|title=Starting a Data Model in CA's ERwin|last=Vogel|first=Peter|date=2010-12-09|website=Visual Studio Magazine|language=en|access-date=2017-10-02}} and a form of dimensional modeling notation.{{Sfn|Burbank|Hoberman|2011|p=496}}

The software also allows users to generate data models by reverse-engineering pre-existing databases that are based on several different formats.{{Cite web|url=https://visualstudiomagazine.com/articles/2010/12/01/designing-databases-with-erwin-data-modeler-7.3.aspx|title=Designing Databases with ERwin Data Modeler 7.3|last=Vogel|first=Peter|date=2010-12-01|website=Visual Studio Magazine|language=en|access-date=2017-10-02}} Another included feature is erwin’s ability to create reusable design standards: “including naming standards, data type standards, model templates and more.” The software includes several features for modifying how the data model is displayed, including options for several colors, fonts, diagrams, subject areas and layouts.{{Sfn|Burbank|Hoberman|2011|p=38-39}}

erwin’s Complete Compare feature allows the user to compare two versions of a model, displays differences, and allows for merging and updates in either direction.{{Sfn|Burbank|Hoberman|2011|p=38}} As of March 2016, the software bundle also includes its own Report Designer. The erwin DM 2018 update included Netezza, MySQL 8.x, PostgreSQL 10.4, and Hive; model counts reports; and PII support. The 2019 update included DB2 z/OS v12, SQL Server 2017, Teradata v16.20, and PostgreSQL 11.2, in addition to reporting enhancements like user-defined properties and filters.{{cite web|url=https://www.softwaretestinghelp.com/data-modeling-tools/|title=10 Best Data Modeling Tools To Manage Complex Designs|website=www.softwaretestinghelp.com}}

Beginning in 1992, the United Nations Development Programme (UNDP) was one of the larger organizations to utilize ERwin to integrate its many independent databases located at its 120 field offices. UNDP used ERwin to develop a “corporate data model”, with the goal of “reducing redundant data entry” and create a single database framework based on which “all future systems can be designed”. ERwin was used to both reverse-engineer existing data at field offices and also move data from Computer Associates’ IDMS to Sybase’s UnixRDBMS.{{Cite news|url=https://books.google.com/books?id=81WcX8nG1uUC|title=U.N. group globalizes data modeling|last=Hoffman|first=Thomas|date=1993-08-09|work=Computerworld|access-date=2017-09-02|pages=69, 74}}

As of 2001, the insurance company Aetna used Erwin Data Modeler to automate maintenance of its database table definitions. Aetna’s database consisted of 15,000 table definitions which became difficult to maintain manually.{{Cite news|url=http://www.computerworld.com/article/2592300/financial-it/managing-tons-of-data.html|title=Managing Tons Of Data|last=Nance|first=Barry|date=2001-04-23|work=Computerworld|access-date=2017-10-02|language=en}}

As of 2002, ERwin was among the products used by the New York Power Authority.{{Cite news|url=http://www.computerworld.com/article/2587681/vertical-it/ca-customers-hang-tough.html|title=CA Customers Hang Tough|last=Songini|first=Marc L.|date=2002-03-04|work=Computerworld|access-date=2017-10-02|language=en}} The software was also in use by Utah State Office of Education as of 2006.

{{Reflist}}

• {{cite book | last = DeAngelis | first = Carla | title = Data Modeling with ERwin | publisher = Sams | year = 2000 | isbn = 0-672-31868-7 }}

• {{Official website|http://www.erwin.com}}

Category:Data modeling tools

Category:Oracle database tools

Category:Microsoft database software

Category:Sybase

Category:CA Technologies