Installation Guide for IBM DB2 with Red Hat JBoss

10.3 HotFix 2

Back Next

Registering 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

IBM DB2

database type option, and click

Configure connection properties for the database.

Specify the connection properties, and click

The following table lists and describes the connection properties:

Property	Description
Database Display Name	Name for the Operational Reference Store that must appear in the Hub Console.
Machine Identifier	Prefix given to keys to uniquely identify records from the Hub Store instance.
Database server name	IP address or name of the server that hosts the IBM DB2 database.
Database name	Name of the database that you create.
Port	Port of the IBM DB2 database. The default is 50000.
Schema Name	Name of the Operational Reference Store .
User name	User name for the Operational Reference Store . By default, this is the user name that you specify in the script that you use to create the Operational Reference Store . This user owns all the Operational Reference Store database objects in the Hub Store. If you created a proxy user, use the proxy user name instead of the Operational Reference Store user name.
Password	Password associated with the user name for the Operational Reference Store . For IBM DB2, the password is case sensitive. By default, this is the password that you specify when you create the Operational Reference Store .
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 example shows the format of the connect URL: jdbc:db2://database_host:port/db_name
Create data source after registration	Select to create the data source on the application server 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.

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 IBM DB2 with Red Hat JBoss

Installation Guide for IBM DB2 with Red Hat JBoss

Registering an Operational Reference Store

Registering an Operational Reference Store