Deploy External Data Mart overview

Last Updated : Aug 14, 2023 |
The EDM can be deployed in one of the following supported configurations:
  • Standalone EDM non-DB HA: EDM is deployed alone on one SQL Server.
  • Standalone EDM DB HA: EDM is deployed alone on two SQL Servers.
  • EDM/ACM co-res DB HA: EDM is deployed co-res with the ACM databases on two SQL Servers.
Note:
The co-resident deployment of Avaya Control Manager databases and the EDM is not supported in a non-DB HA configuration (one SQL Server per Datacenter) in production environments.
Avaya Oceana® provides High Availability (HA) of Context Store External Data Mart (EDM) when:
  • EDM is installed co-resident with Avaya Control Manager databases on Microsoft SQL Server using Microsoft SQL Server Enterprise Edition and Windows AlwaysOn Advanced Availability Groups (AAG).
  • EDM is installed standalone on Microsoft SQL Server without Avaya Control Manager databases using Microsoft SQL Server Standard Edition and Windows AlwaysOn Basic Availability Group (BAG).
Important:
  • For a non-DB HA configuration in production environments, the co-resident deployment of Avaya Control Manager and EDM is not supported.
  • In an availability group, you must have a maximum of two EDM replicas.
The following version combinations are tested for the co-resident deployment using AAG:
Microsoft SQL Server
Database Encryption at REST Support
Version
Edition
2019
Enterprise
Supported through TDE (Transparent Data Encryption). See Transparent Data Encryption (TDE) on External Data Mart.
2017
Enterprise
Supported through either vCenter Encryption or TDE (Transparent Data Encryption). See Transparent Data Encryption (TDE) on External Data Mart.
2016
Enterprise Edition SP2
Supported through vCenter Encryption
The following version combinations are tested for the standalone EDM using BAG:
Microsoft SQL Server
Database Encryption at REST Support
Version
Edition
2019
Standard
Supported through either vCenter Encryption or TDE (Transparent Data Encryption). See Transparent Data Encryption (TDE) on External Data Mart.
2016
Standard
Not supported
Note:
Avaya Oceana® also supports the External Data Mart database running the specified Microsoft SQL Server versions in the table above on any supported version of Windows Operating System.
For supported version combinations, see the following: