Home
/
Middleware
/
Oracle Enterprise Data Quality
1/5
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
Tool Palette
1.2.1.8
Canvas Overview Pane
1.2.1.9
Task Window
1.2.1.10
Results Browser
1.2.1.11
System-level Reference Data Library
1.2.1.12
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.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: Contains
1.3.4.8.6
Comparison: Equal or One/Both Fields Null (Solutions)
1.3.4.8.7
Comparison: Exact String Match
1.3.4.8.8
Comparison: In List
1.3.4.8.9
Comparison: Is Value (Solutions)
1.3.4.8.10
Comparison: Longest Common Phrase
1.3.4.8.11
Comparison: Longest Common Phrase Percentage
1.3.4.8.12
Comparison: Longest Common Substring
1.3.4.8.13
Comparison: Longest Common Substring Percentage
1.3.4.8.14
Comparison: Longest Common Substring Sum
1.3.4.8.15
Comparison: Longest Common Substring Sum Percentage
1.3.4.8.16
Comparison: Similar Date
1.3.4.8.17
Comparison: Starts With
1.3.4.8.18
Comparison: Word Edit Distance
1.3.4.8.19
Comparison: Word Match Count
1.3.4.8.20
Comparison: Word Match Percentage
1.3.4.8.21
Comparison: Word Starts With In Common
1.3.4.8.22
Comparison: Date Too Different (Solutions)
1.3.4.8.23
Comparison: Date Difference
1.3.4.8.24
Comparison: Date Edit Distance
1.3.4.8.25
Comparison: Date Transposition Match
1.3.4.8.26
Comparison: Exact Date Match
1.3.4.8.27
Comparison: Year Too Different
1.3.4.8.28
Comparison: Absolute Difference
1.3.4.8.29
Comparison: Equals
1.3.4.8.30
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: Generate Initials
1.3.4.9.11
Match Transformation: Last N Characters
1.3.4.9.12
Match Transformation: Lower Case
1.3.4.9.13
Match Transformation: Make Array from String
1.3.4.9.14
Match Transformation: Metaphone
1.3.4.9.15
Match Transformation: Normalize Whitespace
1.3.4.9.16
Match Transformation: Replace
1.3.4.9.17
Match Transformation: Round
1.3.4.9.18
Match Transformation: Round Extra
1.3.4.9.19
Match Transformation: Script
1.3.4.9.20
Match Transformation: Select Array Element
1.3.4.9.21
Match Transformation: Soundex
1.3.4.9.22
Match Transformation: Strip Numbers
1.3.4.9.23
Match Transformation: Strip Words
1.3.4.9.24
Match Transformation: Trim Whitespace
1.3.4.9.25
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.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.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.2
Using Job Triggers
1.14.3
Externalizing Jobs
1.14.4
Execution Options
1.14.5
Job Notifications
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.6
Monitoring Real-Time Processes
Scripting on this page enhances content navigation, but does not change the content in any way.