Installation and Configuration Guide

10.1
- 10.5 HotFix 2
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1 HotFix 1
- 10.0 HotFix 1
- 10.0

Back Next

Step 2. Define an ODBC Data Source

You must define an ODBC data source on the Search Server to connect to Microsoft SQL Server. The

MDM Registry Edition

components access the database through ODBC except the

MDM Registry Edition

Table Loader, which directly loads data into the database. You must create ODBC data sources for each database that you plan to access.

Open the

odbc.ini

file that you can find in the

<MDM Registry Edition Installation Directory>\bin

directory, and add or update the following database entries:

[<Service Name>]
DataSourceName = <ODBC DSN>
driver = <ODBC Driver>
server = <Native Database Service>

Configure the following parameters:

Service Name: Service name that
MDM Registry Edition
uses to refer to the database service.
ODBC DSN: Data Source Name. If you do not specify any value, it defaults to the service name.
ODBC Driver: Name of the ODBC driver that communicates with the database. The driver name does not include the directory path. Use
sqlncli11
as the ODBC driver name. You can also use the Microsoft SQL Server Native Client as the ODBC driver.
Native Database Service: Name of the Microsoft SQL Server. For example, localhost.

A sample configuration file,

odbc.ini.ori

, is located in the

<MDM Registry Edition Installation Directory>\bin

directory.

If you use multiple databases, add the database entries for each database. For example:

[srcDBcli10] 
driver = sqlncli11 
server = (local) 
DataSourceName = srcDBcli10 

[tgtDBcli11] 
driver = sqlncli11 
server = (local) 
DataSourceName = tgtDBcli11

Open the ODBC Data Source Administrator by performing the following tasks:

From the Windows Control Panel, click

Administrative Tools

In the

Administrative Tools

dialog box, double-click

Data Sources (ODBC)

On the

User DNS

tab or

Service DNS

tab, click

Add

Select

SQL Server

SQL Server Native Client

, and click

Finish

Follow the instructions in the Wizard, and ensure that you enter the following values:

Specify a data source name. Ensure that the data source name matches the data source name that you specify in the

odbc.ini

file.

Select the Microsoft SQL Server authentication and provide the user credentials that you created.

Specify a default database.

Ensure that you do not select the

Use regional settings when outputting currency, numbers, dates and times

check box.

If you want to use the Windows authentication to connect to Microsoft SQL Server, set the SSA_DB_WINDOWS_AUTHENTICATION environment variable to Yes.

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Step 2. Define an ODBC Data Source

Step 2. Define an ODBC Data Source