|
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 Business 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
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 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
Using Siebel Data Quality
Real-Time Data Cleansing and Data Matching
Batch Data Cleansing and Data Matching
Data Quality Rules
Creating a Data Quality Rule
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
Field Characteristics for Sequenced Merges
Process of Merging Duplicate Records
Filtering Record Duplicates
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
Configuring Vendor Parameters
Mapping of Vendor Fields to Business Component Fields
Mapping Data Matching Vendor Fields to Siebel Business Components
Example of Adding a Field Mapping for Data Matching with the Universal Connector
Mapping Data Cleansing Vendor Fields to Siebel Business Component Fields
Process of Configuring New SDQ Connectors for the Universal Connector
Registering New SDQ Connectors
Configuring Business Components for Data Matching and Data Cleansing
Example Configurations
Configuring Business Components for Data Matching Using the Matching Server
Configuring Business Components for Data Matching Using Third-Party Software and Universal Connector
Configuring Business Components for Data Cleansing Using Third-Party Software and Universal Connector
Configuring the Pop-Up Windows Displayed in Real-Time Data Matching
Changing a Pop-Up Window Name
Adding a Deduplication Pop-Up Window for an Applet
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
Finding and Using Siebel Data Quality Information
Important Siebel Data Quality Resources
SDQ Seed Data
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
Back to top
Preconfigured Matching Server Parameter and Field Mapping Values
Preconfigured Matching Server Parameters
Viewing Preconfigured SSA Vendor Parameters
Preconfigured SSA Vendor Parameters
Preconfigured Field Mappings
Viewing Preconfigured SSA Field Mappings
Preconfigured SSA Field Mappings
Back to top
Example of Universal Connector Parameter and Field Mapping Values
Preconfigured Universal Connector Parameters
Viewing Preconfigured Firstlogic Vendor Parameters
Preconfigured Firstlogic Vendor Parameters
Preconfigured Field Mappings
Viewing Preconfigured Firstlogic Field Mappings
Preconfigured Firstlogic Field Mappings
Back to top
Setting Up Third-Party Identity Search Server Software for Data Matching
About Identity Search Server
Process of Setting Up Identity Search Server for Data Matching
Installing Identity Search Server
Software Prerequisites for Identity Search Server
Creating Database Users and Tables for ISS
Obtaining the Universal License Key
Applying the Universal Data Quality Patch
Configuring Identity Search Server
Configuring the Siebel Application for Identity Search Server
Configuring Siebel Tools for Identity Search Server
Configuring the Siebel Business Application for Identity Search Server
Modifying ssadq_cfg.xml
Deploying and Activating Workflows for Identity Search Server Integration
Initial Loading of Siebel Data into Identity Search Server Tables
Synchronizing Siebel Data with Identity Search Server Tables
Siebel Business Application Action Sets for Account
Siebel Business Application Action Sets for Contact
Siebel Business Application Action Sets for List Mgmt Prospective Contact
Siebel Business Application Generic Action Sets
Testing Identity Search Server Setup for Data Matching
Back to top
Universal Connector API
Vendor 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
| 
