Installing Oracle Data Quality Matching Server on Microsoft Windows
Use the following procedure to install Oracle Data Quality Matching Server on Microsoft Windows.
To install Oracle Data Quality Matching Server on Microsoft Windows
Run setup from the root directory of the installed product media pack (which you downloaded from Oracle Software Delivery Cloud), and follow the on-screen prompts to install the following options:
Install License Server
Install Informatica Product
Note: You must install these options in the order that they are displayed.Select Install License Server, click Next to continue, then do the following:
Browse to the installation directory where you want to install the License Server, then click Next.
Enter the host name and port number for the License Server.
Verify the installation summary details on the next screen that displays, then click Install.
When installation is complete, you are prompted to start the License Server. Click No to close the prompt, then Finish to return to the main installer window.
Copy the OEM license key file downloaded from Oracle Software Delivery Cloud to the following location:
<Drive:>\InformaticaIR\licenses
Set the environment variable SSALI_MZXPQRS to STANISLAUS (system variable).
Start the License Server by selecting, for example, the following:
Programs, Informatica, Identity Resolution V2.8.07 (InformaticaIR), Informatica License Server, and then Start.
Select the Install Informatica Product from the main installer window, click Next to continue, then do the following:
When prompted to specify the path to the OEM license, browse to the
[installation_media_directory]\data\file1003.dat
file, and then click Next to continue.Enter the host name and port number for the License Server (or accept the default), then click Next.
Browse to the installation directory where you want to install Informatica Identity Resolution, then click Next.
The next screen displays a list of components, click Select All, and then Next.
The next screen displays an installation summary of products and modules that you want to install. Review the details and click Next to confirm that they match your requirements.
Make sure to add XML Synchronization server at port 1671. This server is not set by default. Click Next when done.
Select default port values for all servers.
On the next screen, enter database information, as follows:
Service Name: Enter the database service name on Informatica Identity Resolution. This is used when configuring SIEBEL instances.
ODBC Data Source Name: Enter the ODBC Connect String name if using ODBC (the ODBC Data Source name is required only when connecting through ODBC).
ODBC Driver: Select the applicable database driver from the drop-down list (the ODBC driver name must be provided even when ODBC is not being used).
Native Service: Enter the name for the database connection as defined in
dB Client\ Server
utilities (for example: for Oracle an databases, this is the TNS entry name).Example settings when using an Oracle database are:
Service Name: target ODBC Data Source Name: ODBC Driver: Oracle 9 (or later) client software Native Service Name: <tns_entry>
Note: All configuration information entered in this step is written to the odbc.ini file. Creating Database Users and Tables for Oracle Data Quality Matching Server shows some example odbc.ini configurations.Click Next to start the installation.
Click Finish to complete.
Post installation, do the following:
Install the hot fix on top of the Base Installer for Informatica Identity Resolution 2.8.07. Make sure that you apply the latest Informatica Identity Resolution fix, which is available on Oracle Software Delivery Cloud.
C:\InformaticaIR\bin>version SSA-NAME3 v2.8.07 (FixL106) SSA-NAME3 Extensions v2.8.07 (FixL106) Data Clustering Engine v2.8.07 (FixL106) Informatica Identity Resolution v2.8.07 (FixL106 + FixL113 + FixL114 + FixL120 + FixL123 + FixL124 + FixL125 + FixL126 + FixL127 + FixL134 + FixL136 + FixL140 + FixL141 + FixL145 + FixL147 + FixL148)
Rename xsserv.xml.org located in
<drive>\InformaticaIR\bi
n to xsserv.xml. This file has a sample format. Change it to match the following:<server xmlns="_http://www.identitysystems.com/xmlschema/iss-version-1/ xmlserv"> <mode>generic</mode> <rulebase>odb:0:db_username/db_password@ISS_connectstring</rulebase> </server>
Note: If you do not make these changes to xsserv.xml, then errors might occur using legacy SIEBEL-ISS Sync workflows.