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