|
Siebel Data Quality Administration Guide
What's New in This Release
Back to top
Overview of Siebel Data Quality
Data Profiling
Data Parsing and Standardization
Data Matching and Data Cleansing
Siebel Data Quality Product Modules for Data Matching and Data Cleansing
ODQ Matching Server
ODQ Address Validation Server
ODQ Universal Connector
How Siebel Data Quality Relates to Other Entities in Siebel Business Applications
Back to top
Siebel Data Quality Concepts
Data Cleansing
Data Matching
Match Key Generation
Identification of Candidate Records
Calculation of Match Scores
Displaying Duplicates
Fuzzy Query
Back to top
Installing Siebel Data Quality Products
Process of Installing the ODQ Matching Server
Setting Up the Environment and the Database
Creating Database Users and Tables for ODQ Matching Server
Installing ODQ Matching Server
Configuring ODQ Matching Server
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
Process of Installing the ODQ Address Validation Server
Installing ODQ Address Validation Server
Modifying Configuration Parameters for ODQ Address Validation Server
Installing the Oracle Data Quality Universal Connector
Oracle Data Quality 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 Using the GUI
Enabling Siebel Data Quality 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 Siebel Data Quality Connectors
Registering New Siebel Data Quality 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
Example of Adding a Field Mapping for Data Matching
Mapping Data Cleansing Vendor Fields to Siebel Business Component Fields
Example Configurations for Siebel Data Quality Product Modules
Configuring Data Quality for ODQ Matching Server
Configuring Siebel Business Applications for the ODQ Address Validation Server
Configuring Business Components for Data Matching Using Third-Party Software
Configuring Business Components for Data Cleansing Using Third-Party Software
Configuring a New Field for Real-Time Data Matching
Incremental Data Load
Configuring the EBC Table
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
Changing a Window Name
Adding a Deduplication Window for an Applet
Configuring a Real-Time Deduplication Window for Child Applets
Configuring the Mandatory Fields for Fuzzy Query
Siebel Data Quality User Properties
DeDuplication CFG File
Deduplication Results BusComp
Filter Characters
Deduplication Results List Applet
Back to top
Using Siebel Data Quality
Data Quality Modes of Operation
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
Matching Data Using Batch Jobs
Customizing Data Quality Server Component Jobs for Batch Mode
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 Duplicate Records
Merging Duplicate Records
Using Fuzzy Query
Using Fuzzy Query for Accounts
Using Fuzzy Query for Contacts
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
Back to top
Using Siebel Data Quality Matching Server for Data Matching and Cleansing
About Siebel Data Quality Matching Server
Installing the Siebel Data Quality Matching Server
Siebel Data Quality Matching Server Libraries
Upgrading the Siebel Data Quality Matching Server from Siebel CRM Version 7.7
Configuring Business Components for Data Matching Using the Siebel Data Quality 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
Match Purpose
Configuring Match Purpose
Example of Batch Data Matching Using the Siebel Data Quality Matching Server
Sample Data Quality Component Customizations for Batch Mode
Sample Component Customization for Data Matching
Sample Component Customization for Data Cleansing
Match Key Generation
Match Key Generation with the Oracle Data Quality Universal Connector
Match Key Generation with the Siebel Data Quality Matching Server
Identification of Candidate Records
Calculation of Match Scores
Generating or Refreshing Keys Using Batch Jobs
Data Model for the Siebel Data Quality Matching Server
Optimizing Siebel Data Quality Matching Server Performance
Database Table Considerations
Data Quality Manager Server Tasks
Data Quality Settings
Preconfigured Parameters for Siebel Data Quality Matching Server
Viewing Preconfigured Vendor Parameters for SSA
Preconfigured Vendor Parameters for SSA
Preconfigured Field Mappings for Siebel Data Quality Matching Server
Viewing Preconfigured Field Mappings 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 Function
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 Function
sdq_datacleanse Function
Batch Mode Data Cleansing Function
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
Examples of Parameter and Field Mapping Values for ODQ Universal Connector
About Parameter and Field Mapping Values for ODQ Universal Connector
ODQ Universal Connector Parameter and Field Mapping Values for Firstlogic
Preconfigured Vendor Parameters for Firstlogic
Preconfigured Field Mappings for Firstlogic
ODQ 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
ODQ 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
Siebel Business Applications Action Sets
Siebel Business Applications DQ Sync Action Sets
DQ Sync Action Sets for Account
DQ Sync Action Sets for Contact
DQ Sync Action Sets for List Mgmt Prospective Contact
Generic DQ Sync Action Sets
Siebel Business Applications ISSSYNC Action Sets
ISSSYNC Action Sets for Account
ISSSYNC Action Sets for Contact
ISSSYNC Action Sets for List Mgmt Prospective Contact
Generic ISSSYNC Action Sets
Activating Action Sets in Your Siebel Business Application
Back to top
Siebel Data Quality Product Module
Back to top
Sample Configuration and Script Files
Sample Configuration Files
ssadq_cfg.xml
ssadq_cfgasm.xml
Sample SQL Scripts
IDS_IDT_ACCOUNT_STG.SQL
IDS_IDT_CONTACT_STG.SQL
IDS_IDT_PROSPECT_STG.SQL
IDS_IDT_CURRENT_BATCH.SQL
IDS_IDT_CURRENT_BATCH_ACCOUNT.SQL
IDS_IDT_CURRENT_BATCH_CONTACT.SQL
IDS_IDT_CURRENT_BATCH_PROSPECT.SQL
IDS_IDT_LOAD_ANY_ENTITY.CMD
IDS_IDT_LOAD_ANY_ENTITY.sh
Sample SiebelDQ.sdf File
Back to top
Finding and Using Data Quality Information
Important Siebel Data Quality Resources
Technical Documentation on Oracle Technology Network
Third-Party Documentation
Information about Siebel Data Quality on My Oracle Support
Siebel Data Quality Seed Data
Back to top
| 
