InfoSphere Data Architect
Improve productivity, data governance and business alignment

Native data querying

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 easily browse through the hierarchy of data elements, facilitating an understanding of detailed properties for every element.

Logical and physical data modeling

Create logical data models that describe how your organization wants to collect data and how data objects are related to each other. You can then transform to a new physical data model, or reverse engineer from an existing source. Use the physical data model to model how data should be stored.

Import and export of constant mappings

Automatically import and export any constant mappings contained within mapping models to and from a csv file using the import/export mapping model wizard.

Source control management

Added Git and Microsoft Team Foundation Server (TFS) support.

Integration with related products

InfoSphere Data Architect allows you to 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.

Rapid, easy development

Simple warehouse design, dimensional modeling and change management tasks help reduce development time and give you the tools to design and manage warehouses from an enterprise logical model.

Reduced time to market

Time stamped, column-organized tables offer a better understanding of data assets to help increase efficiency and reduce time to market.

Team collaboration and integration

Small teams or large distributed teams can use InfoSphere Data Architect as a plug-in to a shared Eclipse instance or share artifacts through standard configuration management repositories.