Jump to content

Erwin Data Modeler: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
Undo Technics Publications SPAM.
Updated to reflect the completed acquisition of ERwin by Parallax Capital Partners.
Line 3: Line 3:
| name = CA ERwin Data Modeler
| name = CA ERwin Data Modeler
| logo =
| logo =
| developer = {{Unbulleted list|[[Logic Works]] (1998)|[[Platinum Technology]] (1998–1999)|[[Computer Associates]] (1999–present)}}
| developer = {{Unbulleted list|[[Logic Works]] (1998)|[[Platinum Technology]] (1998–1999)|[[Computer Associates]] (1999–2016)|[[Parallax Capital Partners]] (2016 to present)}}
| latest_release_version = r9.6
| latest_release_version = r9.6
| latest_release_date = {{Start date and age|March 2015}}
| latest_release_date = {{Start date and age|March 2015}}
Line 19: Line 19:


In 2014 [[Embarcadero Technologies]] sought to acquire the product from [[CA, Inc.]].<ref>Joab Jackson. [http://www.pcworld.com/article/2108620/embarcadero-moves-into-data-modeling-with-ca-erwin-buy.html "Embarcadero moves into data modeling with CA ERwin buy".] ''[[IDG News Service]], 14 March 2014.</ref> This acquisition was blocked by the [[United States Department of Justice|Department of Justice]] over anti-competitive concerns.<ref>http://www.justice.gov/opa/pr/embarcadero-technologies-and-ca-inc-terminate-proposed-transfer-ca-incs-erwin-data-modeler</ref>
In 2014 [[Embarcadero Technologies]] sought to acquire the product from [[CA, Inc.]].<ref>Joab Jackson. [http://www.pcworld.com/article/2108620/embarcadero-moves-into-data-modeling-with-ca-erwin-buy.html "Embarcadero moves into data modeling with CA ERwin buy".] ''[[IDG News Service]], 14 March 2014.</ref> This acquisition was blocked by the [[United States Department of Justice|Department of Justice]] over anti-competitive concerns.<ref>http://www.justice.gov/opa/pr/embarcadero-technologies-and-ca-inc-terminate-proposed-transfer-ca-incs-erwin-data-modeler</ref>

As of April 5, 2016, Private equity firm Parallax Capital Partners completed the acquisition of data modeling software ERwin from CA Technologies (Nasdaq: CA). It nows operates as ERwin, Inc., and is led by IT industry veteran Adam Famularo, who is now CEO of ERwin, Inc. <ref> http://erwin.com/resources/news/parallax-acquires-data-modeling-solution-erwin-from-ca-technologies#sthash.WgbBCsr0.dpuf </ref>


==Distinguishing features==
==Distinguishing features==

Revision as of 16:32, 19 April 2016

CA ERwin Data Modeler
Developer(s)
Stable release
r9.6 / March 2015; 9 years ago (March 2015)
Operating systemMicrosoft Windows
TypeCASE tool
LicenseProprietary EULA
Websitewww.erwin.com

CA ERwin Data Modeler (ERwin) is a software tool for data modeling (data requirements analysis, database design etc.) of custom developed information systems, including databases of transactional systems and data marts. ERwin's data modeling engine is based upon the IDEF1X method, although it now supports diagrams displayed with information engineering notation as well. Logic Works stylised "ERwin" from an abbreviation of "Entity Relationships" and Microsoft's "Windows".

History

File:ERWin 4.1.4.3643 on Windows 2000 screenshot.png
ERwin CASE tool on Windows 2000

ERwin was created by Logic Works. It was acquired in 1998 by Platinum Technology, which was later acquired in May 1999 by Computer Associates, who added it to their AllFusion suite under the name AllFusion ERwin Data Modeler. The tool was later renamed to CA ERwin Data Modeler.

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.[2]

As of April 5, 2016, Private equity firm Parallax Capital Partners completed the acquisition of data modeling software ERwin from CA Technologies (Nasdaq: CA). It nows operates as ERwin, Inc., and is led by IT industry veteran Adam Famularo, who is now CEO of ERwin, Inc. [3]

Distinguishing features

  • Logical Data Modeling: Purely logical models may be created, from which physical models may be derived. Combinations of logical and physical models are also supported. Supports entity-type and attribute logical names and descriptions, logical domains and data types, as well as relationship naming.
  • Physical Data Modeling: Purely physical models may be created as well as combinations of logical and physical models. Supports the naming and description of tables and columns, user defined data types, primary keys, foreign keys, alternative keys and the naming and definition of constraints. Support for indexes, views, stored procedures and triggers is also included.
  • Logical-to-Physical Transformation: Includes an abbreviation/naming dictionary called "Naming Standards Editor" and a logical-to-RDBMS data type mapping facility called "Datatype Standards Editor", both of which are customizable with entries and basic rule enforcement.
  • Forward engineering: Once the database designer is satisfied with the physical model, the tool can automatically generate a SQL Data Definition Language (DDL) script that can either be directly executed on the RDBMS environment or saved to a file.
  • Reverse engineering: If an analyst needs to examine and understand an existing data structure, ERwin will depict the physical database objects in an ERwin model file.
  • Model-to-model comparison: The "Complete/Compare" facility allows an analyst or designer to view the differences between two model files (including real-time reverse-engineered files), for instance to understand changes between two versions of a model.
  • An "Undo" feature is available from version 7.
  • Bulk Editor: CA ERwin Data Modeler has a unique Bulk Editor feature that enable users to edit a collection of objects in a single editing session
  • Active Model Templates: Derive new models from template models. Changes in template model can be automatically synchronized into all derived models
  • API (Application Programming Interface) Support: ERwin provides a programming interface to automate tasks that involve reading/writing of data models
  • Domains (Column Domains): ERwin has the concept of domains that defines characteristics of attributes/columns in a model. It acts as a library of attributes/columns so it can be re-used across entities/tables and centrally managed through a flexible property inheritance/over-ride mechanism.
  • Model Repository and version management: ERwin has a very powerful integrated model repository for change management (Workgroup edition) that supports metadata governance, version-ing, multi-user modeling, etc.

Physical Modeling support

  • DB2 iSeries 5.x/6.x/7.x
  • DB2 LUW 9.x/10.x
  • DB2 ZOS 8.1/9.1/10/11
  • Informix 7.x/9.x/10.x/11.x
  • MySQL 5.x/6.x
  • ODBC/Generic 2.0/3.0
  • Oracle 10g/11g/12c
  • Progress 9.x/10.x
  • SAS
  • SQL Azure (using SQL Azure extension)
  • MS SQL Server 2008,2012/2014
  • Sybase (ASE) 15/16
  • Sybase IQ 12.x
  • Teradata 13/13.1/14/14.1/15

Limitations

Versions prior to CA ERwin Data Modeler 9.2 had only been certified on the 32-bit versions of the Windows operating systems.

Associated products

  • CA ERwin Web Portal (Data Governance Edition r9.6 March 2015)
  • CA ERwin Web Portal (added with CA ERwin r8.2 in February 2012)
  • CA ERwin Safyr Option for ERP

See also

Publications

  • DeAngelis, Carla (2000). Data Modeling with ERwin. Sams. ISBN 0-672-31868-7.

References

  1. ^ Joab Jackson. "Embarcadero moves into data modeling with CA ERwin buy". IDG News Service, 14 March 2014.
  2. ^ http://www.justice.gov/opa/pr/embarcadero-technologies-and-ca-inc-terminate-proposed-transfer-ca-incs-erwin-data-modeler
  3. ^ http://erwin.com/resources/news/parallax-acquires-data-modeling-solution-erwin-from-ca-technologies#sthash.WgbBCsr0.dpuf
Retrieved from "https://en.wikipedia.org/w/index.php?title=Erwin_Data_Modeler&oldid=716054245"