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.
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.
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.
Integration with related products
Data Architect allows you to create models for DB2, 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 Rational® products, with Data Studio and Query Workload Tuner.