Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Translate SQL of OTBI in ApplicationDB HCM

54
Views
1
Comments

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

  • Vijaya Kumar-70229
    Vijaya Kumar-70229 Rank 2 - Community Beginner

    Hi Giuseppe,

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

    Regards,

    Vijay S