ERP and SCM Cloud Data Extracts to on-premise data warehouse
SummaryNeed advice on best option for extract data from ERP/SCM Cloud to on-premise wartehouse. Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise.
Need advice on best option for extract data from ERP/SCM Cloud to on-premise data warehouse.
Looked at BI Cloud Connect, but believe that requires a UCM Server on-premise. Which would mean a new license as well ?
Reviewed the Financials Data Extract (Oracle Support 2303683.1). This sounds like a possibility as it also mentions the possibility of using custom BIP reports through the ERP Integration Services.
We plan to have Oracle Autonomous Integration Service and would prefer to put extracts through that for visibility. However, I am keen to find a solution, relatively 'out of the box', rather than developing multiple extracts from scratch (probably unavoidable).