Oracle Enterprise Data Quality (OEDQ) - Siebel Configuration (high Level)

1.       Server Configuration:

  Navigate >>   Administration >> Server Configuration

  Click on Enterprise (tab) >> component Group (select)

  Query for “Data Quality” component group [enable component group if not enabled]

  

2.       Select parameter Tab (for component:  Data Quality)

  Query >> DeDuplication Enable Flag>> enter the value:  True

  Query >> DeDuplication Data Type>> enter the value:  EDQ

  Query >> Data Cleansing Enable Flag>> enter the value:  True

  Query >> Data Cleansing Type >> enter the value:  EDQ

3.       Repeat the step 2 :  for other components as well e.g UCM Object Manager

4.       User Preferences:

  Select Tools (menu) >> User Preferences

  Click on << Data Quality>> tab

    Enable as follows:

    Enable DeDuplication = Yes

    Enable Data Cleansing = Yes

5.       Data Quality Administration

  Navigate >> Administration - Data Quality screen

  Click <<Data Quality Settings>> tab and enable following parameters

Enable DataCleansing = Yes

Enable DeDuplication = Yes

Force User DeDupe - Account = Yes

6.       Navigate >> Administration - Data Quality screen

  Click <<Data Quality Settings>> tab and add new vendor entry as suggested by Oracle.

7.       Create  Staging tables (for batch and Health Check only)

    SIEBEL_ACCOUNT_CANDIDATES

    SIEBEL_ACCOUNT_MATCHES

    SIEBEL_CONTACT_CANDIDATES

    SIEBEL_CONTACT_MATCHES

    SIEBEL_PROSPECT_CANDIDATES

    SIEBEL_PROSPECT_MATCHES

    SIEBEL_ACCOUNT_HEALTH_CHECK

    SIEBEL_CONTACT_HEALTH_CHECK

8.       Key Generation ( for existing records) before using

  Navigate >> Administration > Server >> Jobs

    Generate account keys

    Generate contact keys

    Generate prospect keys

.