InfoSphere Data Architect

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.

This course is available on site only. Please call for details.

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

Data Modelling Notation
Entities and attributes.
Primary key types.
One-to-many relationships.
Many-to-many relationships.
Foreign keys.

Introduction to Data Architect
The Workspace.
The Data Perspective.
The Task Launcher.
Preferences.
Creating a new project.
The Data Project Explorer.

Logical Data Models
Creating a new logical data model.
Creating a logical data model diagram.
Adding entities and attributes.
Temporal entities.
Primary and alternate keys.
Adding relationships.
Referential integrity.
Constraints.
Generalizations.
Annotating diagrams.

Packages and Submodels
Structure of a data model.
Packages.
Moving entities into a package.
Creating a new diagram.
Creating and using a submodel.

Creating and Enforcing Standards
Creating and populating a glossary model.
Specifying naming standards.
Checking compliance with naming standards.
Domain models.
Atomic, list and union models.
Domain models and logical data models.

Physical Data Models
Differences between logical and physical models.
Creating a physical data model from scratch.
Transforming a logical to a physical data model.
Rearranging columns.
Validating a physical data model.
Generating DDL.

Reporting
Import, export and reporting in Data Architect.
Publishing data models.
Generating an XSLT report.
Generating a basic BIRT report.
Designing custom BIRT reports.
The Report Explorer view.
The Report Design perspective.
Generating a report configuration.

Reverse Engineering
Database reversal.
Mapping and merging data models.
Reverse engineering in Data Architect.
Reverse engineering from a DDL script and a database.
Comparing data models.
Copying data objects.

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...