When working in a BI environment there are situations where developers need to query the production database. Such thing is not possible in many cases as access is restricted by tight security settings. Fortunately (for developers), OBIEE 11g has some back doors that can be used to win access to the underlying data sources, even if we don’t know the Connection Pool password.
In previous versions of OBIEE we could access the data sources by issuing a “Create Direct Database Request”. In OBIEE 11g, apart from this back door, we can also issue a query to the Physical Layer. Let’s see the difference between them and how the latter works in more detail.
