Translate SQL of OTBI in ApplicationDB HCM

Giuseppe 1234

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

Vijaya Kumar-70229

Hi Giuseppe,

You can use the Data Sync Tool  to get your requirement.\

Regards,

Vijay S