Dialogue Cloud

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