Siebel Data Quality Administration Guide > Configuring Data Quality > Process of Configuring Data Synchronization Between Siebel and Oracle Data Quality Matching Server >

Configuring the Data Source


Use the following procedure to configure the data source definition (or EBC table) required to synchronize data between the Siebel application and Oracle Data Quality Matching Server. This task is a step in Process of Configuring Data Synchronization Between Siebel and Oracle Data Quality Matching Server.

To configure the data source definition

  1. In your Siebel application, navigate to Administration - Server Configuration, Enterprises, and then Profile Configuration view.
  2. Copy an existing InfraDatasources named subsystem type.
  3. Change the Profile and Alias properties to the Data Source name (ISSDataSrc) configured in Siebel Tools.
  4. Update the profile parameters to correspond to the external RDBMS:
    • DSConnectString: This is the data source connect string.

      For the Microsoft SQL Server or the IBM DB2 databases, create an ODBC or equivalent connection and input the name of the connection in the parameter. For an Oracle RDBMS, specify the TNS name associated with the database, and not an ODBC or other entry.

    • DSSSQLStyle: This is the database SQL type.
    • DSDLLName: This is the DLL Name corresponding to the SQL type.
    • DSTableOwner: This is the data source table owner.
    • DSUsername: This is the default user name used for connections (Optional).
    • DSPassword: This is the default password used for connections (Optional).
Siebel Data Quality Administration Guide Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.