IBM InfoSphere Data Architect

IBM InfoSphere® Data Architect is a collaborative enterprise data modeling and design solution that can simplify and accelerate integration design for business intelligence, master data management and service-oriented architecture initiatives. InfoSphere Data Architect supports collaboration at every step of the data design process, from project management to application design to data design. The tool helps to align processes, services, applications and data architectures.

InfoSphere Data Architect discovers the structure of heterogeneous data sources by examining and analyzing the underlying metadata. Using an established Java Database Connectivity (JDBC) connection to the data sources, it explores the structures using native queries. With the user interface, users can browse through the hierarchy of data elements, facilitating an understanding of detailed properties for every element.

It supports the creation of logical data models that describe how the organization wants to collect data and how data objects are related to each other. These can then be transformed to a new physical data model, or reverse engineered from an existing source.

InfoSphere Data Architect can create models for IBM Db2®, IBM Informix®, Oracle, Sybase, Microsoft SQL Server, MySQL and Teradata source systems. Elements from logical and physical data models can be visually represented in diagrams using Information Engineering (IE) notation. It can also provide greater integration with Rational Team Concert and shell share with the latest IBM Rational® products, with IBM Data Studio and IBM InfoSphere Optim™ Query Workload Tuner.