Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• Toolbar and Menus Explained
  • Jobs Menu
  • Test Menu
  • DataLens Tools Menu
  • DataLens Help Menu
  • Excel Cell Context-Sensitive Menu

2 Installing and Configuring Services for Excel

• Preparing for Installation
  • Hardware and Software Requirements
  • Enterprise DQ for Product Prerequisites
    • Required Oracle DataLens Server Software
    • Optional DataLens Client Software
  • Establishing a Windows Administrator User Account
  • Obtaining the Software
  • Identifying the Current Software Version
• Installing Services for Excel
  • Known Issues and Workarounds
  • Installing Enterprise DQ for Product Client Software to Use AutoBuild Application
• Logging into the Oracle DataLens Server
• Changing the Oracle DataLens Server
• Configuring Application Options

3 Transforming Your Data

• Configuring a DSA
  • Setting Up a DSA Job
• Unique Record Identifiers
  • Creating the Unique Identifier Column
  • DSA Outputs
    • The DSA Output Named Output
• Running a DSA to Process Data Records
  • Using Real Time Records Processing
  • Using Batch Mode Records Processing
  • Removing Result Data
• Viewing the Job Status

4 Getting More from Your Data

• Loading Metadata Files
• Changing and Grouping Data
  • Grouping Records
  • Filling Columns with Data
  • Character Analysis and Replacement
    • Analyzing the Character Set
    • Replacing Control Characters
    • Searching for Character Hex Values
    • Removing Embedded HTML Tags
• Using Regression Testing
  • Creating or Updating the Regression Set
    • Removing Regression Set Worksheets
  • Adding Cells to the Regression Set
  • Comparing Selected Records
  • Comparing Job Results
• Using Data Sampling
• Backing Up Source Data
• Using the AutoBuild Application