Creating the External Data Mart database

Last Updated : Aug 14, 2023 |

About this task

Use this procedure to create the External Data Mart (EDM) database.

Note:

Context Store database tables store all data in ASCII format. To enable Context Store EDM to store a language that uses Unicode characters, the database administrator must set the correct collation type for the desired language on the database. You must configure the collation type before creating the EDM schema.

Procedure

  1. Log in to the primary Avaya Control Manager SQL Server.
  2. Click Start > Microsoft SQL Server > Open SQL Server Management Studio.
  3. In the Object Explorer pane, click Connect > Database Engine.

    SQL Server Management Studio displays the Connect to Server dialog box.

  4. In the Server name field, select the local instance of SQL Server.
  5. In the Authentication field, select SQL Server Authentication.
  6. In the Login and Password fields, enter the system administrator credentials.

    The system administrator is usually the default sa user created during SQL Server installation.

  7. Click Connect.
  8. In the Object Explorer pane, expand Databases.
    Important:

    Do not point your Avaya Oceana® to the new EDM until EDM configuration and migration is complete. EDM configuration and migration also include creating an optional non-sa user and adding the EDM into Windows AlwaysOn Advanced Availability Group (AAG).

  9. Right-click Databases and click New Database.

    SQL Server Management Studio displays the New Database dialog box.

  10. In the navigation pane, click General.
  11. In the Database name field, enter a name for the EDM database.
  12. In the Database files section, do the following:
    1. For File Type = ROWS Data, click the three dots to the right of the Path field.
    2. Browse to the correct folder and click OK.

    To change the initial size for the EDM Data file, click the arrows to the right of the Initial Size (MB) value for File Type = ROWS Data and change the default value. For example, for 300 GB, enter 307200.

  13. In the Database files field, do the following:
    1. For File Type = LOG, click the three dots to the right of the Path field.
    2. Browse to the correct folder and click OK.

    To change the initial size for the EDM Log file, click the arrows to the right of the Initial Size (MB) value for File Type = LOG and change the default value. For example, for 20 GB, enter 20480.

    Ensure that hourly transaction log backups are taken. You can download the SampleSQLServerAgentScripts.zip from https://support.avaya.com/ or https://www.devconnectprogram.com/. For more information on configuring the SampleSQLServerAgentScripts, see the Configuring automated SQL Server Agent jobs topic in the Deploying Avaya Oceana® document.

    You must also create the same paths and folders for EDM data files and log files on the secondary SQL replica before adding the EDM to AAG.

  14. In the navigation pane, click Options.
  15. In the Collation field, select the appropriate option or leave as default.
  16. In the Recovery model field, select Full.
  17. Click OK.