I am trying to understand how the three tools Alteryx, Denodo and Azure Data Factory overlap or complement each other?
We have lots of different data sources with not much data volume but complex data structures from .xls, DB2, SQL Server, OLAP cubes, data via API's and we are looking to find a new way on how to best extract all this data and have our end users report with Power BI out of it.
I assume the underlying best data warehouse would be MS Azure Synapse Analytics. Or is there another data warehouse solution that would make more sense?
Data load volume should not be an issue but the performance of report creation is still a concern.