How to encrypt the SQL CDR Connection Strings

Introduction

With AnywhereNow you can encrypt various individual parts your SQL Connection String for your CDR Call Detail Records (CDR) are the meta data of a converstation: who talked to whom, at which time, for how long and with which identity among other things (skill, optional classification, etc) which gets stored in your SQL (analytical) database. information. This allows you to, for example, encrypt just the Password part of the Connection String or all elements of a connection string like servername, username, etc.

Find Encrypted Tokens list

1. Open your UCC A Unified Contact Center, or UCC, is a queue of interactions (voice, email, IM, etc.) that are handled by Agents. Each UCC has its own settings, IVR menus and Agents. Agents can belong to one or several UCCs and can have multiple skills (competencies). A UCC can be visualized as a contact center “micro service”. Customers can utilize one UCC (e.g. a global helpdesk), a few UCC’s (e.g. for each department or regional office) or hundreds of UCC’s (e.g. for each bed at a hospital). They are interconnected and can all be managed from one central location. config site on SharePoint

2. Open Settings (top-right)

3. Open Site contents

4. Open the EncryptedTokens list

   • The following columns should exist.

     1. Title

        1. Name: Title

        2. Type: Single line of text

     2. Key

        1. Name: wsp_ucc_et_key

        2. Type: Single line of text

     3. Value

        1. Name: wsp_ucc_et_value

        2. Type: Single line of text

Add Encrypted Token(s)

1. Open the EncryptedTokens list

2. Add + new item:

   1. Title: "Enter any unique name as a title" example: SqlCdr password 1

   2. Key: "Technical key name in {} brackets", example: {encryptedTokenKeyName1}

   3. Value: "Encrypted string of the original value" example: xoZ9HvpaP5eGPALVdZzVJA== (Created with A365.PWTool.exe)

Encrypt CDRConnectionString

Single value encrypted as token

1. Open Settings list

2. Edit CDRConnectionString

   Copy

   Connectionstring

   Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password=myPassword;

3. Change to

   Copy

   Connectionstring

   Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;Password={encryptedTokenKeyName1};

Your myPassword value is now stored in SharePoint (and the UCC) only as an encrypted value.

Multiple values encrypted as token

You can have multiple encrypted tokens in 1 connection string.

Server={encryptedTokenKeyName1};Database={encryptedTokenKeyName2};User Id={encryptedTokenKeyName3};Password={encryptedTokenKeyName4};