InfoSphere Data Architect Information Roadmap

These documents provide a general overview of InfoSphere Data Architect.

• InfoSphere Data Architect on IBM.com The InfoSphere Data Architect page on IBM.com 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.

Back to top

• InfoSphere Data Architect support Contact IBM support to troubleshoot and resolve issues with the product.

• InfoSphere Data Architect forum Interact with other InfoSphere Data Architect users and find solutions to common issues.

• InfoSphere Data Architect on developerWorks View articles, tutorials, and demos that feature InfoSphere Data Architect.

• System requirements for InfoSphere Data Architect, Version 7.6 This document describes the minimum system requirements to install InfoSphere Data Architect.

Back to top

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

• Installation roadmap for IBM InfoSphere Data Architect The installation roadmap lists the high-level steps for installing the product. The roadmap describes a typical installation using the Installation Manager Install wizard.

Back to top

• Data modeling with InfoSphere Data Architect and Informix Dynamic Server Learn about the various features of Infosphere Data Architect, including how models can be used to represent business entities, database entities, and domain entities. Follow along with scenarios and examples that reveal the benefits InfoSphere Data Architect provides specifically for Informix Dynamic Server.

• Transforming a logical data model into a physical data model This tutorial teaches you how to transform a logical data model into a physical data model, using different transformation options for denormalization.

• Use InfoSphere Data Architect to define and enforce data object naming standards This article examines the features of InfoSphere Data Architect that enable users to define and implement object naming standards, and then demonstrates with a real-world example.

• Modifying InfoSphere Data Architect models and customizing properties Learn how to programmatically traverse and modify Infosphere Data Architect models and how to add and display custom properties.

• Develop mapping models with InfoSphere Data Architect This tutorial illustrates how to develop a complete source-to-target mapping model using InfoSphere Data Architect. You will also learn about the reporting functions that InfoSphere Data Architect provides.

• Using InfoSphere Data Architect to import and export data model XML XML files are used throughout software development and information management to describe data structures. This article shows you how to turn XML files into data models, and vice versa, with the help of IBM InfoSphere Data Architect.

• Managing database design changes This tutorial teaches you how to manage database changes in a team environment with the workbench.

• Bitemporal modeling with IDA, part 1: Modeling application-period requirements Beginning with IBM InfoSphere Data Architect version 7.6, you can model relational databases as well as temporal relational databases. This two-part series will demonstrate how you can accelerate temporal data modeling with a DB2 for z/OS version 10 database by adopting InfoSphere Data Architect 7.6.

• Bitemporal modeling with IDA, part 2: Modeling system-period requirements In this continuation of the series, you will learn how to modify an existing data model in order to model bitemporal requirements, using InfoSphere Data Architect version 7.6. Bitemporal modeling provides a lot of flexibility in data design, providing you the ability to query on both system-period and business-period data.

Back to top

• Efficient multidimensional data modeling with InfoSphere Data Architect This demo shows how a data architect at a fictional company uses InfoSphere Data Architect to efficiently create multidimensional data models of a new data mart, which can be used for business intelligence and analytical reports.

• 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.

Back to top

• 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.

Back to top

• 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.

Back to top

• Build customized reports and validation rules with IDA Learn how to generate customized reports and how to add your own validation rules for InfoSphere Data Architect models.

• Create model information reports with BIRT report designs This tutorial teaches you how to create a BIRT report design with InfoSphere Data Architect, using a data model as a data source.

• Demo: Creating comparison and synchronization reports See how Tom, a data modeler for the Sample Outdoors company, uses comparison and synchronization reports to distribute information about proposed, upcoming, and implemented changes to data models.

Back to top

• Scoping the IBM Industry Model for banking using Enterprise Model Extender and InfoSphere Data Architect Learn how the process of scoping can yield business objects that will guide you to developing a meaningful logical data model. This tutorial uses IBM Enterprise Model Extender with IBM InfoSphere Data Architect to illustrate the scoping process.

Back to top

Trial software offers