O'Reilly logo

Oracle APEX 4.2 Reporting by Vishal Pathak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Integrating OBIEE with APEX

Integration of OBIEE with APEX can be done using web services, OBIEE's Go URL, or using ODBC connections. There are a number of limitations of the ODBC technique, so a section is not dedicated to it. It is important to understand that if we use ODBC, then, we are leveraging OBIEE's BI Server component, but we are not leveraging OBIEE's Presentation Server component. ODBC method connects to the BI Server component and accesses the presentation tables of OBIEE to query data. The data will be fetched using the relationships established in the BI repository.

The other two methods are web services and Go URL. We will have a look at them now.

Integration using web services

Before we dig into understanding a few web services ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required