This article will show you how you can query data in OBIEE through a database client application.
This is actually really handy when you want to:
Below is a step by step made with the database IDE Dbeaver. You will:
On a detailed technology side, the connection is made to the OBIS (Oracle BI Server) via JDBC. You can see this service (ie OBIS) as a database that you can only query (SELECT). You will query the presentation layer with the SQL of OBIEE (logical SQL) (ie of OBIS).
This blog is a complement to the JDBC page of OBIS: OBIS - JDBC
Download the installer for your computer and run it.
where:
Example:
select
Address.City,
Orders.OrderQty
from
"Adventure - SalesOrderDetail".Address as Address,
"Adventure - SalesOrderDetail".SalesOrderDetail as Orders
That's it. I hope you enjoyed it and that you got as much fun as I got when I discovered this feature.
Have a nice day
Nico