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.