Data Modeling Software For Mac

Return to site

Data Modeling Software For Mac

The SQL Power Architect data modeling tool was created by data warehouse designers and has many unique features geared specifically for the data warehouse architect. Platform: Mac, Mac OS X 10.4 Category: Development / Other.
Free 3d Modeling Software Mac
Data Modeling Software For Mac Free
Open Source Data Modeling Software
Free 3d Modeling Software MacThis 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]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-platformStandalone2009
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
Data Modeling Software For Mac FreeFeatures[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 web based publishing collaboration and model management, with Business Glossary as standard.
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

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	2009
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

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 web based publishing collaboration and model management, with Business Glossary as standard.
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]Open Source Data Modeling SoftwareRetrieved from 'https://en.wikipedia.org/w/index.php?title=Comparison_of_data_modeling_tools&oldid=963382767'