Checklist for the co-resident deployment of Avaya Control Manager and EDM

Last Updated : Jul 08, 2022 |
Note:
This checklist is for new Avaya Oceana® customers only.
For upgrading from a previous version of Oceana and migrating your database, see Upgrading Avaya Oceana®.
No.
Task
Description
1
Get the vCPU, memory, and hard disk space required for Microsoft SQL Server based on your Avaya Oceana® deployment size.
See Avaya Oceana hardware requirements.
2
Deploy Avaya Control Manager and configure the Avaya Control Manager database SQL Server cluster.
See Installing Avaya Control Manager for Enterprise - Multiplex High Availability.
3
Create database tables for External Data Mart (EDM).
See Creating database tables for External Data Mart.
4
Create an optional non-system administrator user on the primary Avaya Control Manager SQL Server.
See Creating a user on the primary Avaya Control Manager SQL Server.
5
Create the EDM Advanced Availability Group on Avaya Control Manager SQL Server.
See Creating the EDM Advanced Availability Group on Avaya Control Manager SQL Server.
6
Create an optional non-system administrator user on the secondary Avaya Control Manager SQL Server.
See Creating an EDM user on the secondary Avaya Control Manager SQL Server.
7
Generate certificates from System Manager to secure the connection between Context Store and Microsoft SQL Servers.
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.
8
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.
9
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
10
Configure automated SQL Server Agent jobs.
See Configuring automated SQL Server Agent jobs
11
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
12
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.
Note:
When installing SQL Server on virtual machines, Avaya recommends reading VMware's best practices published at https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf. A summary of these recommendations includes:
  • Store database Log files and database Data files on separate disks. This avoids I/O contention and improves performance.
  • Install SQL Server and the Windows operating system on the same disk.