You are currently viewing OTBI Direct Database Query feature removal and fix Obsolete
OTBI Direct Database Query feature removal and fix Obsolete

In one of the earlier posts Direct Database Query, we saw how to use the Direct Database Query feature of OTBI analytics. This feature has been removed from 19A, so if you have upgraded or planning to upgrade to 19A, remember that the reports created using this feature will not be supported post upgrade.

Oracle has suggested moving these analytics to subject area based analytics. I do not know the exact reason for removing this useful feature. This was most widely used when we need to get the complete output of a query without having to create data model and BI Report.

Oracle has provided us with a 12 month temporary window to have this feature post upgrade to 19A.

snap1 - OTBI Direct Database Query feature removal and fix Obsolete


Steps for Temporary Fix:

snap2 - OTBI Direct Database Query feature removal and fix Obsolete
snap3 - OTBI Direct Database Query feature removal and fix Obsolete


Future Product Direction

Direct database query is not a supported OTBI feature for building reports. Customers are encouraged to use BI Answers to create interactive analyses, use BI Publisher for fixed-format reports and use BI Cloud Connector (BICC) for data extraction. If customers have created OTBI reports with Direct Database Query option, Oracle development strongly recommends migrating those reports to use OTBI subject areas as Direct Database Query will be deprecated in OTBI in 12 months.

This feature is no more valid now. Keeping it on website for tracking that we had such feature in the past.

If you have any questions, please feel free to reach out to me by posting in comments section.

If you are interested in learning Fusion Technical tools go through this post

If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.