Power*Architect User Guide
SQL Power Group Inc.
Copyright © 2009 SQL Power Group Inc.
Table of Contents
1. Introduction
About Power*Architect
About This Guide
Power*Architect Licensing and Distribution
2. Getting Started
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
3. Creating a relational Data Model
Working with Tables
Creating New Tables
Modifying Tables
Copying Tables from external documents
Working with Columns
Creating New Columns
Modifying Columns
Moving Columns
Copy Columns from external documents
Working with Primary Keys
Working with Relationships
About Identifying and Non-Identifying Relationships
Creating Relationships
Modifying a Relationship
Working with Indices
Creating an Index
Modifying an Index
Deleting an Index
Working with Diagram Objects in the Playpen
Using Undo and Redo
Selecting Multiple Objects in the Playpen
Deleting Diagram Objects in the Playpen
Rearranging Diagram Objects in the Playpen
Automatically Arranging Tables in the Playpen
Straightening Diagram Lines in the Playpen
Using the Playpen Zoom Options
Finding and Replacing Playpen Objects
Printing or Exporting a Data Model Diagram
4. Creating a multidimensional (OLAP) Data Model
Working with multidimensional Schemas
Creating a multidimensional Schema
Importing a multidimensional Data Model
Exporting a multidimensional Data Model
OLAP Schema Manager
Working with Cubes
Adding a Cube
Adding a Virtual Cube
Adding a Dimension to a Cube
Working with Measures
Adding a Measure
Adding a Calculated Member
Working with Dimensions, Hierarchies, Levels
Adding a Dimension
Adding a Dimension usage
Adding a Hierarchy
Adding a Level
Working with Roles
5. Setting up Database Support
Supported Database
Setting up Database Types
Adding a New Database Type
Defining the JDBC Driver
Setting up Database Connections
Creating a New Database Connection
Adding or Removing Database Connections for a Project
Modifying or Deleting Database Connections
6. Setting Preferences
Defining Project Settings
Setting User Preferences
7. Reverse Engineering a Data Model
8. Forward Engineering a Data Model
9. Analyzing Data Structures
Comparing Data Models
Data Model Comparison with English Descriptions
Data Model Comparison in SQL Script
Profiling Data
Setting the Profile Mode
Creating a Profile
Viewing Profile Details
Using Profile Graph View
Using Profile Table View
Deleting Profiles
Saving Your Profile Results in a PDF
Creating a Visual Mapping Report
Exporting Column Mappings
10. Copying and Transforming Data
Copying Data Across Database Platforms
Using Kettle Jobs
Before Creating a Kettle Job
Creating a Kettle Job
11. Universal SQL Access
Output (Results) Window
Output Formats
12. Troubleshooting
13. Glossary
14. Appendices
Appendix A: GNU GPL Version 3
Appendix B: Third Party Licenses
The FAMFAMFAM Silk Icon Set
The Apache Software Foundation
JGoodies Karsten Lentzsch
PostgreSQL JDBC Driver
iText
GNU LGPL version 3
JUnit
Pentaho Data Integration
The Eclipse Foundation
Sun Microsystems