Forum Discussion
Avaya Split/Skill Data
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.
2 Replies
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 GuideBest Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not what i was looking for, but Thank You... 🙂
