IBM InfoSphere Data Architect is a data modeling tool that supports business intelligence, analytics, master data management and service-oriented architecture initiatives. This tool allows users to align processes, services, applications and data architectures. Data modeling, transformation, DDL script generation, database object creation, debugging, management and SQL stored procedures and functions are all available within IBM InfoSphere Data Architect’s portfolio of features.
![](https://codelido.com/assets/files/2022-12-30/1672387332-431487-image.png)
Key features
Support for logical and physical data modeling
Native data querying
Integrates with related products like IBM Db2, IBM Informix, Oracle, Sybase, Microsoft SQL Server, MySQL and Teradata
Maps relationships between data models
Enables domain modeling, data model analysis, glossary and naming, and models
Transforms data models into UML, Cubing Services, Cognos, logical-dimensional, physical-dimensional and XML schema.
Enables domain modeling, data model analysis, and glossary and naming models.
Pros
Ease of use
Enables easier collaboration and integration among teams
Rapid and easy development
Reduced time to market
Cons
Customer support can be improved
The user interface can be improved