SQL Power DQguru User Guide

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

The SQL Power DQguru User Guide is recommended for all SQL Power DQguru users. It includes basic concepts as well as example instructions for all SQL Power DQguru data cleansing functionality.

Table of Contents

The SQL Power DQguru User Guide includes:

• Introduction
• Getting Started
  • Understanding the SQL Power DQguru User Interface
  • About the SQL Power DQguru Editor
  • About the SQL Power DQguru Tree
  • Using SQL Power DQguru on Different Operating Systems
  • Understanding SQL Power DQguru Basic Concepts
  • About SQL Power DQguru Projects
  • Transformations
  • Translation
  • Merge
  • SQL Power DQguru Engines
• Working with SQL Power DQguru
  • Overview of Creating a Project
  • General Guidelines
  • Logging into a Repository
  • Creating a New Project
  • Importing and Exporting Projects
  • Creating Translation Words and Groups
  • Defining Transformations
  • Creating a PDF Copy of a Transformation
  • Creating Merge Rules
  • Running a SQL Power DQguru Engine
  • Example - Creating a De-duping Project
  • Example - Creating an Address Correction Project
  • SQL Query
  • Output (Results) Window
  • Output Formats
• Setting up Database Support
  • Setting up Database Types
  • Adding a New Database Type
  • Defining the JDBC Driver
  • Setting up Database Connections
  • Creating a New Database Connection
  • Modifying or Deleting Database Connections
• Working with Repositories
  • About Repositories
  • Creating a Remote Repository
  • Create a Database and User
  • Create a New Data Source
  • Create the Repository Tables
  • Connecting to a Remote Repository
  • Using Concurrent Sessions Within the Same Repository
  • Changing Your Repository Startup Preferences
• Glossary