0 Replies Latest reply on Jun 8, 2016 2:42 AM by 3254129

    Integrating data between two data warehouse using ORDS

    3254129

      We want to integrate data between two data warehouse  (example Accounting Warehouse with Finance service warehouse across conformed dimension). The architecture guidance is not store or not do the ETL for moving the data. We already have other third party tool which create the rest data service on top of the data warehouse (Oracle database).

       

      So the option we want to explore is to consume the rest data service from both the data warehouse using ORDS and integrate it virtually before sending it to other reporting and we application

       

      Anyone have experience in integrating data for data warehouse using ORDS or use something similar please provide the guidance/suggestions.

       

      Please let me know if any other details is required.

       

      Thanks