How to combine data from multiple Netprobes to create a new dataview
Users can consider using the Gateway-SQL plug-in. It allows users to create new dataviews using existing dataviews as source. The Gateway-SQL plug-in is part of the Compute Engine functionality of the gateway. It provides a way to summarise and reformat dataviews rather than to monitor the gateway. It uses an in-memory SQLite database to take data from multiple dataviews and combine them to provide a set of new dataviews. A user can configure the plugin to take data from a pair of specified dataviews and combine them using a key column in each dataview. More complex SQL is available including OUTER JOINS, LEFT JOINS, GROUP BY. The Gateway-SQL plugin had been available since version GA3.0.15. We suggest users to use current gateway versions to take advantage of various enhancements and fixes:
- GA3.0.15 (GWX-1949): initial release of Gateway-SQL plug-in
- GA3.1.0 (GWX-2535): added ability to reference headline variables from a dataview
- GA3.4.0 (GWX-2695): added XPath selector that can dynamically allow multiple dataviews to populate a single table.
- GA4.4.0 (AA-1051): expect rows can now be defined on individual dataviews for Gateway plug-ins
- GA4.10.0 (AA-2244): improves the error reporting in Gateway-SQL plug-in Further Reading Users can check out the Gateway-SQL section in Gateway Plug-Ins documentation.