Installation and Configuration Guide

10.4.1
- 10.5
- 10.4.0

Back Next

Changing the Credentials for a Database User Account

When you install

Data Integration Hub

, you specify a user name and a user password for the user account

of the

Data Integration Hub

repository database

and of the publication repository database

. If you are running the Dashboard and Reports component, you also specify a user name and a user password for the operational data store user account.

Perform the following steps if you change the credentials for a database user account after you install

Data Integration Hub

. Perform only the steps that are relevant to the changes that you are making. If you are not running the Dashboard and Reports component, skip the steps that are only relevant to this component.

Stop the

Data Integration Hub

services and close the Operation Console.

Verify that the PowerCenter Integration Service is not running any

Data Integration Hub

workflows.

If you are running the Dashboard and Reports component, and you are changing credentials for the

Data Integration Hub

repository or for the operational data store user account, use the PowerCenter Workflow Manager to update the credentials in the following connections:

For the

Data Integration Hub

repository, update the DX_REPO connection.

For the operational data store, update the DX_ODS connection.

If you are changing a password, perform the following steps:

Run the password encryption utility and enter the new password in the following syntax:

On Windows operating systems:

DIH

InstallationDir>\dx-tools\dxpasswd.bat -p <NewPassword>

On UNIX operating systems:

DIH

InstallationDir>/dx-tools/dxpasswd.sh -p <NewPassword>

The password encryption utility encrypts the password and displays an encrypted string. For example,

-->ywo+o3cw8+O3iLdlhPprW2YA==
<--

Copy the encrypted string without the

--><--

indicators to the clipboard.

Open both copies of the

dx-configuration.properties

file from the following locations in a text editor:

<DIHInstallationDir>/DataIntegrationHub/tomcat/shared/classes/

<DIHInstallationDir>/conf/

In both copies of the

dx-configuration.properties

file, perform the following steps:

Search for the text that is relevant to the changes that you are making:

Data Integration Hub

repository:

dx.jdbc.username=<CurrentUsername>

dx.jdbc.password=<CurrentPassword>

Publication repository:

dih.staging.jdbc.username=<CurrentUsername>

dih.staging.jdbc.password=<CurrentPassword>

Operational data store:

dx.dashboard.jdbc.username=<CurrentUsername>

dx.dashboard.jdbc.password=<CurrentPassword>

Replace the relevant value with the new value. If you are replacing a password, enter the encrypted string.

Save and close the files.

The content in both copies of the

dx-configuration.properties

file must be identical.

Start the

Data Integration Hub

Operation Console.

If you are changing the credentials for the operational data store user account, perform the following steps:

In the Navigator click

Administration

System Properties

Change the values of the

dx.dashboard.jdbc.username

and the

dx.dashboard.jdbc.password

properties to the new values. For the password, enter the encrypted string.

Verify that the PowerCenter Integration Service is running.

If you are changing the credentials for the

Data Integration Hub

repository or for the publication repository, perform the following steps:

In the Navigator, click

Hub Management

Connections

The

Connections

page appears.

Click the

Test Connection

icon next to the connection to the repository for which you want to change the credentials.

DIH__REPO. Connection to the

Data Integration Hub

repository.

DIH__STAGING. Connection to the publication repository.

Data Integration Hub

tests the connection. The process might take a few moments.

When the message "Connection successful" shows, click

in the

Test Connection

dialog box.

Start the

Data Integration Hub

Server service.

If you are running the Dashboard and Reports component, perform the following steps to schedule the

Data Integration Hub

operational data store loader workflow:

In PowerCenter Workflow Manager, expand the folder where the operational data store loader workflow is located and then right-click

DX_ETL

Select

Schedule

from the menu and wait until PowerCenter Workflow Manager schedules and runs the workflow.

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

Changing the Credentials for a Database User Account

Changing the Credentials for a Database User Account