Siebel Data Quality Administration Guide
What's New in This Release
Back to top
Overview of Data Quality
Data Profiling
Data Parsing and Standardization
Data Matching and Data Cleansing
Data Quality Products for Data Matching and Data Cleansing
Oracle Data Quality Matching Server
Oracle Data Quality Address Validation Server
Universal Connector
How Data Quality Relates to Other Entities in Siebel Business Applications
Back to top
Data Quality Concepts
Data Cleansing
Data Matching
Match Key Generation
Match Key Generation with the Oracle Data Quality Matching Server
Match Key Generation Using the Universal Connector with Third-Party Data Quality Vendors
Identification of Candidate Records
Calculation of Match Scores
Displaying Duplicates
Fuzzy Query
Back to top
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 Oracle Data Quality Address Validation Server
Modifying Configuration Parameters for Oracle Data Quality Address Validation Server
Acquiring the License Key and Postal Directories for Oracle Data Quality Address Validation Server
Installing the Universal Connector
Back to top
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 Using the GUI
Enabling Data Quality Using the Command-Line Interface
Enabling 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 Data Quality
Data Quality Configuration Overview
Process of Configuring New Data Quality Connectors
Registering New 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
Adding a Field Mapping for Data Matching
Mapping Data Cleansing Vendor Fields to Siebel Business Component Fields
Example Configurations for Data Quality
Configuring Data Quality for Oracle Data Quality Matching Server
Configuring Siebel Business Applications for the Oracle Data Quality Address Validation Server
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 the Data Source
Configuring Object Managers for ISS Data Source
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
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
Back to top
Administering Data Quality
Data Quality Modes of Operation
Real-Time Data Cleansing and Data Matching
Batch Data Cleansing and Data Matching
Data Quality Rules
Data Quality Batch Job Parameters
Cleansing Data Using Batch Jobs
Matching Data Using Batch Jobs
Example of Batch Data Matching Using the Universal Connector
Generating or Refreshing Keys 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 Data Quality
Back to top
Optimizing Data Quality Performance
Optimizing Data Cleansing Performance
Optimizing Data Matching Performance
Back to top
Universal Connector API
About the Terminology in This Appendix
Vendor Libraries
Connector Initialization and Termination Functions
Session Initialization and Termination Functions
Parameter Setting Functions
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
Batch Mode Data Cleansing 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 Universal Connector
Viewing Parameter and Field Mapping Values for Universal Connector
Universal Connector Parameter and Field Mapping Values for Oracle Data Quality Matching Server
Preconfigured Vendor Parameters for Oracle Data Quality Matching Server
Preconfigured Field Mappings 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
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
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
Siebel Data Quality
Siebel Data Quality Objects
Back to top
Upgrading to Informatica Identity Resolution 9.01
Upgrading to Informatica Identity Resolution 9.01
Back to top
Finding and Using Data Quality Information
Important Data Quality Resources
Technical Documentation on Oracle Technology Network
Third-Party Documentation
Information about Data Quality on My Oracle Support
Data Quality Seed Data
Back to top
|