Table of Contents
- Title and Copyright Information
- Preface
-
1
Oracle Enterprise Data Quality Applications Help Topics
- 1.1 Welcome to EDQ
-
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.3 Dashboard
- 1.2.4 Match Review
-
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.3
Using Case Management
-
1.2.5.3.1
Editing Cases and Alerts
- 1.2.5.3.1.1 Changing the States of Cases and Alerts
- 1.2.5.3.1.2 Assigning Cases and Alerts
- 1.2.5.3.1.3 Adding Comments to Cases and Alerts
- 1.2.5.3.1.4 Editing and Deleting Comments
- 1.2.5.3.1.5 Adding Attachments to Cases and Alerts
- 1.2.5.3.1.6 Editing and Deleting Attachments
- 1.2.5.3.1.7 Editing Case and Alerts Details
- 1.2.5.3.2 Working with Filters
- 1.2.5.3.3 Export to Excel
- 1.2.5.3.4 Making Bulk Edits
-
1.2.5.3.1
Editing Cases and Alerts
-
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.5.1
Case Management Concepts
- 1.2.6 Configuration Analysis
- 1.2.7 Issue Manager
- 1.2.8 Web Service Tester
- 1.2.9 How To Topics
-
1.2.1
Director
-
1.3
Processor Library
- 1.3.1 Advanced Processors
-
1.3.2
Audit Processors
- 1.3.2.1 Business Rules Check
- 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
Match Processors
- 1.3.3.1 Advanced Match
- 1.3.3.2 Consolidate
- 1.3.3.3 Deduplicate
- 1.3.3.4 Enhance
- 1.3.3.5 Group and Merge
- 1.3.3.6 Link
- 1.3.3.7 Advanced Options for Match Processors
-
1.3.3.8
List of Comparisons
- 1.3.3.8.1 Comparison: ALL in List
- 1.3.3.8.2 Comparison: Both Fields Null (Solutions)
- 1.3.3.8.3 Comparison: Character Edit Distance
- 1.3.3.8.4 Comparison: Character Match Percentage
- 1.3.3.8.5 Comparison: Character Transposition Match
- 1.3.3.8.6 Comparison: Contains
- 1.3.3.8.7 Comparison: Equal or One/Both Fields Null (Solutions)
- 1.3.3.8.8 Comparison: Exact String Match
- 1.3.3.8.9 Comparison: In List
- 1.3.3.8.10 Comparison: Is Value (Solutions)
- 1.3.3.8.11 Comparison: Longest Common Phrase
- 1.3.3.8.12 Comparison: Longest Common Phrase Percentage
- 1.3.3.8.13 Comparison: Longest Common Substring
- 1.3.3.8.14 Comparison: Longest Common Substring Percentage
- 1.3.3.8.15 Comparison: Longest Common Substring Sum
- 1.3.3.8.16 Comparison: Longest Common Substring Sum Percentage
- 1.3.3.8.17 Comparison: Similar Date
- 1.3.3.8.18 Comparison: Starts With
- 1.3.3.8.19 Comparison: Word Edit Distance
- 1.3.3.8.20 Comparison: Word Match Count
- 1.3.3.8.21 Comparison: Word Match Percentage
- 1.3.3.8.22 Comparison: Word Starts With In Common
- 1.3.3.8.23 Comparison: Date Too Different (Solutions)
- 1.3.3.8.24 Comparison: Date Difference
- 1.3.3.8.25 Comparison: Date Edit Distance
- 1.3.3.8.26 Comparison: Date Transposition Match
- 1.3.3.8.27 Comparison: Exact Date Match
- 1.3.3.8.28 Comparison: Year Too Different
- 1.3.3.8.29 Comparison: Absolute Difference
- 1.3.3.8.30 Comparison: Equals
- 1.3.3.8.31 Comparison: Percent Difference
-
1.3.3.9
List of Matching Transformations
- 1.3.3.9.1 Match Transformation: Absolute Value
- 1.3.3.9.2 Match Transformation: Character Replace
- 1.3.3.9.3 Match Transformation: Convert Date to String
- 1.3.3.9.4 Match Transformation: Convert Number to String
- 1.3.3.9.5 Match Transformation: Convert String to Date
- 1.3.3.9.6 Match Transformation: Convert String to Number
- 1.3.3.9.7 Match Transformation: Denoise
- 1.3.3.9.8 Match Transformation: First N Characters
- 1.3.3.9.9 Match Transformation: First N Words
- 1.3.3.9.10 Match Transformation: Last N Words
- 1.3.3.9.11 Match Transformation: Generate Initials
- 1.3.3.9.12 Match Transformation: Last N Characters
- 1.3.3.9.13 Match Transformation: Lower Case
- 1.3.3.9.14 Match Transformation: Make Array from String
- 1.3.3.9.15 Match Transformation: Metaphone
- 1.3.3.9.16 Match Transformation: Normalize Whitespace
- 1.3.3.9.17 Match Transformation: Replace
- 1.3.3.9.18 Match Transformation: Round
- 1.3.3.9.19 Match Transformation: Round Extra
- 1.3.3.9.20 Match Transformation: Script
- 1.3.3.9.21 Match Transformation: Select Array Element
- 1.3.3.9.22 Match Transformation: Soundex
- 1.3.3.9.23 Match Transformation: Strip Numbers
- 1.3.3.9.24 Match Transformation: Strip Words
- 1.3.3.9.25 Match Transformation: Trim Whitespace
- 1.3.3.9.26 Match Transformation: Upper Case
-
1.3.3.10
List of Output Selectors
- 1.3.3.10.1 Output Selector: Average
- 1.3.3.10.2 Output Selector: Delimited List
- 1.3.3.10.3 Output Selector: Earliest Value
- 1.3.3.10.4 Output Selector: First Non-empty Value
- 1.3.3.10.5 Output Selector: Highest Value
- 1.3.3.10.6 Output Selector: Latest Value
- 1.3.3.10.7 Output Selector: Longest String
- 1.3.3.10.8 Output Selector: Lowest Value
- 1.3.3.10.9 Output Selector: Most Common Value
- 1.3.3.10.10 Output Selector: Standard Deviation
- 1.3.3.10.11 Output Selector: Sum Values
- 1.3.3.10.12 Output Selector: Value from Highest
- 1.3.3.10.13 Output Selector: Value from Lowest
- 1.3.3.11 Subprocessors available for Match Processors
- 1.3.4 Maths Processors
- 1.3.5 Product Data Processors
-
1.3.6
Profilers
- 1.3.6.1 Character Profiler
- 1.3.6.2 Contained Attributes Profiler
- 1.3.6.3 Data Types Profiler
- 1.3.6.4 Date Profiler
- 1.3.6.5 Equal Attributes Profiler
- 1.3.6.6 Frequency Profiler
- 1.3.6.7 Length Profiler
- 1.3.6.8 Min/Max Profiler
- 1.3.6.9 Number Profiler
- 1.3.6.10 Patterns Profiler
- 1.3.6.11 Quickstats Profiler
- 1.3.6.12 Record Completeness Profiler
- 1.3.6.13 Record Duplication Profiler
- 1.3.6.14 RegEx Patterns Profiler
- 1.3.7 Read and Write Processors
- 1.3.8 Text Analysis Processors
- 1.3.9 Third-party Processors
-
1.3.10
Transformation Processors
- 1.3.10.1 Add Current Date
- 1.3.10.2 Add Date Attribute
- 1.3.10.3 Add Numeric Attribute
- 1.3.10.4 Add String Attribute
- 1.3.10.5 Call External Web Service
- 1.3.10.6 Character Replace
- 1.3.10.7 Concatenate
- 1.3.10.8 Convert Date to String
- 1.3.10.9 Convert Number to String
- 1.3.10.10 Convert Number to Date
- 1.3.10.11 Convert String to Date
- 1.3.10.12 Convert String to Number
- 1.3.10.13 Date Difference
- 1.3.10.14 Denoise
- 1.3.10.15 Enhance from Map
- 1.3.10.16 Extract Values
- 1.3.10.17 Extract Attributes
- 1.3.10.18 Make Attribute Arrays
- 1.3.10.19 Generate Initials
- 1.3.10.20 Hash Generator
- 1.3.10.21 Lookup and Return
- 1.3.10.22 Lower Case
- 1.3.10.23 Make Array from Inputs
- 1.3.10.24 Make Array from String
- 1.3.10.25 Merge Attributes
- 1.3.10.26 Metaphone
- 1.3.10.27 Normalize No Data
- 1.3.10.28 Normalize Whitespace
- 1.3.10.29 Pattern Transform
- 1.3.10.30 Proper Case
- 1.3.10.31 RegEx Match
- 1.3.10.32 RegEx Replace
- 1.3.10.33 RegEx Split
- 1.3.10.34 Replace
- 1.3.10.35 Replace All
- 1.3.10.36 Return Array Size
- 1.3.10.37 Select Array Element
- 1.3.10.38 Soundex
- 1.3.10.39 Split Records from Array
- 1.3.10.40 Strip Numbers
- 1.3.10.41 Strip Words
- 1.3.10.42 Transliterate
- 1.3.10.43 Trim Characters
- 1.3.10.44 Trim Whitespace
- 1.3.10.45 Upper Case
- 1.3.10.46 Add Date Array Attribute
- 1.3.10.47 Add Numeric Array Attribute
- 1.3.10.48 Add String Array Attribute
- 1.3.10.49 Concatenate Arrays
- 1.3.10.50 Concatenate String to Array
- 1.3.10.51 Cross Array Element Update
- 1.3.10.52 Deduplicate Array
- 1.3.10.53 Find Matched Array Elements
- 1.3.10.54 Get Message Header Number
- 1.3.10.55 Get Message Header String
- 1.3.10.56 Merge Array Attributes
- 1.3.10.57 Sort Array
- 1.3.10.58 Split Array
- 1.3.10.59 Strip Strings From Array by Length
- 1.3.10.60 Trim Array
- 1.3.11 Expression Notes
- 1.3.12 Grouping Processors
- 1.3.13 Processor Families
- 1.3.14 Processor States
- 1.4 Projects
- 1.5 Data Stores
- 1.6 Reference Data
- 1.7 Published Processors
- 1.8 Images
- 1.9 Staged Data
- 1.10 Data Interfaces
- 1.11 Processes
- 1.12 Results Books
- 1.13 External Tasks
- 1.14 Jobs
- 1.15 Exports
- 1.16 Notes
- 1.17 Web Services
- 1.18 Issues
- 1.19 Snapshots
- 1.20 Working with Long Text
-
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
Stored Credentials
-
2.1.2.4.1
Creating Stored Credentials
- 2.1.2.4.1.1 Creating OCI Stored Credentials
- 2.1.2.4.1.2 Creating AWS Stored Credentials
- 2.1.2.4.1.3 Creating AWS Roles Anywhere Stored Credentials
- 2.1.2.4.1.4 Creating Azure Storage Credentials
- 2.1.2.4.1.5 Creating OAuth2 Client Credentials
- 2.1.2.4.1.6 Creating Google Cloud Platform Stored Credentials
- 2.1.2.4.2 Editing Stored Credentials
- 2.1.2.4.3 Deleting Stored Credentials
-
2.1.2.4.1
Creating Stored Credentials
- 2.1.2.5 Users
- 2.1.2.6 Groups
- 2.1.2.7 External Groups
- 2.1.2.8 Sessions
- 2.1.3 Web Services
- 2.1.4 Extending EDQ
- 2.1.5 Project Specific Landing Areas
- 2.1.6 Monitoring Real-Time Processes
-
2.1
EDQ Administration