Hi, yes that is what I’m trying to understand if it is necessary to create the universe or you can just write queries against relational database (in my case, it is Azure SQL DB)
I was reading about the Freehand SQL but not very sure about its limitations.
are there any limitation on using freehand SQL?
Say, I have some reports that are already built locally against SQL database.
(so SQL queries are already available)
we are migrating local SQL database to Azure, and will use Webi to generate same reports from Azure SQL database.
In that case, I was assessing the various options and which option would allow to re-use maximum what we already have.
If I re-write all the presentation and business logic in Webi Report
and use Freehand SQL to re-use existing queries to get the data from Azure SQL DB to Webi.
Is it feasible? are there any considerations for that approach (like performance or limitations)
Thank you very mcuh
WebiLearner (BOB member since 2020-08-21)