I thought an OnBase reseller once showed me that WorkView data providers (via Module Associations) creates a SQL View that can then be queried by non-OnBase reporting tools for reporting needs (use case would be outside reporting tool combining data from multiple sources outside of OnBase). So I built a quick WorkView app, added in a module association, created a Workview data provider in Unity and finally built a dashboard to display the grid data. However, I am not seeing a HSI table or view created. I was able to see the SQL query itself with DiagConsole on the app server, from which I can retrieve the data in SSMS.`
1) Was I told wrong that a view or table would be created with this method?
2) If we need a non-OnBase reporting tool to query this information, is there a method to get this query outside of what I described above?
Thanks for any help in trying to improve this query process.
