ODBC Driver
The Oracle Data Quality Matching Server uses Open Database Connectivity (ODBC) to access source and target databases. ODBC Drivers for specific databases must be installed and working. Installing and configuring ODBC drivers is operating system and database dependent. Unless a driver is provided by Oracle Data Quality Matching Server (as is the case for an Oracle database), you must follow the instructions provided by your database manufacturer in order to install them. On Windows operating system, navigate to Control Panel, Administrative Tools, and then Data Sources (ODBC) to create a DSN and associate it with a driver and database server.
At run time, the database layer attempts to load an appropriate
ODBC driver for the type of database to be accessed. The name of the
driver is determined by reading the odbc.ini file and locating a configuration
block matching the database service specified in the connection string.
For example, the database connection string odb:99:scott/tiger@ora920 refers to a service named ora920. A configuration block for [ora920]
looks similar to the following;
[ora920]
ssadriver = ssaoci9
ssaunixdriver = ssaoci9
server = ora920.mydomain.com
A configuration block has the following syntax:
[Service_Name]
DataSourceName = ODBC_DSN
ssadriver = ODBC_Driver
ssaunixdriver = ODBC_UNIX_Driver
server = Native_DB_Service_Name
Creating Database Users and Tables for Oracle Data Quality Matching Server shows the databases supported by Oracle Data Quality Matching Server, describes the ODBC drivers required for different operating systems, and shows example odbc.ini configurations.