Checklist for the standalone deployment of External Data Mart

Last Updated : Aug 14, 2023 |

No.

Task

Description

1

Configure the required hardware.

For EDM non-DB HA, deploy one virtual machine. For EDM DB HA, deploy two virtual machines.

  • Memory: 16 GB

  • vCPUs: 8

  • Hard disk space: See the Avaya Context Store External Data Mart and Customer Journey Database details in the Avaya Oceana hardware requirements section in Deploying Avaya Oceana®.

2

Install a supported version of the Microsoft Windows Server software on the virtual machine(s).

After installing the Windows Server, run the Microsoft Windows Update program to install any recent updates to the core software.

Hostnames of the EDM database server(s) must follow the Microsoft requirements mentioned on https://support.microsoft.com/en-us/help/909264/.

3

Configure a Windows Server Failover Cluster to include both Windows virtual machines.

Note:

This step is applicable only when configuring EDM DB HA.

See Configure Windows Server Failover Cluster.

4

Install and configure a supported version of Microsoft SQL Server Standard Edition.

See Install Microsoft SQL Server Standard Edition.

5

Create the External Data Mart (EDM) database.

See Creating the External Data Mart database for the standalone deployment.

6

Create database tables for External Data Mart (EDM).

See Creating database tables for External Data Mart.

7

Create an optional non-system administrator user on the primary EDM SQL Server for Context Store connections to Microsoft SQL Server.

See Creating a user on the primary External Data Mart SQL Server.

8

Configure EDM DB HA using Microsoft SQL Server AlwaysOn software to create a Basic Availability Group (BAG).

Note:

This step is applicable only when configuring EDM DB HA.

See Creating the Basic Availability Group on External Data Mart SQL Server.

9

Create an optional non-system administrator user on the secondary EDM SQL Server for Context Store connections to Microsoft SQL Server.

Note:

This step is applicable only when configuring EDM DB HA.

See Creating a user on the secondary External Data Mart SQL Server.

10

Configure and install SSL certificates from System Manager to Microsoft SQL Servers.

Note:

This step is applicable only when configuring EDM DB HA.

For EDM non-DB HA, see the Transport Layer Security encryption checklist section in the Avaya Context Store Snap-In Reference Guide.

See Generating certificates to enable SSL connections fromContext Store to a cluster of two SQL Servers hosting EDMs configured in an AlwaysOn High Availability group.

11

Change the SQL server to use the new certificate by configuring MS SQL Server for forced encryption.

See Configuring MS SQL Server for forced encryption.

12

Enable Transparent Data Encryption (TDE) on EDM.

Note:

TDE is an alternative to using VMWare encryption when VMWare encryption is not possible. For example, a CPOD deployment.

See Transparent Data Encryption (TDE) on External Data Mart

13

Configure automated SQL Server Agent jobs.

See Configuring automated SQL Server Agent jobs

14

Load a JDBC-compatible driver jar file, configure the driver on System Manager, and then install the driver on the Context Store cluster.

See Loading JDBC driver to System Manager

15

Configure the OceanaConfiguration and ContextStoreManager attributes in System Manager to enable connection from Context Store to EDM.

See Setting attributes to enable connection from Context Store to EDM.