Friday, November 22, 2024

Different data modeling tools list

 

===========================================
AIR TABLE : (3jul 2025)
Data modeling tool with AI data options and self creating data model 


===========================================


===========================================
ToolCreatorTarget Business SizeLicenseSupported Database PlatformsSupported OSsStandalone or bundled into a larger toolkitLaunch Date
AstahChange VisionEnterprisesProprietaryMySQL, Oracle,Windows, macOS, LinuxStandalone2006
Database WorkbenchUpscene ProductionsSMBs and enterprisesProprietaryMS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDBWindows, Linux and FreeBSD (both through Wine)Standalone2001
DbSchemaWise Coders GmbHSMBs and enterprisesProprietaryMS SQL Server, MySQL, Oracle, Firebird, InterBase, SQL Anywhere, NexusDB, MariaDB, SQLite, PostgreSQL, SybaseWindows, Linux, macOSStandalone2018
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, Snowflake, Microsoft Azure 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 ModelerLogic Works (now Quest)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 StudioMicrosoftUn­knownProprietaryMS 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 enterprisesOpen source (CPL)MySQL, MS SQL Server, PostgreSQL, Oracle, IBM Db2WindowsVisual Studio Extension2005
Open ModelSphereGranditeEnterprises - SMBs - personalOpen source (GNU GPL3)MS SQL Server, MySQL, PostgreSQL, Oracle, IBM 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 CaseStu

No comments:

Post a Comment

239 ) Metadata Management

Metadata Management and Modern Data Governance Tools Metadata management forms the backbone of data governance, data lineage, and data quali...