How to encrypt connection strings

Introduction

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

Requirements

• SharePoint TemplateSettings and Content Management for Anywhere365, based on SharePoint server or SharePoint Office 365 V 6.2
• CoreThe Core is the center of Anywhere365. It manages all the Dialogues. V 6.6

Instructions

Create Encryped Token list

1. Open your UCCUCC stands for Unified Contact Center and consists of a queue that can be handled by Agents Each Contact Center has its own settings, interactive voice response questions and Agent with specific skills. Agents can be member of, or sign up to, one or more Contact Centers. 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

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

3. Change to

   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};