What is the approach to integrate ERP SaaS Cloud data with the on-premise data warehouse or data war
SummaryWhat is the approach to integrate ERP SaaS Cloud data with the on-premise data warehouse or data warehouse cloud
Would like to know what is the approach others following to integrate ERP data (Financials, Procurement, Supply Chain, etc.) with their data warehousing systems?
When our source system was on premise and have back end access to, we used DB links to pull data from source tables into data warehousing database.
But, as we don't have back end access to Cloud, Shall we create BI reports for each table to extract data from cloud and import into on-premise? or does Oracle provide any other options to integrate data with other data warehouse systems? Which is the best data warehousing solution that can be best used with Oracle ERP SaaS cloud?