Chapter 2. Getting Started

Table of Contents

About Data Models
About Data Structure Analysis
Copying and Transforming Data
About Advanced Features
About System Preferences
Understanding the Power*Architect User Interface
About the Database Tree
About the Playpen
Using Power*Architect on Different Operating Systems
Example - Creating a Data Model
Setting Up Databases
Designing a Database
Forward Engineer
Comparing Data Models

To get started using Power*Architect, begin by reading the section called “Understanding the Power*Architect User Interface” . This section gives you a quick introduction to the main Power*Architect areas, the playpen and the database tree. You may then want to work through the hands-on the section called “Example - Creating a Data Model” . This example shows you how to create a simple data model, set up a database connection, and forward engineer your model to any database you choose.

Power*Architect contains many features, and you may choose to use some or all of these features depending on what you are trying to accomplish. Please see the following sections for an overview of typical activities you would perform with Power*Architect.

About Data Models

As a general guideline, you would typically follow these steps to create and use a data model:

  1. Create a data model using the playpen. You can do this by creating a data model from scratch, reverse engineering an existing database, or by using a combination of these two methods.

    For more information, see:

  2. Forward engineer your data model to create the data structure in a new database. To use forward engineering, you must first set up a database type and connection for the target database.

    For more information, see:

  3. Use a Kettle job to copy data into your new database.

    For more information, see: