Contents
1 What’s New in This Release
- What’s New in Siebel Data Quality Administration Guide, Siebel CRM 21.4 Update
- What’s New in Siebel Data Quality Administration Guide, Siebel CRM 20.1 Update
- What’s New in Siebel Data Quality Administration Guide, Siebel CRM 19.1 Update
2 Overview of Data Quality
- Overview of Data Quality
- Data Profiling
- Data Parsing and Standardization
- Data Matching and Data Cleansing
- Data Quality Products for Data Matching and Data Cleansing
- How Data Quality Relates to Other Entities in Siebel CRM
3 Data Quality Concepts
- Data Quality Concepts
- Data Cleansing
- Data Matching
- Match Key Generation
- Identification of Candidate Records
- Calculation of Match Scores
- Displaying Duplicates
- Fuzzy Query
4 Installing Data Quality Products
- Installing Data Quality Products
- Process of Installing the Oracle Data Quality Matching Server
- Setting Up the Environment and the Database
- Installing Oracle Data Quality Matching Server
- Creating Database Users and Tables for Oracle Data Quality Matching Server
- Configuring Oracle Data Quality Matching Server
- Modifying Configuration Parameters for Oracle Data Quality Matching Server
- Deploying Workflows for Oracle Data Quality Matching Server Integration
- Initial Loading of Siebel Data into Oracle Data Quality Matching Server Tables
- Process of Installing the Oracle Data Quality Address Validation Server
- Installing the Universal Connector
5 Enabling and Disabling Data Matching and Data Cleansing
- Enabling and Disabling Data Matching and Data Cleansing
- Levels of Enabling and Disabling Data Cleansing and Data Matching
- Enabling Data Quality at the Enterprise Level
- Specifying Data Quality Settings
- Enabling Data Quality at the Object Manager Level
- Enabling Data Quality at the User Level
- Disabling Data Cleansing for Specific Records
- Enabling and Disabling Fuzzy Query
- Identifying Mandatory Fields for Fuzzy Query
6 Configuring Data Quality
- Configuring Data Quality
- Data Quality Configuration Overview
- Process of Configuring New Data Quality Connectors
- Configuring Vendor Parameters
- Mapping of Vendor Fields to Business Component Fields
- Example Configurations for Data Quality
- Configuring a New Field for Real-Time Data Matching
- Incremental Data Load
- Process of Configuring Data Synchronization Between Siebel and Oracle Data Quality Matching Server
- Configuring Deduplication Against Multiple Addresses
- Configuring Multiple Language Support for Data Matching
- Configuring Multiple Mode Support for Data Matching
- Configuring the Windows Displayed in Real-Time Data Matching
- Configuring the Mandatory Fields for Fuzzy Query
- Data Quality User Properties
- Account - Business Component User Properties
- Contact - Business Component User Properties
- List Mgmt Prospective Contact - Business Component User Properties
- DeDuplication - Business Service User Properties
- Data Cleansing - Business Service User Properties
- DQ Sync Services - Business Service User Properties
- ISS System Services - Business Services User Properties
7 Administering Data Quality
- Administering Data Quality
- Data Quality Modes of Operation
- Data Quality Rules
- Data Quality Batch Job Parameters
- Cleansing Data Using Batch Jobs
- Matching Data Using Batch Jobs
- Merge Algorithm in the Object Manager Layer
- Merging of Duplicate Records
- Process of Merging Duplicate Records
- Using Fuzzy Query
- Calling Data Matching and Data Cleansing from Scripts or Workflows
- Troubleshooting Data Quality
8 Optimizing Data Quality Performance
- Optimizing Data Quality Performance
- Optimizing Data Cleansing Performance
- Optimizing Data Matching Performance
9 Universal Connector API
- Universal Connector API
- About the Terminology in This Chapter
- Vendor Libraries
- Connector Initialization and Termination Functions
- Session Initialization and Termination Functions
- Parameter Setting Functions
- Error Message Function
- Real-Time Data Matching Functions
- Batch Mode Data Matching Functions
- Real-Time Data Cleansing Function
- Batch Mode Data Cleansing Function
- Data Matching and Data Cleansing Algorithms
10 Examples of Parameter and Field Mapping Values for Universal Connector
- Examples of Parameter and Field Mapping Values for Universal Connector
- Viewing Parameter and Field Mapping Values for Universal Connector
- Universal Connector Parameter and Field Mapping Values for Oracle Data Quality Matching Server
- Universal Connector Parameter and Field Mapping Values for Oracle Data Quality Address
Validation Server
- Preconfigured Vendor Parameters for Oracle Data Quality Address Validation Server
- Preconfigured Field Mappings for Oracle Data Quality Address Validation Server
- Preconfigured Field Mappings for Business Component - Account
- Preconfigured Field Mappings for Business Component - Contact
- Preconfigured Field Mappings for Business Component - List Mgmt Prospective Contact
- Preconfigured Field Mappings for Business Component - CUT Address
- Preconfigured Field Mappings for Business Component - Personal Address
11 Siebel CRM Action Sets
- Siebel CRM Action Sets
- Siebel CRM DQ Sync Action Sets
- Siebel CRM ISSSYNC Action Sets
- Activating Action Sets in Siebel CRM
12 Sample Configuration and Script Files
- Sample Configuration and Script Files
- Sample Configuration Files
- Sample SQL Scripts
- Sample SiebelDQ.sdf File