We are using the UMP to create custom dashboards for various uses. Currently we use table objects and have the dashboard execute the SQL queries - this is causing performance issues, we believe. We'd like to offload this so we thought about using the SQL_Response probe for this purpose. I can load the query into SQL Response and it tests successfully, however if I configure a table object to run the same profile then I receive no data.
Is it possible to use the SQL Response probe in this manner?