Architecture

Azure SQL Managed Instance

Webex data extract APIs are called from the SQL Server directly for an incremental ETL process, running every 15 minutes.

All data of a Webex tenant is stored in a SQL database for 4 years by default or also for longer based on request. The SQL database contains a relational reporting datamart including dimension and fact tables of the most important Webex dimensions and data repositories.

It also contains the user- and security configuration of the Webex Contact Center system that grants permissions for the WxCC dimensions.

Customer PBI Workspace Integration

The Power BI Service of the customer (Office 365) integrates directly with the reporting datamart.

All data is refreshed into the Power BI Workspace of the customer up to 8 times a day. Intraday reports have a direct connection to the reporting datamart, containing data of the current day and are refreshed by the ETL process.

Power BI user access

Power BI users can access the CCBI Reports from everywhere and on any device.

Dynamic Row Level Security (RLS) is implemented in the CCBI Semantic Model and offers two security roles, one to grant access to "my own" data and the other one to data based on the WxCC security configuration.