As ODBC only supports a small portion of what Integrator supports, and there is sometimes a need for presenting relational data to an end user (hence ODBC), it would be great to have a possibility of presenting any table based data from Integrator extracts and transforms in a Web Spreadsheet. If exposed via spreadsheet function, this could be used directly as a source for e.g. DynaRanges.
It must consider specifying variables (e.g. like in Hyperlink with <name>,<value> pairs).
In version 2023.4, a new function (integrator_get_data) has been added to the macro engine. It can be used to retrieve data from an Integrator component (extract or transform) in a Jedox Web report. For greater ease of use and consistency in the product, couldn't we add the ability to connect to these Integrator components directly from a Dynarange?