Allow users to parse data from a comma-separated list before loading into ICA

book

Article ID: 171380

calendar_today

Updated On:

Products

Information Centric Analytics Data Loss Prevention Core Package

Issue/Introduction

When working with data from systems external to ICA, there are cases where the data being served to ICA is provided in a comma separated list.  ICA provides a function that can be leveraged to parse the data into prior to loading it into ICA.  The target function that can be used is dbo.fnParseDelimitedList. 

Environment

SQL Server

CAUTION: These commands assume a basic understanding of SQL. Any changes to the Database pose the potential to affect the operation of the product. ALWAYS ENSURE YOU HAVE A BACKUP OF YOUR DATABASE BEFORE MAKING CHANGES.

In order for Symantec to provide full support of the schema and the DB environment, you have to be running the DB in the version specific to the used version as outlined in the System Requirements Guide. Please see the limitations section at http://www.symantec.com/docs/TECH220433

Resolution

Use the ICA function dbo.fnparseDelimitedList when bringing data into ICA.  The fnParseDelimitedList will take a comma separated list in this case we are passing a string that contains the days of the week in a comma separated format.  For format for the string is listed as fnParseDelimitedList(StringName,delimeter)