![Close [x]](http://dw1.s81c.com/i/c.gif){kind=small}
Before you start
Learn what to expect from this tutorial, and how to get the most out of it.
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.
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
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.
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.
Table of contents
- Before you start
- Using IDA with Informix Dynamic Server
- Reverse engineering models from the database
- What can you do now?
- Starting top down from logical models
- Enhancing your model then syncing it up with the physical model
- Modifying data type mapping preferences
- Enforcing consistency by attaching domain elements to your model
- Conclusion
- Appendix: Model elements support for Informix servers
- Resources
- About the authors
Next steps from IBM
Tags
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular content zone (for example, Java technology, Linux, WebSphere).
My tags shows your tags for this particular content zone (for example, Java technology, Linux, WebSphere).
Popular tutorial tags |
My tutorial tagsSkip to tags list
Popular tutorial tags |
My tutorial tags
