We are looking at ways to bring data from ExtremeCloud IQ Site Engine into Microsoft Power BI so we can build operational and executive network dashboards.
Before we start building an integration, I would like to understand how other Extreme customers are doing this.
Our goal is to report and trend information such as:
- Network/device availability and uptime
- Availability by site/location
- Switch and AP status
- Device down events/outages
- Port utilization
- Firmware compliance
- Alarms/events
- ExtremeControl/NAC authentication successes and failures
- Unknown or rejected devices
- Historical network performance and availability trends
For anyone who has integrated Site Engine data with Power BI or another external reporting platform:
- How are you getting the data out of Site Engine?
- Are you using the NBI/GraphQL API, another API, database access, exports, or another method?
- Do you send the data directly to Power BI, or do you store it somewhere such as SQL Server first?
- How are you retaining historical data so you can report on uptime, outages, utilization, authentication failures, etc. over time?
- How frequently are you collecting the data?
- Are there specific Site Engine APIs/queries that have worked well for operational reporting?
- What challenges have you run into with API authentication, performance, data volume, or maintaining the integration?
- If you were building this today, what architecture would you recommend?
We are still in the discovery/design stage and haven't selected an architecture yet. I would especially like to hear from anyone who has already built something similar and can share lessons learned, examples, architecture, or sample queries/scripts.
Thanks!