Symantec DLP integration failure on schema owner

Products

• Information Centric Analytics

Issue/Introduction

When using the New Connection Wizard in the Risk Fabric console (Admin > Integration > Data Sources > Choose Data Source | Symantec Data Loss Prevention) to create an integration with Symantec Data Loss Prevention (DLP), the following error is displayed on the Progress and Finish page:

The connection to the Symantec Data Loss Prevention database failed.

protect was passed in as the schema owner for Linked Server = RISKFABRIC_DLP_RISKFABRIC_<hostname>_PROTECT, which does not exist

Environment

Release : 6.x

Component : Symantec DLP Integration Pack

Resolution

When connecting to an Oracle database hosting only the PROTECT schema for the Symantec DLP database, no DLP Schema Owner should be specified under API Settings in the New Connection Wizard. Removing the DLP Schema Owner name will resolve the error and enable the wizard to create the DLP linked server in SQL Server.

If multiple schema owners are hosted in Oracle, you can identify the correct schema owner for the DLP database by executing the following command in SQL*plus:

SELECT DISTINCT OWNER FROM dba_objects;

NOTE: The schema owner name is case sensitive. Enter the schema owner name in the New Connection Wizard exactly as it is returned by the preceding query.