Skip Headers
Oracle® Enterprise Data Quality for Product Data Services for Excel Reference Guide
Release 5.6.2
Part Number E23611-02
Home
Book List
Contact Us
Next
View PDF
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