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