Creating database tables for External Data Mart

Last Updated : Apr 14, 2021 |

About this task

To use the External Data Mart feature, you must use the supported databases, the respective supported versions, and create the required database tables.

Note:

The Microsoft SQL database user configured for the EDM feature must have database ownership or system administrator privileges for this connection to be successful. Also, from the security profile of the database user, you must set the Context Store database as the default database.

Procedure

  1. Download the ContextStoreSchemaCreationScripts-SQLServer.zip file from Avaya Support.
  2. Copy the zip file to the server running the MS SQL Server.
  3. Extract the zip file and locate the SQL script: CreateEDMschema.sql.
  4. Open SQL Server Management Studio and do the following:.
    1. On the File menu, click Open to open the file.
    2. Click Execute or click Query > Execute to run the file.
  5. Create database tables for External Data Mart by executing the CreateEDMschema.sql script.