How to Integration between Oracle Cloud ERP fusion with Power BI
Summary:
Do we have a direct way to enable Power BI to access directly DB tables in oracle ERP as select other than webservices? Also there is a tool for integration called SSIS in Microsoft that have ability to search directly on Fusion -check following URL "https://cdn.cdata.com/help/KSK/rssis/", Is this tool requires any additional license or cost and if it is capable to fetch the whole table data on daily base? Do we have any other approach to move the whole table data from Fusion to Power BI for many tables daily?
And what is the best practice to achieve this, Previously It was fetching these tables whole data from EBS via DP Links, Can you advice what is the best practice way to achieve this avoiding time and cost complexities
1