Operations Guide

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

Back Next

odb: Interface - ODBC

The

Interface_specific

information uses the following syntax:

SystemQualifier:Userid/Password@Service

The

Interface_specific

information uses the following values:

SystemQualifier: A number between 0 and 99, which qualifies the names of any database objects that
Identity Resolution
creates.
The default
SystemQualifiers
for the Rulebase and Database are 0 and 1 respectively. They must be different. For information about the naming conventions, see the Database Object Names
section.
Userid: User name to access the database.
Password: Password for the user name.
Service: Name of the service that you specify in the
odbc.ini
file.

For information about ODBC configuration, see

Informatica

Identity Resolution

Installation and Configuration Guide

For example,

odb:0:scott/tiger@server

specifies an ODBC host DBMS. Identity Resolution prefixes the tables that it creates with

IDS_00_

(where the _00_ component is the

SystemQualifier

Identity Resolution

connects to the database identified as "server" using the user id "scott" and a password of "tiger."

Oracle Operating System Authentication

Identity Resolution supports Oracle’s Operating System Authentication. In this scenario, clients can omit the Userid, Password, or Service when connecting to the servers. As the Identity Resolution processes initiate all database connections, they connect to Oracle using the operating system account ID of the user who launched them. Therefore, a user that has been granted access to Oracle must launch the servers.

For example, suppose the Identity Resolution Administrator’s userid is SSA. Oracle is configured with the following parameters:

OS_AUTHENT_PREFIX = OPS$
REMOTE_OS_AUTHENT = TRUE (only if a Service is specified)
An

An Oracle Userid

OPS$SSA

is created with the appropriate privileges required by Identity Resolution. When a client specifies a Rulebase name of

odb:0:/@server734

and the host/port number of Rulebase Server, the server connects to Oracle using the Administrator’s userid and password. All database objects created by the server are in the

OPS$SSA

schema.

Rulebase and Database Names

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal