Product overview

These documents provide a general overview of InfoSphere Data Architect.

  • InfoSphere Data Architect on The InfoSphere Data Architect page on links you to more resources, including product documentation, demos, and related products.

  • Introduction to IBM InfoSphere Data Architect In this demo, learn how to use InfoSphere Data Architect to import an existing logical model, and forward engineer changes to that model to the database; publish a web-based report of the physical model for auditing and team review; reverse-engineer a model from an existing source database, update the model, and then use the compare and synchronization features to generate appropriate change statements to deploy the changes back to the original source database.

  • InfoSphere Data Architect Evaluation Guide This document helps you evaluate the usefulness of the product in the enterprise environment for different roles in the data design process.

  • Free ebook: Getting Started with InfoSphere Data Architect Learn how InfoSphere Data Architect is commonly used to create data models. The book takes you through a full scenario, from logical data design to physical design to deployment.

  • Setting up your work environment for database tasks Learn how to connect to databases, create data design project, configure team environments, and how to perform other tasks related to setting up your workspace.

  • Use InfoSphere Data Architect to model your Oracle databases Look at alternatives to Oracle Designer, and see how keeping up with Oracle's major enhancements is setting InfoSphere Data Architect apart from the rest of the data modeling tools.

  • Migrating from CA ERwin to InfoSphere Data Architect If you've had experience with CA ERwin Data Modeler and now are starting to learn InfoSphere Data Architect, this paper will speed up your model migration process and ease your learning process of the new environment. You will learn the differences between the two design environments, and you'll also learn a set of best practices for using features of InfoSphere Data Architect that will put you on the fast track of working productively in InfoSphere Data Architect.

Support and community


These documents provide information about how to install InfoSphere Data Architect.

Data modeling

Modeling from a warehousing perspective

  • Use the IBM Industry Model Information Insurance Warehouse to define smart and mature data models   In this tutorial, understand the method for developing data models for data warehouse projects using the IBM Industry Model Insurance Information Warehouse, which is part of the IBM Industry Models product defined for the domain of insurance. The tutorial shows the best approach to develop core data warehouse models and data mart models with InfoSphere Data Architect. The tutorial also introduces the recommended data warehousing development method to deal with the insurance information warehouse model pattern framework to architect data warehouse solutions for insurance companies.

Data modeling for software architects

  • Integrating Rational Software Architect with InfoSphere Data Architect This article provides a quick overview of Rational Software Architect and InfoSphere Data Architect, outlines the high-level steps in three Rational Software Architect-InfoSphere Data Architect integration scenarios, and discusses the UML-to-logical data model and the logical data model-to-UML transformations and the UML logical data model profile.

Governance and schema evolution

  • Use InfoSphere Business Glossary to define a common business language among modeling tools Combining common business language taxonomies with modeling tools encourages architects, modelers, and developers to understand and use commonly understood business terms, which eliminates the ambiguity that loosely specified language can introduce. This drives alignment of requirements between IT and business stakeholders. This article describes how to use InfoSphere Business Glossary, Rational Software Architect, and InfoSphere Data Architect within a specific development flow to introduce agreed-upon terms into the modeling environments, establishing the correct semantics early in the development cycle. This effort decreases the cost of development by reducing the churn of getting IT to understand what the business requirements really mean.

  • Aligning business and IT: A solution for a master data-driven business glossary From a governance perspective, it is crucial that an InfoSphere Master Data Management Server's logical domain definitions and their dependencies to physical assets are easily accessible within the entire organization. The integration between InfoSphere Data Architect and InfoSphere Business Glossary helps accelerate this process by establishing a business vocabulary based on approved logical data model entities and attributes. The current InfoSphere Data Architect and InfoSphere Business Glossary integration, however, would not retain the dependencies to their physical model definitions. Based on the example of Master Data Management Server's logical and physical data models, the article provides a solution to generate a logical-data-model-based business glossary that retains its relationships to the underlying physical data model. Maintaining such relationships is critical for the overall success and value of the business glossary for both business and IT.

  • Communicate changing requirements to integration developers with IBM InfoSphere FastTrack This article helps you to understand how to deal with changing data sources and business requirements by using IBM InfoSphere FastTrack to define mapping specifications, and using IBM InfoSphere DataStage to develop ETL jobs. An example that uses models that are created with InfoSphere Data Architect will guide you through the features that are available in the tool which will help you to understand the different possibilities. The objective is to establish a best practice when working with changing data sources and business requirements.

Reporting and validation

Integrating InfoSphere Data Architect and other products