Installation Guide for Oracle Database with Red Hat JBoss

10.4 HotFix 1

Back Next

Register an Operational Reference Store

After you create an

Operational Reference Store

, you must register it through the Hub Console. Register an

Operational Reference Store

with a single

MDM Hub Master Database

Start the Hub Console.

The

Change database

dialog box appears.

Select

MDM Hub Master Database

, and click

Connect

Under the

Configuration

workbench, click the

Databases

tool.

From the

Write Lock

menu, click

Acquire Lock

In the Databases pane, click the

button.

The

Informatica MDM Hub Connection Wizard

appears.

Select the

Oracle

database type option, and click

Configure connection properties for the database.

Select an Oracle connection method, and click

The following table describes the Oracle connection methods that you can select:

Connection Method	Description
Service	Connects to Oracle by using the service name.
SID	Connects to Oracle by using the Oracle System ID.

For more information about SERVICE and SID names, see the Oracle documentation.

The

Connection Properties

page appears.

Specify the connection properties for the connection type that you select, and click

The following table describes the connection properties:

Property	Description
Database Display Name	Operational Reference Store name that must appear in the Hub Console.
Machine Identifier	Prefix given to keys to uniquely identify records from the Hub Store instance.
Database hostname	IP address or name of the server that hosts the Oracle database.
SID	Oracle System Identifier that refers to the instance of the Oracle database running on the server. The SID field appears if you selected the SID connection type.
Service	Name of the Oracle SERVICE used to connect to the Oracle database. The Service field appears if the you selected the Service connection type.
Port	The TCP port of the Oracle listener running on the Oracle database server. The default is 1521 .
Oracle TNS Name	Database name on the network as defined in the TNSNAMES.ORA file. You set the Oracle TNS name when you install the Oracle database. For more information about the Oracle TNS name, see the Oracle documentation.
Schema Name	Name of the Operational Reference Store .
Password	Password associated with the Operational Reference Store user name.
DDM connection URL	Optional. URL to connect to the Dynamic Data Masking application. The URL is similar to the URL that you use to connect to the database, except that the Dynamic Data Masking application URL uses the Dynamic Data Masking host name and port number.

The

Schema Name

and the

User Name

are both the names of the Operational Reference Store that you specified when you created the Operational Reference Store. If you need this information, consult your database administrator.

The

Summary

page appears.

Review the summary, and specify additional connection properties.

The following table lists additional connection properties that you can configure:

Property	Description
Connection URL	Connect URL. The Connection Wizard generates the connect URL by default. The following list shows the format of the connect URL for the Oracle connection types: Service connection type. jdbc:oracle:thin:@//database_host:port/service_name SID connection type. jdbc:oracle:thin:@//database_host:port:sid For a service connection type, you have the option to customize and later test a different connection URL.
Create data source after registration	Select to create the data source on the application server after registration. If you do not select the option, you must manually configure the data source. In application server cluster environments, manually create the data sources and connection pools for the Operational Reference Stores.

Property

Description

Connection URL

Connect URL. The Connection Wizard generates the connect URL by default.

The following list shows the format of the connect URL for the Oracle connection types:

Service connection type.

jdbc:oracle:thin:@//database_host:port/service_name

SID connection type.

jdbc:oracle:thin:@//database_host:port:sid

For a service connection type, you have the option to customize and later test a different connection URL.

Create data source after registration

Select to create the data source on the application server after registration. If you do not select the option, you must manually configure the data source.

In application server cluster environments, manually create the data sources and connection pools for the Operational Reference Stores.

For a service connection type, if you want to change the default URL, click the

Edit

button, specify the URL, and then click

Click

Finish

The

Registering Database

dialog box appears.

Click

The MDM Hub registers the

Operational Reference Store

Select the

Operational Reference Store

that you registered, and click the

Test database connection

button.

The Test Database dialog box displays the result of the database connection test.

Click

The

Operational Reference Store

is registered, and the connection to the database is tested.

Hub Server Post-Installation Tasks

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Installation Guide for Oracle Database with Red Hat JBoss

Installation Guide for Oracle Database with Red Hat JBoss

Register an Operational Reference Store

Register an Operational Reference Store