Configuring Oracle Data Quality Matching Server on UNIX

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

To configure Oracle Data Quality Matching Server for data matching on UNIX

1. Copy the most recent version of the shared library libssaiok.so (libssaiok.sl on HP-UX) to the SSA-NAME3 bin directory.

   If the version packaged with IIR is more recent than the one packaged with SSA-NAME3, copy the ssaiok shared library from the IIR server distribution to the SSA-NAME3 bin directory as follows:

   cp $SSATOP/common/bin/libssaiok.* $SSAN3V2TOP/bin
   

   No action is required if the version packaged with IIR is older than the one packaged with SSA-NAME3.

2. Set the shared library path according to your operating system.

   The following table shows examples of shared library paths.

   Operating System	Shared Library Path
   Linux and Oracle Solaris	LD_LIBRARY_PATH="$SSABIN:$SSANM3BIN:<DBMS shared object location>" export LD_LIBRARY_PATH
   HP-UX	SHLIB_PATH="$SSABIN:$SSANM3BIN:<DBMS shared object location>" export SHLIB_PATH
   AIX	LIBPATH="$SSABIN:$SSANM3BIN:<DBMS shared object location>" export LIBPATH

3. If required, modify the odbc.ini file to contain the ODBC connection string of your target database:

   1. Copy the odbc.ini.ori file located in the $SSATOP/bin folder, and rename it odbc.ini.

   2. Edit the odbc.ini to contain the ODBC connection string of your target database, for example, as follows:

      [Target]
      ssaunixdriver=ssaoci9
      server=<TNS_entry_name_from_tnsnames.ora>
      

      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). Most UNIX installations do not need the ODBC DSN, but if required, parameters change accordingly:

      [Target]
      DataSourceName=ODBC_DNS_Name_Pointing_to_ISS_DB
      ssaunixdriver=<ssaoci9>
      

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

      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.

4. Copy the System Definition File (SDF) to the UNIX server.

   Make sure that the SDF file is compressed before using FTP to copy it to the UNIX server. You must use the -a switch to extract a file on a UNIX server, for example, as follows:

   unzip - sysdeffile.zip