1. Data Quality for Oracle Customer Hub Guide
  2. Configuring Oracle Data Quality Matching Server on Microsoft Windows

Configuring Oracle Data Quality Matching Server on Microsoft Windows

Use the following procedure to configure Oracle Data Quality Matching Server on Microsoft Windows.

To configure Oracle Data Quality Matching Server for data matching on Microsoft Windows

  1. If required, modify the odbc.ini file located at <drive>:\<IIR_Installation_Folder>\InformaticaIR\bin\ to contain the ODBC connection string of your target database, for example, as follows:

    [Target]
ssadriver=ssaoci9
server=qa19b_sdchs20n519

    Creating Database Users and Tables for Oracle Data Quality Matching Server describes the ODBC drivers required for different operating systems.

    Note: For an Oracle database, the server parameter specifies a connect string from the tnsnames.ora file (which is the network configuration file of the Oracle database client). For other databases, the server contains the ODBC datasource name (DSN).

    The database information that you enter when installing Oracle Data Quality Matching Server is reflected in the odbc.ini file. If all values are correct and you do not want to make any changes to the database information, then you can skip this step.

  2. Copy the SiebelDQ.sdf file to the following (IIR server) folder location: 

    <Drive>:\<IIR_Installation_Folder>\InformaticaIR\ids
    Note: For an example SDF file, see Sample SiebelDQ.sdf File.

  3. To use the XML Sync Server instead of the External Business Components for Informatica Identity Resolution, then activate or deactivate the following ports located in <Drive>:\<IIR_Installation_Folder>\env\isss.bat.

    ::set SSA_XSPORT=1671
::set SSA_XSHOST=localhost:1671

    Removing the double colon from the beginning of the line activates the process listening on the ports: 

    set SSA_XSHOST=localhost:1671
set SSA_XSPORT=1671
    Note: For Informatica Identity Resolution Version 2.7, you turn on the XML Sync Server by modifying the idsenvs.bat file located in <Drive>:\<ISS Installation Folder>\iss2704s\bin.

  4. Create a tmp folder for the IIR Synchronizer Workflow Log in <Drive>:\<IIR_Installation_Folder>\InformaticaIR\. For example:

    C:\InformaticIR\tmp
    Note: If you install Oracle Data Quality Matching Server on a different drive (other than C:\), you must modify the ISSErrorHandler workflow in your Siebel application to specify the correct log folder. Other modifications that must be made if you install Oracle Data Quality Matching Server on a drive other than C:\ include modifying action sets and the location where you deploy the XML files.

  5. Start the IIR Server by navigating to, for example, the following:

    Programs, Informatica, Identity Resolution V2.8.07 (InformaticaIR), Informatica Identity Resolution, Informatica IR Server - Start(Configure Mode)

    Note: You can also start the Informatica Identity Resolution server from the command prompt using the idsup command.

  6. Start the IIR Console Client (in Admin Mode) by navigating to, for example, the following:

    Programs, Informatica, Identity Resolution V2.8.07 (InformaticaIR), Informatica Identity Resolution, Informatica IR Console Client - Start(Admin Mode)

  7. Create a new system in IIR using SiebelDQ.sdf.

    The system that you create in IIR (Console Client, Admin Mode) will hold all the IDT and IDX database tables.

  8. When the system is created (initially, it will be empty), run LoadIDT from the IIR Console Client. For more information, see Initial Loading of Siebel Data into Oracle Data Quality Matching Server Tables.