Avaya Split/Skill Data

[TechPain]

good day,

i've been tasked with ingesting data into SQL table for avaya split/skills and agent data. My thing is i've never worked CMS, so i'm wondering if anyone can shed some light on how to structure the data in SQL for analytics purposes. There are over 100+ columns.

[v-jianboli-msft]

Hi @TechPain ,

Here is a documnent about Avaya CMS, hope it could give you some  help:

Avaya™ Call Management System (CMS) Open Database Connectivity 

Here are some articles about basic knowledge which might help you in structure the data in SQL:
Tables (You can click on the directory on the left to view more content.)
Table Relationships
Primary and Foreign Key Constraints
SQL Server Index Architecture and Design Guide

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TechPain]

 Not what i was looking for, but Thank You... 🙂