How to encrypt connection strings

Introduction

With Anywhere365 you can also encrypt your connection string for your CDR information.

Requirements

• SharePoint Template V 6.2

• Core V 6.6

Create Encryped Token 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. Select Add an App

5. Select Custom List

6. Enter EncryptedTokens as name

7. Select Create

8. Open the EncryptedTokens list

9. Add the following columns. (You can change the name later)

   1. Key

      1. Name: wsp_ucc_et_key

      2. Type: Single line of text

   2. Value

      1. Name: wsp_ucc_et_value

      2. Type: Single line of text

Add Encrypted Token

1. Open the EncryptedTokens list

2. Add new item:

   1. Title: "Whatever you find suitable for a title"

   2. Key: {encryptedTokenKeyName}

   3. Value: xoZ9HvpaP5eGPALVdZzVJA== (Created with A365.PWTool.exe)

Encrypt CDRConnectionString

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={encryptedTokenKeyName};

Your password is now encrypted.

You can have multiple encrypted tokens in 1 connection string.

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