Table of Contents

Search

  1. Preface
  2. Installation Overview
  3. Installing Identity Resolution
  4. Post-Installation Tasks
  5. Troubleshooting
  6. Upgrading Identity Resolution
  7. Uninstalling Identity Resolution

Installation and Configuration Guide

Installation and Configuration Guide

Step 3. Define an ODBC Data Source

Step 3. Define an ODBC Data Source

You must define an ODBC data source on the Search Server to connect to Oracle. The
Identity Resolution
components access the database through ODBC except the
Identity Resolution
Table Loader, which directly loads data into the database. You must create ODBC data sources for each database that you plan to access.
To define an ODBC data source, open the
odbc.ini
file that you can find in the
<Identity Resolution Installation Directory>\bin
directory, and add or update the following database entries:
[<Service Name>] driver = <ODBC Driver> server = <Native Database Service> ServerName=<Oracle Database Instance>
Configure the following parameters:
Service Name
Service name that
Identity Resolution
uses to refer to the database service.
ODBC Driver
Name of the ODBC driver that communicates with the database. The driver name does not include the directory path.
Use one of the following values:
  • On Windows.
    sqora32.dll
  • On UNIX.
    libsqora.so
Native Database Service
Name of the database service that you configure in the database.
Oracle Database Instance
Name of the database instance. The
Identity Resolution
installer uses the same value as that of the database service.
You can find a sample configuration file,
odbc.ini.ori
, in the following directory:
  • On Windows.
    <Identity Resolution Installation Directory>\bin
  • On UNIX.
    <Identity Resolution Installation Directory>/bin
If you use multiple databases, add the database entries for each database. For example:
[oraclesrc] driver = ssaoci9.dll server = oraclesrc [oracletgt] driver = ssaoci9.dll server = oracletgt