A number between 0 and 99, which qualifies the names of any database objects that
MDM Registry Edition
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
MDM Registry Edition
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
).
MDM Registry Edition
connects to the database identified as "server" using the user id "scott" and a password of "tiger."
Oracle Operating System Authentication
MDM Registry Edition supports Oracle’s Operating System Authentication. In this scenario, clients can omit the Userid, Password, or Service when connecting to the servers. As the MDM Registry Edition 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 MDM Registry Edition 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 MDM Registry Edition. 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