Siebel Data Quality Administration Guide
What's New in This Release
Back to top
Overview of Siebel Data Quality
Data Cleansing and Data Matching
Siebel Data Quality Modes of Operation
The SDQ Product Modules
The SDQ Matching Server
The SDQ Universal Connector
SDQ Product Module Comparison
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
The SDQ Matching Server Libraries
Upgrading the SDQ Matching Server from Version 7.7
Installing the SDQ Universal Connector
Installing Third-Party Software for Use with the Universal Connector
Installing Third-Party Application Software for Use with the Universal Connector
Installing Third-Party Data Cleansing Files for Use with the Universal Connector
The 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
Disabling Data Matching and Cleansing Without Restarting the Siebel Server
Enabling Siebel Data Quality at the Object Manager Level
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
Using Siebel Data Quality
Real-Time Data Cleansing and Data Matching
Batch Data Cleansing and Data Matching
Data Quality Batch Job Parameters
Cleansing Data Using Batch Jobs
Generating or Refreshing Keys Using Batch Jobs
Matching Data Using Batch Jobs
Example of Batch Data Matching Using the Matching Server
Example of Batch Data Matching Using the Universal Connector
Customizing Data Quality Server Component Jobs for Batch Mode
Sample SDQ Component Customizations for Batch Mode
Merging of Duplicate Records
Sequenced Merges
Process of Merging Duplicate Records
Filtering Duplicate Records
Merging Duplicate Records
Using Fuzzy Query
Example of Enabling and Using Fuzzy Query with Accounts
Troubleshooting Siebel Data Quality
Back to top
Configuring Siebel Data Quality
Siebel Data Quality Configuration Overview
Preconfigured SDQ Connector mappings
Mapping of Connector Fields to Business Component Fields
Mapping Data Matching Connector Fields to Siebel Business Components
Data Matching Field Mapping Syntax for the Matching Server
Data Matching Field Mapping Syntax for the Universal Connector
Example of Adding a Field Mapping for Data Matching with the Universal Connector
Mapping Data Cleansing Connector Fields to Siebel Business Component Fields
Data Cleansing Field Mapping Syntax
Deactivating SDQ Field Mappings
Process of Configuring New SDQ Connectors for the Universal Connector
Registering New SDQ Connectors
Library Base Name User Properties
Configuring Business Components for Data Matching and Data Cleansing
Example of Configuring a Business Component for Data Matching Using SSA-NAME3
Example of Configuring Business Components for Data Matching Using Third-Party Software and Universal Connector
Example of Configuring Business Components for Data Cleansing Using Third-Party Software and Universal Connector
Configuring the Pop-Up Windows Displayed in Real-Time Data Matching
Configuring the Mandatory Fields for Fuzzy Query
Match Purpose
Configuring Match Purpose
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
Invoking Siebel Data Quality from External Callers
Invocation of SDQ from External Callers
Scenario for Data Matching Using the Value Match Method
Value Match Method
Scenario for Data Cleansing Using Data Cleansing Business Service Methods
Get Siebel Fields Method
Parse Method
Parse All Method
Back to top
Preconfigured Matching Server Properties and Field Mapping Values
Preconfigured Matching Server Properties
Preconfigured SSA Field Mappings
Viewing Preconfigured SSA Field Mappings
Preconfigured Account Business Component Field Mappings
Preconfigured Contact Business Component User Properties
Preconfigured List Mgmt Prospective Contact Business Component Field Mappings
Back to top
Universal Connector API
Vendor Dynamic Link Libraries
Terminology
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
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
Example of Universal Connector Properties and Field Mapping Values
Preconfigured Connector Properties
Viewing Preconfigured Connector Properties
Preconfigured Business Service Properties (7.8.2.2)
Preconfigured Business Service Properties (7.8.2)
Preconfigured Field Mappings
Viewing Preconfigured Field Mappings
Preconfigured Business Component User Properties (7.8.2.2)
Preconfigured Business Component User Properties (7.8.2)
Back to top
Finding and Using Siebel Data Quality Information
Important Siebel Data Quality Resources
Technical Documentation
SDQ Seed Data
Back to top
|