topic Re: Avaya Split/Skill Data in Developer

Avaya Split/Skill Data

TechPain — Fri, 11 Nov 2022 14:47:49 GMT

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.

Re: Avaya Split/Skill Data

v-jianboli-msft — Mon, 14 Nov 2022 05:09:08 GMT

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.

Re: Avaya Split/Skill Data

TechPain — Thu, 17 Nov 2022 18:31:10 GMT

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