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. Snapshot data is polled from specific APIs every 10 seconds and stored in real time tables.
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 and Real Time reports have a direct connection to the reporting datamart, containing data of the current day (intraday) and the last 24 hours (real time) and are refreshed by the ETL and snapshot process.
Power BI user access
Power BI users can access the CCBI Reports from everywhere and on any device.
Premium licenses for Power BI users are required to use “automatic page refresh”. This is essential for Real Time reports and helpful for Intraday reports.
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.