InfoSphere Data Architect

Audience

Anyone involved with data modelling in the IBM InfoSphere Data Architect product.

Prerequisites

An understanding of data modelling and experience of data model development.

Duration

2 days. Hands on.

Course Objectives

Businesses today own vast amounts of data and decisions are made based on that data. Understanding the data and its structure is essential. IBM's InfoSphere Data Architect (IDA) is an enterprise data design tool which enables users to discover, model, relate and standardise data assets.

This course covers the essentials of IDA and will enable attendees to:

• Understand the structure and details of the user interface
• Create logical and physical data models
• See how compliance to enterprise standards may be enforced
• Produce complex reports using the Business Intelligence Reporting Tool (BIRT)
• Reverse engineer from databases to data models.

Course Content

Introduction to Data Architect
Basic elements of the user interface
Menus and commands
The Data Project Explorer
The Data Source Explorer
Preferences

Logical Data Models
Creating a logical data model
The Logical Data Model Editor
Creating a logical data model diagram
Adding and manipulating data objects
Modifying data object properties
Annotating diagrams
Creating sub-models

Physical Data Models
Differences between logical and physical models
Creating a physical data model
Transforming a logical to a physical data model
Creating roles
Validating a physical data model
Generating DDL

Creating and Enforcing Standards
Glossary models
Domain models
Analysing a data model

Reporting
Impact analysis
Publishing data models
BIRT reporting
Setting up the report environment
The report editor
Adding data objects to a report
Previewing a report
Grouping data
Adding dynamic text to a report

Reverse Engineering
Reverse engineering from DDL
Reverse engineering from a database
Comparing a data model with a source database