I am defining a business intelligence framework, but I want to define the most commonly used standard tools that will allow me to optimize development.
there are several databases from different manufacturers, for the ETL I am thinking of using the integration service, or its variant in oracle. But I don't know how much limitation or ease of use it has for different data sources, such as pdf files, excel, rest api resources, non-sql bbdd, bigdata, etc.
I saw that power bi, it connects to almost everything, and it is very dynamic I would like to use power bi for ETL and reporting, but I know that it is not scalable, nor centralized, nor is it used for robust solutions because it does not support it (it is not developed For that).
What opinions and suggestions could you give me,
thank you very much.