Data Modeling Data Types

Enterprise Architect supports modeling and reverse engineering of database schema for these DBMS products:

  • DB2
  • Firebird
  • MS Access 97, 2000, 2003, 2007, 2013
  • MS SQL Server 2000, 2005, 2008, 2012
  • MySQL v4, v5
  • Oracle 9i, 10g, 11g, 12c
  • PostgreSQL
  • SQLite
  • Informix (#)
  • Ingres (#)
  • InterBase (#)
  • Sybase Adaptive Server Anywhere (Sybase ASA) (#)
  • Sybase Adaptive Server Enterprise (Sybase ASE) (#)

With the current release, details for modeling the above are included in the EAbase.eap repository available in the directory where Enterprise Architect is installed. This is the base repository used for creating new repositories.

Where you have an existing repository that was created prior to a DBMS data type being supported, you can use one of the following scripts to update the support for the DBMS data types:

For more information on importing these downloaded XML script files, please see: