Siebel Data Quality Administration Guide
What's New in This Release
Back to top
Overview of Siebel Data Quality
Data Cleansing and Data Matching
Data Quality Product Modules
SDQ Matching Server
SDQ Universal Connector
SDQ Product Module Comparison
ODQ Matching Server
ODQ Address Validation Server
How SDQ Relates to Other Entities in the Siebel Application
Back to top
Siebel Data Quality Concepts
Data Cleansing
Data Matching
Match Key Generation
Match Key Generation with the Universal Connector
Match Key Generation with the Matching Server
Identification of Candidate Records
Identification of Candidate Records with the Universal Connector
Identification of Candidate Records with the Matching Server
Calculation of Match Scores
Calculation of Match Scores with the Universal Connector
Calculation of Match Scores with the Matching Server
Displaying of Duplicates
Data Model for the SDQ Matching Server
Fuzzy Query
Back to top
Installing and Upgrading Siebel Data Quality
Installing the SDQ Matching Server
SDQ Matching Server Libraries
Upgrading the SDQ Matching Server from Siebel CRM Version 7.7
Installing the SDQ Universal Connector
Installing Third-Party Software for Use with the Universal Connector
SDQ Universal Connector Libraries
Back to top
Enabling and Disabling Data Matching and Data Cleansing
Levels of Enabling and Disabling Data Cleansing and Data Matching
Enabling Siebel Data Quality at the Enterprise Level
Specifying Data Quality Settings
Enabling Siebel Data Quality at the Object Manager Level
Enabling SDQ Using the GUI
Enabling SDQ Using the Command-Line Interface
Enabling Siebel Data Quality at the User Level
Disabling Data Cleansing for Specific Records
Enabling and Disabling Fuzzy Query
Identifying Mandatory Fields for Fuzzy Query
Back to top
Configuring Siebel Data Quality
Siebel Data Quality Configuration Overview
Process of Configuring New SDQ Connectors for the Universal Connector
Registering New SDQ Connectors
Configuring Business Components and Applets for Data Matching and Data Cleansing
Configuring Vendor Parameters
Mapping of Vendor Fields to Business Component Fields
Mapping Data Matching Vendor Fields to Siebel Business Components
Adding a Field Mapping for Data Matching
Mapping Data Cleansing Vendor Fields to Siebel Business Component Fields
Configuring Business Components for Data Matching Using the Matching Server
Using Siebel Business Applications to Configure a Business Component for Data Matching with SSA
Using Siebel Tools to Configure a Business Component for Data Matching with SSA
Configuring the Windows Displayed in Real-Time Data Matching
Changing a Window Name
Adding a Deduplication Window for an Applet
Configuring Real-Time Deduplication Window for Child Applets
Configuring the Mandatory Fields for Fuzzy Query
Match Purpose
Siebel Data Quality User Properties
Deduplication User Properties
Data Cleansing User Properties
Back to top
Using Siebel Data Quality
Siebel Data Quality Modes of Operation
Real-Time Data Matching and Cleansing
Batch Data Matching and Data Cleansing
Data Quality Batch Job Parameters
Cleansing Data Using Batch Jobs
Generating or Refreshing Keys Using Batch Jobs
Matching Data Using Batch Jobs
Customizing Data Quality Server Component Jobs for Batch Mode
Data Quality Rules
Merge Algorithm in the Object Manager Layer
Example of the Merge Records Process
Overview of Merge Algorithm
Merging of Duplicate Records
Sequenced Merges
Field Characteristics for Sequenced Merges
Process of Merging Duplicate Records
Filtering Record Duplicates
Merging Duplicate Records
Using Fuzzy Query
Calling Data Matching and Data Cleansing from Scripts or Workflows
Scenario for Data Matching Using the Value Match Method
Scenario for Data Cleansing Using Data Cleansing Business Service Methods
Deduplication Business Service Methods
Data Cleansing Business Service Methods
Troubleshooting Siebel Data Quality
Back to top
Optimizing Siebel Data Quality Performance
Optimizing Data Cleansing Performance
Optimizing Data Matching Performance
Optimizing Matching Server Performance
Database Table Considerations
Data Quality Manager Server Tasks
Data Quality Settings
Back to top
Setting Up Oracle Data Quality Matching Server for Data Matching
Process of Setting Up ODQ Matching Server for Data Matching
Setting Up the Environment and the Database
Creating Database Users and Tables for ODQ Matching Server
Installing ODQ Matching Server
Configuring ODQ Matching Server
Configuring the Siebel Application for ODQ Matching Server
Obtaining the ODQ Matching Server License Key
Applying the Universal Data Quality Patch
Modifying Configuration Parameters for ODQ Matching Server
Deploying and Activating Workflows for ODQ Matching Server Integration
Initial Loading of Siebel Data into ODQ Matching Server Tables
Synchronizing Siebel Data with ODQ Matching Server Tables
Back to top
Examples of Parameter and Field Mapping Values for Universal Connector
About Parameter and Field Mapping Values for Universal Connector
Universal Connector Parameter and Field Mapping Values for ODQ Matching Server
Preconfigured Vendor Parameters for ODQ Matching Server
Preconfigured Field Mappings for ODQ Matching Server
Universal Connector Parameter and Field Mapping Values for ODQ Address Validation Server
Preconfigured Vendor Parameters for ODQ Address Validation Server
Preconfigured Field Mappings for ODQ Address Validation Server
Back to top
Preconfigured Parameter and Field Mapping Values for SDQ Matching Server
About Parameter and Field Mapping Values for SDQ Matching Server
Preconfigured Vendor Parameters for SSA
Preconfigured Field Mappings for SSA
Back to top
Universal Connector API
Vendor Libraries
Connector Initialization and Termination Functions
sdq_init_connector Function
sdq_shutdown_connector Function
Session Initialization and Termination Functions
sdq_init_session Function
sdq_close_session Function
Parameter Setting Functions
sdq_set_global_parameter Function
sdq_set_parameter Function
Error Message Functions
sdq_get_error_message Function
Real-Time Data Matching Functions
sdq_dedup_realtime Function
sdq_dedup_realtime_nomemory Function
Batch Mode Data Matching Functions
sdq_set_dedup_candidates Function
sdq_start_dedup Function
sdq_get_duplicates Function
Real-Time Data Cleansing Functions
sdq_datacleanse Function
Batch Mode Data Cleansing Functions
sdq_data_cleanse Function
Data Matching and Data Cleansing Algorithms
Batch Data Matching Algorithm
Real-Time Data Matching Algorithm
Batch Data Cleansing Algorithm
Real-Time Data Cleansing Algorithm
Back to top
Siebel Business Applications Action Sets
Setting up Siebel Business Application Action Sets Manually
Siebel Business Applications Action Sets for Account
ISSLoad Account
ISSSYNC DeleteRecord Account
ISSSYNC PreDeleteRecord Account
ISSSYNC PreWriteRecord Account
ISSSYNC WriteRecord Account
Siebel Business Applications Action Sets for Contact
ISSLoad Contact
ISSSYNC DeleteRecord Contact
ISSSYNC PreDeleteRecord Contact
ISSSYNC PreWriteRecord Contact
ISSSYNC WriteRecord Contact
Siebel Business Applications Action Sets for List Mgmt Prospective Contact
ISSLoad List Mgmt Prospective Contact
ISSSYNC DeleteRecord List Mgmt Prospective Contact
ISSSYNC PreDeleteRecord List Mgmt Prospective Contact
ISSSYNC PreWriteRecord List Mgmt Prospective Contact
ISSSYNC WriteRecord List Mgmt Prospective Contact
Siebel Business Applications Generic Action Sets
ISSSYNC WriteRecordNew
ISSSYNC WriteRecordUpdated
Back to top
Finding and Using Siebel Data Quality Information
Important Siebel Data Quality Resources
Technical Documentation on the Oracle Technology Network
Third-Party Documentation
Information about SDQ on My Oracle Support
SDQ Seed Data
Back to top
|