Level: Intermediate Venkatesh Gopal (gopalv@us.ibm.com), Senior Software Engineer, IBM
Srini Bhagavan (srinib@us.ibm.com), Senior Software Engineer, IBM
26 Nov 2008
Updated 12 Mar 2009 This tutorial shows you how to use IBM®
InfoSphere® Data Architect (IDA) (formerly IBM Rational® Data
Architect) as a modeling tool for Informix® Dynamic Server (IDS), and
has been updated to include information about the 7.5.1 release of IDA. Learn
about the various features of IDA, 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 IDA provides
specifically for IDS.
Before you start
Learn what to expect from this tutorial, and how to get the most out of
it.
About this tutorial
This tutorial walks you through the different features in IDA and shows
you how it can be used with IDS. Learn how to reverse engineer a
physical model from a database, transform business requirements into
models (logical and physical), and associate domain elements that help
in identifying critical and confidential information, all using IDS as
the database.
Objectives
In this tutorial, you will learn how to:
- Connect to an IDS server
- Reverse engineer a new physical model from an existing
database
- Create a physical database schema from a logical model
- Modify an existing logical model and moving that change
through to the database
- Maintain data consistency and quality by attaching a domain
model to the database
Prerequisites
This tutorial assumes you have some basic knowledge about Informix
database servers. It also assumes some basic knowledge in working with
Eclipse-based tools. If you want some background on navigating
Eclipse-based tools, the IDA Welcome page includes an overview of the
Eclipse platform.
System requirements
You need a system running Windows® XP or Windows Vista®
with about 1GB of disk space to install IDA and IDS. For this
tutorial, I have used Informix Dynamic Server, Version 11.10.TC2 and
IDA, Version 7.5.1. This tutorial uses the superstores_demo database
that has been created using the dbaccessdemo9 script in the
INFORMIXDIR\bin directory.
| 
