SQL Power Architect User Guide

• Full Version
• 1 year of online access via SQL Power Wiki
• print-friendly PDF format also included
• 65 pages + appendices

The SQL Power Architect User Guide is recommended for all SQL Power Architect users. It includes basic concepts as well as example instructions for all SQL Power Architect data modeling and data profiling functionality.

Download Instructions:

Once your purchase is completed, you will be emailed a secure link to access the online SQL Power Wiki as well as the PDF download.

Table of Contents

The SQL Power Architect User Guide includes:

• Introduction
• SQL Power Architect Licensing and Distribution
• Getting Started
  • About Data Models
  • About Data Structure Analysis
  • Copying and Transforming Data
  • About Advanced Features
  • About System Preferences
  • Understanding the SQL Power Architect User Interface
  • About the Database Tree
  • About the Playpen
  • Using SQL Power Architect on Different Operating Systems
  • Example - Creating a Data Model
  • Setting Up Databases
  • Designing a Database
  • Forward Engineer
  • Comparing Data Models
• 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
• Creating a multidimensional (OLAP) Data Model
  • Creating a new multidimensional Data Model
  • Adding a Cube
  • Adding a Dimension
  • Adding a Measure
  • Adding a Role
  • Importing a multidimensional Data Model
  • Exportng a multidimensional Data Model
• 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
• Setting Preferences
  • Defining Project Settings
  • Setting User Preferences
• Reverse Engineering a Data Model
• Forward Engineering a Data Model
• 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
• Copying and Transforming Data
  • Copying Data Across Database Platforms
  • Using Kettle Jobs
  • Before Creating a Kettle Job
  • Creating a Kettle Job
• Universal SQL Access
  • Output (Results) Window
  • Output Formats
• Troubleshooting
• Glossary
• Appendices