How to redirect the UA Dedup Database connection

Products

• CA Security Command Center
• CA Data Protection (DataMinder)
• CA User Activity Reporting

Issue/Introduction

There may be some scenarios where it becomes necessary to host a CA Data Protection Universal Adapter (UA) SQL database on a different physical server. For example, where old hardware is being decommissioned or the hosting architecture is being upgraded. This article outlines the steps required to redirect the Database connection?

Environment

CA Data protection 15.x

Resolution

The following assumes that you have copied the De-duplication database to its new location and applied the relevant security permissions to the Database as per the original.


1. Stop the "CA Data Protection Universal Adapter" service.

2. Use "Regedit.exe" program to edit the registry.

3. Navigate to the following registry hive.

HKLM\SOFTWARE\Wow6432Node\ComputerAssociates\CA DataMinder\CurrentVersion\UniversalAdapter\DeDuplicationDatabase

The strings present are

ServerName : <ServerName>
ServerPort : <Port>
ServerType : MSSQL

In your scenario these should be updated to:

ServerName : SQLServer\DLP
ServerPort : 1433
ServerType : MSSQL

3. Restart the "CA Data Protection Universal Adapter" service. When it has been restrated it will take the information above and it will transpose it into the ODBC.ini settings in the key

HKLM\SOFTWARE\Wow6432Node\ODBC\ODBC.INI\UA_DDUP

But if you need to populate the settings manually it should look simliar to the ones below

Database: UA_DDUP
Driver: C:\Windows\system
LastUser: AUser
Server: SQLServer\DLP
Trusted_Connection: Yes

 

Additional Information

You may also be interested in the following Knowledge document.

How to redirect the SQL Database connection for Data Protection


Note:
Orchestria, Orchestria APM, Orchestria EPM, CA DLP and CA DataMinder are all brands now known as CA Data Protection