Anyone involved with data modelling in the IBM InfoSphere Data Architect product.
An understanding of data modelling and experience of data model development.
2 days. Hands on.
This course is available on site only. Please call for details.
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.
Data Modelling Notation
Entities and attributes.
Primary key types.
Introduction to Data Architect
The Data Perspective.
The Task Launcher.
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.
Primary and alternate keys.
Packages and Submodels
Structure of a data model.
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.
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.
Validating a physical data model.
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.
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.