CA ERwin Data Modeler (or ERwin for short) is a data modeling and database design tool that is used to create conceptual, logical, and physical data models. ERwin can create the actual database from the physical model, and create different physical implementations from a single logical model. ERwin can also reverse-engineer existing databases into a data model diagram. ERwin works with many database management systems (DBMS). Outputs from the tool include entity-relationship (ER) diagrams and standard or custom reports on all objects in the design (tables, fields, relationships).
IBM InfoSphere Data Architect is an enterprise data modeling application built on the Eclipse Integrated Development Environment (IDE) platform. Data Architect enables information designers to create both logical and physical data model diagrams, which can be used to describe a variety of applications and systems. For example, this tool can document a SQL database application, a complex website, a multi-server application platform, or a networked workflow process.