Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integrating data between two data warehouse using ORDS

3254129Jun 7 2016 — edited Jun 8 2016

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

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2016
Added on Jun 7 2016
0 comments
432 views