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:
Users can check out the Gateway-SQL section in Gateway Plug-Ins documentation.
Can you also combine dataviews imported from multiple gateways?
You can combine dataviews imported from multiple gateways in the same way
Please sign in to leave a comment.