Microsoft Excel is the most important and flexible Reporting Tool. Manifold opportunities to create tables, charts, calculations, etc. bundled with a variety of different skills makes it useful in a lot of different situations. Excel provides a wide range of options to import data from different formats in files, databases or API's.
BVQ now provides an API to connect Excel to Topology information based on favorites located in "All Users". The information can be displayed in a Treetable and imported into Excel for further processing.
- Asset management
- Enrichment with additional data
- Report exchange
To access and explore the API endpoints, the BVQ-Server provides an overview page to display the required URL and all information connected to the favorite.
Reporting → Data sources
Although the API is promoted with Excel it is also possible to connect other systems