Oracle Transactional Business Intelligence

Translate SQL of OTBI in ApplicationDB HCM
Summary
How to Translate SQL of OTBI in ApplicationDB HCM?
Content
Hello,
I have verified that in SA of OTBI there aren't some value that I want to use in a report. I found this in Application table and I want to create a new BI publisher.,I verified that the join between OBIEE dataset and ApplicationDB dataset is very slow. I want to convert my OBIEE data sets in ApplicationDB, is there a tools that extract from my OTBI the physical query with the tables of ApplicationDB?
Thanks
Giuseppe
Comments
-
Hi Giuseppe,
You can use the Data Sync Tool to get your requirement.\
Regards,
Vijay S