Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Enterprise Data Quality Applications Help Topics

• 1.1 Welcome to EDQ
  • 1.1.1 Installing EDQ
  • 1.1.2 Key Features
  • 1.1.3 Contacting Oracle Support
  • 1.1.4 EDQ Language Options
    • 1.1.4.1 Adjusting the Client Locale
  • 1.1.5 Terms of Use
• 1.2 EDQ Applications
  • 1.2.1 Director
    • 1.2.1.1 Getting Started with Director
    • 1.2.1.2 Menu
    • 1.2.1.3 Toolbar
    • 1.2.1.4 Issue Notifier
    • 1.2.1.5 Project Browser
    • 1.2.1.6 Canvas
    • 1.2.1.7 Canvas Toolbar
    • 1.2.1.8 Canvas Right-Click Menu
    • 1.2.1.9 Tool Palette
    • 1.2.1.10 Canvas Overview Pane
    • 1.2.1.11 Task Window
    • 1.2.1.12 Results Browser
    • 1.2.1.13 System-level Reference Data Library
    • 1.2.1.14 Run Profiles
  • 1.2.2 Server Console
    • 1.2.2.1 Managing Server Connections
    • 1.2.2.2 Scheduler
      • 1.2.2.2.1 Run Label
    • 1.2.2.3 Current Tasks
    • 1.2.2.4 Event Log
    • 1.2.2.5 Results
    • 1.2.2.6 Result Purge Rules
  • 1.2.3 Dashboard
    • 1.2.3.1 Dashboard Elements
    • 1.2.3.2 Dashboard Administration
      • 1.2.3.2.1 Dashboard View
      • 1.2.3.2.2 Default Thresholds View
    • 1.2.3.3 Dashboard Indexes
  • 1.2.4 Match Review
    • 1.2.4.1 Match Review Summary Window
    • 1.2.4.2 Match Review Application Window
    • 1.2.4.3 Filtering Groups
    • 1.2.4.4 Reviewing Groups
    • 1.2.4.5 Reviewing Merged Groups
  • 1.2.5 Case Management
    • 1.2.5.1 Case Management Concepts
      • 1.2.5.1.1 Alert
      • 1.2.5.1.2 Alert Key
      • 1.2.5.1.3 Attribute
      • 1.2.5.1.4 Case
      • 1.2.5.1.5 Case Key
      • 1.2.5.1.6 Case Source
      • 1.2.5.1.7 Data Source
      • 1.2.5.1.8 Derived State
      • 1.2.5.1.9 Extended Attribute
      • 1.2.5.1.10 Flag Key
      • 1.2.5.1.11 Parameter
      • 1.2.5.1.12 Permission
      • 1.2.5.1.13 Reception Rule
      • 1.2.5.1.14 State
      • 1.2.5.1.15 Transition
      • 1.2.5.1.16 Workflow
    • 1.2.5.2 User Interface
      • 1.2.5.2.1 Browser Screen
      • 1.2.5.2.2 Filter Screen
      • 1.2.5.2.3 Alert Screen
      • 1.2.5.2.4 Cases Screen
      • 1.2.5.2.5 Alert Data Archive
    • 1.2.5.3 Using Case Management
      • 1.2.5.3.1 Editing Cases and Alerts
      • 1.2.5.3.2 Changing the States of Cases and Alerts
      • 1.2.5.3.3 Assigning Cases and Alerts
      • 1.2.5.3.4 Adding Comments to Cases and Alerts
      • 1.2.5.3.5 Editing and Deleting Comments
      • 1.2.5.3.6 Adding Attachments to Cases and Alerts
      • 1.2.5.3.7 Editing and Deleting Attachments
      • 1.2.5.3.8 Editing Case and Alerts Details
      • 1.2.5.3.9 Working with Filters
      • 1.2.5.3.10 Creating Filters
      • 1.2.5.3.11 Managing Filters
      • 1.2.5.3.12 Export to Excel
      • 1.2.5.3.13 Making Bulk Edits
      • 1.2.5.3.14 Bulk Deletions
    • 1.2.5.4 Case Management Administration
      • 1.2.5.4.1 Workflow Administration
      • 1.2.5.4.2 Workflow Editor
      • 1.2.5.4.3 Case Source Administration
      • 1.2.5.4.4 Permission Administration
      • 1.2.5.4.5 Defining States
      • 1.2.5.4.6 Defining Transitions
      • 1.2.5.4.7 Defining Actions
      • 1.2.5.4.8 Defining Parameters
      • 1.2.5.4.9 Defining Conditions
      • 1.2.5.4.10 Example Workflow - 4-Eyes Review Process
  • 1.2.6 Configuration Analysis
  • 1.2.7 Issue Manager
  • 1.2.8 Web Service Tester
    • 1.2.8.1 Testing a Web Service
    • 1.2.8.2 Running a Timing Test
    • 1.2.8.3 Adding Records
    • 1.2.8.4 Alternative Integration Methods (JMS)
  • 1.2.9 How To Topics
• 1.3 Processor Library
  • 1.3.1 Advanced Processors
    • 1.3.1.1 Add Message ID
    • 1.3.1.2 Add User Details
    • 1.3.1.3 Expression
    • 1.3.1.4 Expression Filter
    • 1.3.1.5 Generate Warning
    • 1.3.1.6 Message Handling Script
    • 1.3.1.7 Script
  • 1.3.2 Audit Processors
    • 1.3.2.1 Business Rules Check
      • 1.3.2.1.1 Defining Business Rules
    • 1.3.2.2 Cross-attribute Check
    • 1.3.2.3 Data Type Check
    • 1.3.2.4 Duplicate Check
    • 1.3.2.5 Email Check
    • 1.3.2.6 Invalid Character Check
    • 1.3.2.7 Length Check
    • 1.3.2.8 List Check
    • 1.3.2.9 Logic Check
    • 1.3.2.10 Lookup Check
    • 1.3.2.11 No Data Check
    • 1.3.2.12 Pattern Check
    • 1.3.2.13 RegEx Check
    • 1.3.2.14 Suspect Data Check
    • 1.3.2.15 Value Check
  • 1.3.3 GNR Processors
    • 1.3.3.1 GNR Get Best Culture
    • 1.3.3.2 GNR Get Cultures
    • 1.3.3.3 GNR Parse
    • 1.3.3.4 GNR Search
  • 1.3.4 Match Processors
    • 1.3.4.1 Advanced Match
    • 1.3.4.2 Consolidate
    • 1.3.4.3 Deduplicate
    • 1.3.4.4 Enhance
    • 1.3.4.5 Group and Merge
      • 1.3.4.5.1 Group
    • 1.3.4.6 Link
    • 1.3.4.7 Advanced Options for Match Processors
    • 1.3.4.8 List of Comparisons
      • 1.3.4.8.1 Comparison: ALL in List
      • 1.3.4.8.2 Comparison: Both Fields Null (Solutions)
      • 1.3.4.8.3 Comparison: Character Edit Distance
      • 1.3.4.8.4 Comparison: Character Match Percentage
      • 1.3.4.8.5 Comparison: Character Transposition Match
      • 1.3.4.8.6 Comparison: Contains
      • 1.3.4.8.7 Comparison: Equal or One/Both Fields Null (Solutions)
      • 1.3.4.8.8 Comparison: Exact String Match
      • 1.3.4.8.9 Comparison: In List
      • 1.3.4.8.10 Comparison: Is Value (Solutions)
      • 1.3.4.8.11 Comparison: Longest Common Phrase
      • 1.3.4.8.12 Comparison: Longest Common Phrase Percentage
      • 1.3.4.8.13 Comparison: Longest Common Substring
      • 1.3.4.8.14 Comparison: Longest Common Substring Percentage
      • 1.3.4.8.15 Comparison: Longest Common Substring Sum
      • 1.3.4.8.16 Comparison: Longest Common Substring Sum Percentage
      • 1.3.4.8.17 Comparison: Similar Date
      • 1.3.4.8.18 Comparison: Starts With
      • 1.3.4.8.19 Comparison: Word Edit Distance
      • 1.3.4.8.20 Comparison: Word Match Count
      • 1.3.4.8.21 Comparison: Word Match Percentage
      • 1.3.4.8.22 Comparison: Word Starts With In Common
      • 1.3.4.8.23 Comparison: Date Too Different (Solutions)
      • 1.3.4.8.24 Comparison: Date Difference
      • 1.3.4.8.25 Comparison: Date Edit Distance
      • 1.3.4.8.26 Comparison: Date Transposition Match
      • 1.3.4.8.27 Comparison: Exact Date Match
      • 1.3.4.8.28 Comparison: Year Too Different
      • 1.3.4.8.29 Comparison: Absolute Difference
      • 1.3.4.8.30 Comparison: Equals
      • 1.3.4.8.31 Comparison: Percent Difference
    • 1.3.4.9 List of Matching Transformations
      • 1.3.4.9.1 Match Transformation: Absolute Value
      • 1.3.4.9.2 Match Transformation: Character Replace
      • 1.3.4.9.3 Match Transformation: Convert Date to String
      • 1.3.4.9.4 Match Transformation: Convert Number to String
      • 1.3.4.9.5 Match Transformation: Convert String to Date
      • 1.3.4.9.6 Match Transformation: Convert String to Number
      • 1.3.4.9.7 Match Transformation: Denoise
      • 1.3.4.9.8 Match Transformation: First N Characters
      • 1.3.4.9.9 Match Transformation: First N Words
      • 1.3.4.9.10 Match Transformation: Last N Words
      • 1.3.4.9.11 Match Transformation: Generate Initials
      • 1.3.4.9.12 Match Transformation: Last N Characters
      • 1.3.4.9.13 Match Transformation: Lower Case
      • 1.3.4.9.14 Match Transformation: Make Array from String
      • 1.3.4.9.15 Match Transformation: Metaphone
      • 1.3.4.9.16 Match Transformation: Normalize Whitespace
      • 1.3.4.9.17 Match Transformation: Replace
      • 1.3.4.9.18 Match Transformation: Round
      • 1.3.4.9.19 Match Transformation: Round Extra
      • 1.3.4.9.20 Match Transformation: Script
      • 1.3.4.9.21 Match Transformation: Select Array Element
      • 1.3.4.9.22 Match Transformation: Soundex
      • 1.3.4.9.23 Match Transformation: Strip Numbers
      • 1.3.4.9.24 Match Transformation: Strip Words
      • 1.3.4.9.25 Match Transformation: Trim Whitespace
      • 1.3.4.9.26 Match Transformation: Upper Case
    • 1.3.4.10 List of Output Selectors
      • 1.3.4.10.1 Output Selector: Average
      • 1.3.4.10.2 Output Selector: Delimited List
      • 1.3.4.10.3 Output Selector: Earliest Value
      • 1.3.4.10.4 Output Selector: First Non-empty Value
      • 1.3.4.10.5 Output Selector: Highest Value
      • 1.3.4.10.6 Output Selector: Latest Value
      • 1.3.4.10.7 Output Selector: Longest String
      • 1.3.4.10.8 Output Selector: Lowest Value
      • 1.3.4.10.9 Output Selector: Most Common Value
      • 1.3.4.10.10 Output Selector: Standard Deviation
      • 1.3.4.10.11 Output Selector: Sum Values
      • 1.3.4.10.12 Output Selector: Value from Highest
      • 1.3.4.10.13 Output Selector: Value from Lowest
    • 1.3.4.11 Subprocessors available for Match Processors
      • 1.3.4.11.1 Input
      • 1.3.4.11.2 Identify
      • 1.3.4.11.3 Cluster
      • 1.3.4.11.4 Match
      • 1.3.4.11.5 Merge
  • 1.3.5 Maths Processors
    • 1.3.5.1 Add
    • 1.3.5.2 Divide
    • 1.3.5.3 Multiply
    • 1.3.5.4 Round
    • 1.3.5.5 Subtract
    • 1.3.5.6 Calculate Percentage
  • 1.3.6 Product Data Processors
    • 1.3.6.1 Process Product Data
  • 1.3.7 Profilers
    • 1.3.7.1 Character Profiler
    • 1.3.7.2 Contained Attributes Profiler
    • 1.3.7.3 Data Types Profiler
    • 1.3.7.4 Date Profiler
    • 1.3.7.5 Equal Attributes Profiler
    • 1.3.7.6 Frequency Profiler
    • 1.3.7.7 Length Profiler
    • 1.3.7.8 Min/Max Profiler
    • 1.3.7.9 Number Profiler
    • 1.3.7.10 Patterns Profiler
    • 1.3.7.11 Quickstats Profiler
    • 1.3.7.12 Record Completeness Profiler
    • 1.3.7.13 Record Duplication Profiler
    • 1.3.7.14 RegEx Patterns Profiler
  • 1.3.8 Read and Write Processors
    • 1.3.8.1 Merge Data Streams
    • 1.3.8.2 Reader
    • 1.3.8.3 Writer
  • 1.3.9 Text Analysis Processors
    • 1.3.9.1 Character Tag
    • 1.3.9.2 Character Type
    • 1.3.9.3 Classify
    • 1.3.9.4 Group Tag
    • 1.3.9.5 Input
    • 1.3.9.6 Map
    • 1.3.9.7 Parse
    • 1.3.9.8 Phrase Profiler
    • 1.3.9.9 Reclassify
    • 1.3.9.10 Resolve
    • 1.3.9.11 Select
    • 1.3.9.12 Tokenize
    • 1.3.9.13 Unicode Character Reference
    • 1.3.9.14 Using Attribute Tags
  • 1.3.10 Third-party Processors
    • 1.3.10.1 Address Verification
    • 1.3.10.2 Capscan Matchcode
    • 1.3.10.3 Experian QAS
      • 1.3.10.3.1 Layout ALL
      • 1.3.10.3.2 Layout DEU
      • 1.3.10.3.3 Layout_DNK
      • 1.3.10.3.4 Layout ESP
      • 1.3.10.3.5 Layout FRA
      • 1.3.10.3.6 Layout GBR
      • 1.3.10.3.7 Layout LUX
      • 1.3.10.3.8 Layout_NLD
      • 1.3.10.3.9 Advanced Experian QAS API Configuration
  • 1.3.11 Transformation Processors
    • 1.3.11.1 Add Current Date
    • 1.3.11.2 Add Date Attribute
    • 1.3.11.3 Add Numeric Attribute
    • 1.3.11.4 Add String Attribute
    • 1.3.11.5 Character Replace
    • 1.3.11.6 Concatenate
    • 1.3.11.7 Convert Date to String
    • 1.3.11.8 Convert Number to String
    • 1.3.11.9 Convert Number to Date
    • 1.3.11.10 Convert String to Date
    • 1.3.11.11 Convert String to Number
    • 1.3.11.12 Date Difference
    • 1.3.11.13 Denoise
    • 1.3.11.14 Enhance from Map
    • 1.3.11.15 Extract Values
    • 1.3.11.16 Generate Initials
    • 1.3.11.17 Hash Generator
    • 1.3.11.18 Lookup and Return
    • 1.3.11.19 Lower Case
    • 1.3.11.20 Make Array from Inputs
    • 1.3.11.21 Make Array from String
    • 1.3.11.22 Merge Attributes
    • 1.3.11.23 Metaphone
    • 1.3.11.24 Normalize No Data
    • 1.3.11.25 Normalize Whitespace
    • 1.3.11.26 Pattern Transform
    • 1.3.11.27 Proper Case
    • 1.3.11.28 RegEx Match
    • 1.3.11.29 RegEx Replace
    • 1.3.11.30 RegEx Split
    • 1.3.11.31 Replace
    • 1.3.11.32 Replace All
    • 1.3.11.33 Return Array Size
    • 1.3.11.34 Select Array Element
    • 1.3.11.35 Soundex
    • 1.3.11.36 Split Records from Array
    • 1.3.11.37 Strip Numbers
    • 1.3.11.38 Strip Words
    • 1.3.11.39 Transliterate
    • 1.3.11.40 Trim Characters
    • 1.3.11.41 Trim Whitespace
    • 1.3.11.42 Upper Case
    • 1.3.11.43 Add Date Array Attribute
    • 1.3.11.44 Add Numeric Array Attribute
    • 1.3.11.45 Add String Array Attribute
    • 1.3.11.46 Concatenate Arrays
    • 1.3.11.47 Concatenate String to Array
    • 1.3.11.48 Cross Array Element Update
    • 1.3.11.49 Deduplicate Array
    • 1.3.11.50 Find Matched Array Elements
    • 1.3.11.51 Get Message Header Number
    • 1.3.11.52 Get Message Header String
    • 1.3.11.53 Merge Array Attributes
    • 1.3.11.54 Sort Array
    • 1.3.11.55 Split Array
    • 1.3.11.56 Strip Strings From Array by Length
    • 1.3.11.57 Trim Array
  • 1.3.12 Expression Notes
  • 1.3.13 Grouping Processors
  • 1.3.14 Processor Families
  • 1.3.15 Processor States
• 1.4 Projects
• 1.5 Data Stores
• 1.6 Reference Data
• 1.7 Published Processors
• 1.8 Images
  • 1.8.1 Customizing Processor Icons
• 1.9 Staged Data
• 1.10 Data Interfaces
• 1.11 Processes
• 1.12 Results Books
• 1.13 External Tasks
  • 1.13.1 External Executable
• 1.14 Jobs
  • 1.14.1 Creating and Managing Jobs
    • 1.14.1.1 Creating a Job
    • 1.14.1.2 Editing a Job
    • 1.14.1.3 Deleting a Job
    • 1.14.1.4 Job Canvas Right-Click Menu
    • 1.14.1.5 Editing and Configuring Job Phases
  • 1.14.2 Using Job Triggers
    • 1.14.2.1 Configuring Triggers
    • 1.14.2.2 Deleting a Trigger from a Job
  • 1.14.3 Externalizing Jobs
  • 1.14.4 Execution Options
  • 1.14.5 Job Notifications
    • 1.14.5.1 Configuring a Job Notification
  • 1.14.6 Command-Line Interface
• 1.15 Exports
• 1.16 Notes
• 1.17 Web Services
• 1.18 Issues
• 1.19 Snapshots

2 Oracle Enterprise Data Quality Administration

• 2.1 EDQ Administration
  • 2.1.1 Launchpad
  • 2.1.2 Administration
    • 2.1.2.1 Launchpad Configuration
    • 2.1.2.2 Extensions
    • 2.1.2.3 Functional Packs
    • 2.1.2.4 Users
    • 2.1.2.5 Groups
      • 2.1.2.5.1 Application Permissions
    • 2.1.2.6 External Groups
    • 2.1.2.7 Sessions
  • 2.1.3 Web Services
  • 2.1.4 Extending EDQ
    • 2.1.4.1 Example custom comparison
    • 2.1.4.2 Example custom identifier type
    • 2.1.4.3 Example custom output selector
    • 2.1.4.4 Example match transformation
    • 2.1.4.5 Example written processor
  • 2.1.5 Project Specific Landing Areas
    • 2.1.5.1 Creating a project-specific landing area
  • 2.1.6 Monitoring Real-Time Processes