Integration

Get Involved. Join the Conversation.

Topic

    Robert Cruickshank
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Topic posted December 29, 2018 by Robert CruickshankGreen Ribbon: 100+ Points, tagged Adapters, Agent, Cloud, Connection, Database, E-Business Suite, ERP Cloud, Integration, Mapping, SOAP, xml 
    65 Views
    Title:
    ERP and SCM Cloud Data Extracts to on-premise data warehouse
    Summary:
    Need 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.
    Content:

    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).

    Would Data Integration Platform Cloud (DIPC)  also be a good fit? I think so, but think it is probably overkill for the simplicity of incremental data extracts.

    Note HCM Extracts is another option for HCM Data, is their the same for SCM and Financials data?

    rgds

    Rob